Database Administration (MOSC)

MOSC Banner

19.10 Container Database not able to connect to ROOT Container with tnsalias.

I have 19.10 EBS Database.

Container Database Name - CDBQA , with "CDB$ROOT" as container name.

Pluggable Database - EBSQA

tnsping perfectly shows container name.

tnsping cdbqa

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = psm-xxxxx-tstx.sigarms.local)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = cdbqa)))

Enter user-name: system@cdbqa

Enter password:

SQL> show con_name


CON_NAME

------------------------------

EBSQA ( This is Pluggable database Name).



On other UAT instance it goes fine, ideally it should connect to:

SQL> show con_name


CON_NAME

------------------------------

CDB$ROOT

---------------------- How to get it fixed, so it connects to container database ---

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