oracle database not working

[Imran-imtiaz48]

Bug Description

When attempting to establish a direct connection to an Oracle database using the following command:

python sqlmap.py -d "oracle://test:test@xxxxxx:1521/db" -f --banner --dbs --users

I encounter the following error:

[13:55:47] [CRITICAL] SQLAlchemy connection issue ('DatabaseError: (cx_Oracle.DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor')

Environment Information

• sqlmap version: 1.8.8.1
• Installation method: Downloaded ZIP archive
• Operating system: Windows 11
• Python version: 3.9.0
• SQLAlchemy version: 2.0.32
• cx_Oracle version: 8.3.0

Target Database Details

• DBMS: Oracle 19.10

[stamparm]

i don't know whether your current cx_Oracle installation will cause trouble.

with the latest revision, the preferred way of connecting inside the sqlmap is the python-oracledb. so, sqlmap will first try to use SQLAlchemy (which uses that obsolete cx_Oracle (see here: https://oracle.github.io/python-cx_Oracle/), but then it will try to use the python-oracledb

anyhow, try to install the python-oracledb and retry the connection to your oracle instance with the latest revision of the sqlmap