使用SQL语句手动创建PDB库

1、使用file_name_convert参数创建pdb库，前面的路径为pdbseed种子库的路径，后面的路径为新创建的PDB存放数据路径

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

SQL*Plus: Release 12.1.0.2.0 Production on Thu Nov 5 14:07:04 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
SQL> create pluggable database pdb admin user pdb identified by oracle file_name_convert=('/oradata/cdb/pdbseed/','/oradata/cdb/pdb/');

Pluggable database created.

查看新建的PDB状态，第一次创建为NEW,如下所示：创建好PDB库之后使用命令将其打开，再查看状态，变为normal

SQL> select pdb_name,status from dba_pdbs;

PDB_NAME         STATUS
-------------------- ---------
PDB             NEW
PDB$SEED         NORMAL

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 PDB                  MOUNTED
SQL> alter pluggable database pdb open;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 PDB                  READ WRITE NO
SQL> select pdb_name,status from dba_pdbs;

PDB_NAME         STATUS
-------------------- ---------
PDB             NORMAL
PDB$SEED         NORMAL

2、使用pdb_file_name_convert参数创建pdb库

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

SQL*Plus: Release 12.1.0.2.0 Production on Thu Nov 5 14:42:57 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 PDB                  READ WRITE NO
SQL> alter session set  pdb_file_name_convert='/oradata/cdb/pdbseed/','/oradata/cdb/pdb1/';

Session altered.

SQL> create pluggable database pdb1 admin user pdb_admin identified by oracle;

Pluggable database created.

SQL> col pdb_name for a20
SQL> select pdb_name,status from dba_pdbs order by pdb_name;

PDB_NAME         STATUS
-------------------- ---------
PDB             NORMAL
PDB$SEED         NORMAL
PDB1             NEW

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 PDB                  READ WRITE NO
     4 PDB1               MOUNTED
SQL> alter pluggable database pdb1 open;

Pluggable database altered.

SQL> select pdb_name,status from dba_pdbs order by pdb_name;

PDB_NAME         STATUS
-------------------- ---------
PDB             NORMAL
PDB$SEED         NORMAL
PDB1             NORMAL

SQL> show pdbs

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