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 ---