5 Replies Latest reply: Jul 23, 2013 10:36 AM by Richard Harrison . RSS

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

    Richard Harrison .

      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