ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
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.