Database Administration (MOSC)

MOSC Banner

USE_SID_AS_SERVICE breaks sid connection to non-pdb databases

I am working through upgrading our EBS database to 19c.

NOTE 2530665.1 says this:

"Note: If you are using the grid listener, then set the following parameter in the $GRID_HOME/network/admin/listener.ora file and bounce the listener on each of the Oracle RAC nodes: USE_SID_AS_SERVICE_<LISTENER_NAME>=ON"

I made that change and my upgrade worked fine. However, later that evening when we cloned one of our other EBS databases that is currently 12c non-pdb, it failed because the scripts couldn't connect to the sid. It failed with the following error:

ORA-12514: TNS:listener does not currently know of service requested in connect

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