Forum Discussion

armygrad's avatar
armygrad
Contributor
2 years ago

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

Data-Driven Testing
REST
  • nmrao's avatar
    nmrao
    Champion Level 3
    2 years ago

    Suggest you to check oracle forums.

     

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

  • armygrad's avatar
    armygrad
    Contributor
    2 years ago

    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