12CR1 Learning starting up a CDB instance

Source: Internet
Author: User

To start a CDB instance, the current user must be a common user whose current container is the root.##启动CDB,需要使用root用户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.##打开一个CDB,PDB确实mount,需要使用alter pluggable database 修改open模式
<roidb01:cdb1:/home/oracle> $sqlplus/as sysdbasql*plus:release 12.1.0.2.0 Production on Mon Mar 5 20:13:46 2018Cop  Yright (c) 1982, Oracle. All rights reserved. Connected to an idle instance. Sql> Startuporacle instance started. Total System Global area 1174405120 bytesfixed size 2923680 bytesvariable size 436208480 byte Sdatabase 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 # #  The default is read-write sql>

12CR1 Learning starting up a CDB instance

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.