Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article we will look at how to make a Direct Oracle Connect To Pluggable Database.
In order to connect directly to the Pluggable database in the Oracle Container Database structure,
we set the SID of the PDB to be connected.
1 | $ export ORACLE_PDB_SID=TESTDB |
After the SID is set, we connect directly to TESTDB.
1 2 3 4 5 | $ sqlplus sys / as sysdba SQL> show con_name CON_NAME ------------------------------ TESTDB |
Hi,
I think this feature is only applicable from 18c onwards. Not applicable for prior releases of 18c.