设置PDB随CDB启动自动启动

默认PDB是不会自动启动的，需要手动创建一个触发器让PDB库随CDB启动时自动启动

1、以sysdba用户使用startup 命令启动cdb库

[oracle@test ~]$ export ORACLE_SID=cdb
[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Nov 7 19:19:37 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size            2932632 bytes
Variable Size          436207720 bytes
Database Buffers      629145600 bytes
Redo Buffers            5455872 bytes
Database mounted.
Database opened.
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> select name,cdb from v$database;

NAME      CDB
--------- ---
CDB      YES

SQL>

2、使用show pdbs命令确认当前pdb库是否启动

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 PDB1               MOUNTED

3、创建触发器 open_pdbs

SQL>
CREATE OR REPLACE TRIGGER open_pdbs
  AFTER STARTUP ON DATABASE
BEGIN
   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';
END open_pdbs;
  /

Trigger created.

4、关闭cdb库，并再启动cdb

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size            2932632 bytes
Variable Size          436207720 bytes
Database Buffers      629145600 bytes
Redo Buffers            5455872 bytes
Database mounted.

5、再次查看pdb库的状态

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 PDB1               READ WRITE NO

此时看可以看到pdb1的状态为read write模式

如果不想pdb随cdb一起启的话，删除该触发器即可

DROP TRIGGER TRG_OPEN_ALL_PDBS