Re: connecting to oracle 12c multitenant database

forums_noreply@adobe.com — Mon, 03 Nov 2014 18:42:59 GMT

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?

connecting to oracle 12c multitenant database

forums_noreply@adobe.com — Fri, 27 Jun 2014 19:10:34 GMT

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.

[oracle@localhost ~]$ tnsping pdb1

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

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)

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

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

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>

Adobe Community: Message List - connecting to oracle 12c multitenant database

Re: connecting to oracle 12c multitenant database

connecting to oracle 12c multitenant database