Prior to 12c or in 12c installed without CDB/PDB distinction, for admin or troubleshooting purposes, I can connect to a specific instance of the RAC database with this simple TNS entry (instance mydb1 runs on mydbhost1 only):
mydb1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mydbhost1)(PORT = 1521))
(CONNECT_DATA =
(SID=mydb1) <-- SID, not service_name, to avoid redirecting
)
)
With 12c RAC, that stops working except when I connect to a user in CDB:
sqlplus sys@mydb1 as sysdba
sqlplus system@mydb1
One option is to create a dedicated service to run on one instance only. Other than that, is there an easier way to remotely connect to a specific instance as a regular user, and preferably into PDB directly?