Shulou(Shulou.com)06/01 Report--

To start a CDB instance, the current user must be a common user whose current container is the root.## to start CDB, you need to use root user When you open a CDB, its PDBs are mounted. Use the ALTER PLUGGABLE DATABASE statement to modify the open mode of one or more PDBs.## opens a CDB,PDB mount and needs to use alter pluggable database to modify the open mode $sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 5 20:13:46 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to an idle instance.SQL > startupORACLE instance started.Total System Global Area 1174405120 bytesFixed Size 2923680 bytesVariable Size 436208480 bytesDatabase Buffers 721420288 bytesRedo Buffers 13852672 bytesDatabase mounted.Database opened.SQL > show con_nameCON_NAME--CDB$ROOTSQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB11 MOUNTEDSQL > alter pluggable database all open Pluggable database altered.SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB11 READ WRITE NO # # defaults to read-write SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.