Skip to main content
Participating Frequently
June 27, 2014
Question

connecting to oracle 12c multitenant database

  • June 27, 2014
  • 1 reply
  • 1281 views

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>

    This topic has been closed for replies.

    1 reply

    Participant
    November 3, 2014

    Having the same issue, can't get the connection string right with the PDB?

    Anyone out there? Kurrttt, did you ever get this figured out?