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

    connecting to oracle 12c multitenant database

    kurttt

      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 12.1.0.1.0 - Production on 27-JUN-2014 12:13:12

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

      Used parameter files:

      /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

       

      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 12.1.0.1.0 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 12.1.0.1.0 - 64bit Production

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

       

      SQL>