[root@db12cr2 ~]# su - oracle
[oracle@db12cr2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 14 12:43:39 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pluggable database open;
SP2-1547: Can not startup Pluggable database - Consolidated Database down.
SQL> startup
ORACLE instance started.
Total System Global Area 587202560 bytes
Fixed Size 8795424 bytes
Variable Size 343935712 bytes
Database Buffers 226492416 bytes
Redo Buffers 7979008 bytes
Database mounted.
Database opened.
SQL> startup pluggable database highgo2 open;
Pluggable Database opened.
SQL> startup pluggable database highgo3;
Pluggable Database opened.
SQL>
SQL> alter pluggable database highgo2 close immediate;
---->>>上述命令是单实例级别的命令,rac的话,需要在其他节点也执行此命令.
Pluggable database altered.
SQL> set lines 300
SQL> SELECT NAME, OPEN_MODE FROM V$PDBS WHERE CON_ID > 2;
NAME OPEN_MODE
-------------------------------------------------------------------------------------------------------------------------------- ----------
HIGHGO1 READ WRITE
HIGHGO2 MOUNTED
HIGHGO3 READ WRITE
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 HIGHGO1 READ WRITE NO
4 HIGHGO2 MOUNTED
5 HIGHGO3 READ WRITE NO
SQL>
在cdb中启动和关闭pdb
原创
©著作权归作者所有:来自51CTO博客作者wx5bcd90b347f01的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:关于Oracle Database 12.2 lsnrctl status中的几个servicename --是db的guid
下一篇:Oracle 12.2 sec_case_sensitive_logon设置为true 或者false 时,针对 system用户和新建用户的区别.

提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
CDB和PDB的创建、连接、启动、关闭
一、CDB和PDB基本管理二、创建三、连接四、启动与关闭 五、常用SQL
CDBPDB 容器 数据库 -
CDB和PDB的启动和停止
//开启数据库sqlplus / as sysdba; //登录连接CDB,默认是root container;startup open; //open 模式,但此时的pdb模式
visual studio dba oracle sql 数据库 -
Oracle 12.2中设置pdb随cdb启动而自动启动
Oracle 12.2中设置pdb随cdb启动而自动启动
12.2 pdb 自动启动 auto startup -
CDB or PDB打开归档
CDB or PDB打开归档
CDB PDb archivelog -
不同CDB之间迁移PDB
不同CDB直接迁移、克隆PDB
不同 CDB 直接迁移 克隆 PDB