Oracle 12c pdb open restricted processing
Query the restricted PDB under CDB:
Select con_id, name,open_mode,restricted from v$pdbs
Query the relevant restricted PDB in PDB:
Select instance_name,logins,status from gv$instance (v$containers can also be queried)
Change the pdb restricted mode under cdb:
Alter pluggable database pdb_name close immediate instance=all; (all except pdb1)
Alter pluggable database pdb_name open read write instance=all
Change the pdb restricted mode under pdb:
Alter session set container=pdb_name
Alter pluggable database close immediate
Alter pluggable database open
In restricted mode, specific users can be granted restricted session permissions for temporary login, remember revoke.
