> For the complete documentation index, see [llms.txt](https://strange-1.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://strange-1.gitbook.io/notes/enumeration/oracle-tns-1521.md).

# Oracle TNS - 1521

### **Nmap**

```bash
# nmap scan 
sudo nmap -p1521 -sV IP --open

# SID Bruteforcing
sudo nmap -p1521 -sV IP --open --script oracle-sid-brute
```

### **ODAT**

```bash
./odat.py all -s IP
```

### **SQLplus - Log In**

* [SQLplus commands](https://docs.oracle.com/cd/E11882_01/server.112/e41085/sqlqraa001.htm#SQLQR985)

```bash
# Log in using valid creds 
sqlplus scott/tiger@IP/XE;

# Error sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
sudo sh -c "echo /usr/lib/oracle/12.2/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf";sudo ldconfig

# Oracle RDBMS - Interaction
select table_name from all_tables;

# Database Enumeration
sqlplus scott/tiger@IP/XE as sysdba

# Oracle RDBMS - File Upload
./odat.py utlfile -s IP -d XE -U scott -P tiger --sysdba --putFile C:\\\\inetpub\\\\wwwroot testing.txt ./testing.txt
```