Ask a Question

JDBC Oracle thin connection string

armygrad
Contributor

JDBC Oracle thin connection string

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:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1111>:<SID>

 

Thanks

2 REPLIES 2
nmrao
Champion Level 2

Suggest you to check oracle forums.

 

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



Regards,
Rao.
armygrad
Contributor

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

 

armygrad_0-1675764216820.png

when i open the demo listeners file

 

armygrad_1-1675764284415.png

could this be the issue?

 

Thanks

cancel
Showing results for 
Search instead for 
Did you mean: