General syntax is “alter session set container=<container name>;”
or
Generally:
sqlplus user/pw@ip-hostname:port/service_name
To verify service name do a “lnsrctl service”
Only special container names are PDB$SEED and CDB$ROOT.
PDB$SEED is read only – generally used to seed new pluggable databases
Example get back to the parent container:
alter session set container=CDB$ROOT;
You want to see all your pluggable databases?
select name, open_mode from v$pdbs;
SQL> show con_name
CON_NAME
——————————
CDB$ROOT
SQL> l 1* select name, open_mode from v$pdbs
SQL> /
NAME OPEN_MODE
—————- ———-
PDB$SEED READ ONLY
PDB1 READ WRITE
PDB1_CLONE READ WRITE
PDB2 READ WRITE