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
there is no option to say something like:
and then do sqlplus username/password ?
or some extra command line switch like
sqlplus -container=pluggable username/password
Is that understanding correct or have i missed something in the documentation?
In Oracle Multitenant the only way to connect to a PDB is by specifying a service.
However, there is a shortcut that you can use - TWO_TASK, which you will find documented elsewhere.
This allows you to specify the default service to be used - think of it as being appended silently to your username/password specification. I hope this helps.