If you come across the following error sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory execute the following command
sudo sh -c "echo /usr/lib/oracle/12.2/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf";sudo ldconfig
Before we can enumerate the TNS listener and interact with it, we need to download a few packages and tools
the odat.py tool to perform a variety of scans like retrieve database names, versions, running processes, user accounts, vulnerabilities, misconfigurations etc.
You can also attempt to append "as sysdba" for higher privileges
Try using the valid account to log in as the System Database Admin (sysdba), giving higher privileges. This is possible when the user has the appropriate privileges typically granted by the database administrator.