1. Default login to cdb<roidb01:cdb:/home/oracle> $sqlplus/as sysdbasql*plus:release 12.1.0.2.0 Production on Sat Jan 20 11:01 : 2018Copyright (c) 1982, Oracle. All rights reserved. Connected to an idle instance.2, start cdbsql> startuporacle instance started. Total System Global area 1560281088 bytesfixed size 2924784 bytesvariable size 956305168 bytesdatabase buffers 587202560 b Ytesredo buffers 13848576 bytesdatabase mounted. Database Opened.3, view container name sql> show Con_namecon_name------------------------------cdb$root4, view PDB by default there is a pdb$seed, PDB1 is created from a template. Sql> show PDBs con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------2 PD B$seed READ only No 3 PDB1 mounted 5, default PDB not started, manually start PDB sql> alter pluggable database all open; Pluggable database altered. Sql> show PDBs con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------2 PD B$seed Read Only NO 3 PDB1 read WRITE NO6, turn off PDB sql> alter pluggable Database pdb1 close; Pluggable database altered. Sql> show PDBs con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------2 PD B$seed Read Only 3 PDB1 MOUNTED7, PDB read open sql> alter pluggable database PDB1 open Read only; Pluggable database Altered.8, switch to pdb1sql> alter session set CONTAINER=PDB1; Session altered. Sql> show Con_namecon_name------------------------------PDB19, can also start pdbsql> shutdown immediate; Pluggable Database closed. Sql> startuppluggable Database opened. Sql> show PDBs con_id con_name OPEN MODE RESTRICTED------------------------------------------------------------3 PD B1 READ WRITE NO10, switch to CDB, close the CDB, the PDB will also follow the close sql> alter session set Container=cdb$root; Session altered. sql> shutdown immediate;database closed. Database dismounted. ORACLE instance shut down. Sql>
Oracle 12c Learning starts off cdb&pdb