1 Reply Latest reply on Nov 3, 2014 10:42 AM by GDavis

    connecting to oracle 12c multitenant database


      My question, using coldfusion 11 enterprise datasource gui,

      how do you connect to oracle 12c multitenant database,

      when you need to log into a pluggable database, beneath

      the container database?


      What's the connection string, or is it even possible to connect(?) because earlier versions of oracle

      didn't use multitenant architecture, you just make a user/password,

      grant connect privileges, and connect.


      Using Oracle Linux 6.5 64bit.

      This is assuming I can connect to the oracle CDB (container database) and PDB (pluggable database) from the shell using sqlplus.


      <!------------------------ I can tsnping the pluggable database name pdb1 ---------------------------------------------->

      [oracle@localhost ~]$ tnsping pdb1

      TNS Ping Utility for Linux: Version - Production on 27-JUN-2014 12:13:12

      Copyright (c) 1997, 2013, Oracle.  All rights reserved.

      Used parameter files:



      Used TNSNAMES adapter to resolve the alias

      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1.localhost.localdomain)))

      OK (0 msec)


      <!------------------------------ I can connect to pdb1 using sqlplus shell ---------------------------------------------------->


      [oracle@localhost ~]$ sqlplus user1/password20@pdb1

      SQL*Plus: Release Production on Fri Jun 27 12:21:06 2014

      Copyright (c) 1982, 2013, Oracle.  All rights reserved.

      Last Successful login time: Fri Jun 27 2014 09:45:05 -07:00


      Connected to:

      Oracle Database 12c Enterprise Edition Release - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options