direct connection to oracle database not working

[rpethana]

Describe the bug
when trying to use direct connection with oracle database with this syntax, python sqlmap.py -d "oracle://test:test@xxxxxx:1521/db" -f --banner --dbs --users
getting this 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')

Running environment:

• sqlmap version [e.g. 1.7.2.12#dev] 1.8.8.1
• Installation method [e.g. pip], zip download from sqlmap
• Operating system: [e.g. Microsoft Windows 11], windows 11
• Python version [e.g. 3.11.2]: 3.9.0

Target details:

• DBMS : oracle 19.10
  sqlmap version: 1.8.8.1
  sqlalchemy version: 2.0.32
  cx-oracle version: 8.3.0

is there any workaround ?

[stamparm]

try with the latest revision. not sure that it will work, but try and report what's happening (along with provided options/switches)