This discussion is archived
5 Replies Latest reply: Jul 23, 2013 8:36 AM by Richard Harrison . RSS

Specifying the container to connect to from command line utilities (sqlplus/expdp etc)

Richard Harrison . Expert
Currently Being Moderated

Hi,

To kick off this forum I've been playing around with 12c multitenant/pluggable features and I've a general question about connections to the container database - it seems from everything i tried so far (and everything I've read) that there is no way to connect to a container database without going through a sqlnet connection. For example:

 

export ORACLE_HOME, ORACLE_SID etc

sqlplus username/password -- this can only connect to the container database? (once you are in you can alter session to switch to the plugable database but can;t do it directly in the connection)

 

to connect to a plugged in database you always have to go through sqlnet

 

sqlpus username/password@pluggable

 

there is no option to say something like:

 

export ORACLE_SID=container

export ORACLE_CONTAINER=pluggable

and then do sqlplus username/password ?

 

or some extra command line switch like

 

export ORACLE_SID=container

sqlplus -container=pluggable username/password

 

Is that understanding correct or have i missed something in the documentation?

 

Regards,

Harry

 

http://dbaharrison.blogspot.com

 

 


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points