JDBC Oracle thin connection string

[armygrad]

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

[nmrao]

Suggest you to check oracle forums.

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

[armygrad]

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