SQL Commands

SQL Commands 

sudo su - oracle

sqlplus / as sysdba

show pdbs;

select distinct OPEN_MODE from gv$pdbs;

select inst_id,con_id,name,OPEN_MODE from gv$pdbs where OPEN_MODE='READ ONLY' order by INST_ID;

select count(*) from gv$pdbs;

select distinct OPEN_MODE,count(*) from gv$pdbs group by OPEN_MODE;

Note: Do not issue this ( check with DBA)

col NAME for a25

select con_id,name,dbid,open_mode,open_time from v$containers;

alter session set container=ADKNOWLEDGE;

alter pluggable database ADKNOWLEDGE open instances=all;

alter pluggable database all open;