Oracle 12c Learning starts off cdb&pdb

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.