oracle 查看打开状态

查询CDB的打开状态： SELECT NAME, OPEN_MODE FROM V$DATABASE;

打开CDB：ALTER DATABASE OPEN;

打开所有PDB：ALTER PLUGGABLE DATABASE ALL OPEN;

打开特定的PDB：ALTER PLUGGABLE DATABASE [PDB_NAME] OPEN;

查询PDB状态：SELECT PDB_NAME, STATUS FROM DBA_PDBS;