JDBC Oracle thin connection string

[system]

Originally posted by armygrad on February 06, 2023

HI

I have the connection string below

dbc:oracle:thin:A_USER[IRM]/PASS_VALUE@oda23:1111:DBSCHEMA

And im getting the error below, i am using the details from the connection for this schema that is in PL/SQL Developer, and its connecting to the DB

With no issues, what am i doing wrong?

Cannot get a connection for the specified properties java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (CONNECTION_ID=Ks5zc1X4QcCabkq8DQ6lxQ==)

This is my connection string template

jdbc:oracle:thin:/@HOST:127.0.0.1:PORT:1111:

Thanks

[system]

Originally posted by nmrao on February 06, 2023

Suggest you to check oracle forums.

Can you connect using sqlplus command line with the same details?

[system]

Originally posted by armygrad on February 07, 2023

I think its because there are no listeners configured see image below

when i open the demo listeners file

could this be the issue?

Thanks