Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

edited Feb 27, 2020 5:27AM in Database Install/Upgrade/Opatch (MOSC) 9 commentsAnswered

Hi Community,

I am trying to connect to our newly created PDB using jdbc and get ORA-12505.

I can connect to the pdb using:

dsn="host:port/servicename”

But using the following connection string fails with 12505:

dsn="host:port:sid”

As we do not want to modify the connection string in all java programs, we want to use the SID instead of Service ID.

Therefore, I set the parameter USE_SID_AS_SERVICE_LISTENER on “on” and stopped the listener and started it again (the serivce is started clean), but still get the same error.

I would appreciate any help in this matter.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center