I have oracle 12c working with coldfusion 11 enterprise edition on 64bit oracle linux 6.5, Using the built-in oracle driver provided by CF11.
However, 12c uses a container/pluggable architecture. If I create a user in the container database (CDB), I can configure the datasource GUI in CF11 to log into the db account, But I can't configure CF11 to log into the container database. What does the connection string look like, and does it use the Oracle driver that comes with CF11 ent edition? I've tried a few ways, but I can't get it to connect. I have an oracle service name in listener.ora, I CAN log into the pluggable account from the shell i.e. sqlplus user@pdb. Is it even possible to log into the account within the PDB with the default ORACLE driver in CF11 datasource GUI? Or, ...must one set up the database as a "container-only" (no plug-in db's) to allow CF11 access? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3544 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
