Ora12c：创建PDB
在Oracle Database 12c中PDB的创建有两种方式：1、DBCA；2、SQL*Plus。
一、DBCA：
|
1 2 3 4 5 6 7 |
[oracle@rhel6 ~]$ export DISPLAY=192.168.147.1:0.0 [oracle@rhel6 ~]$ xhost + access control disabled, clients can connect from any host [oracle@rhel6 ~]$ [oracle@rhel6 ~]$ dbca & [1] 3697 [oracle@rhel6 ~]$ |
创建PDB的过程中，相关日志输出的内容如下：
alert.log
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
######## Log File: /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log Tue Oct 20 19:38:01 2015 CREATE PLUGGABLE DATABASE sarah ADMIN USER root IDENTIFIED BY * ROLES=(CONNECT) file_name_convert=('/u01/app/oracle/oradata/orcl/pdbseed/system01.dbf','/u01/app/oracle/oradata/orcl/sarah/system01.dbf', '/u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf','/u01/app/oracle/oradata/orcl/sarah/sysaux01.dbf','/u01/app/oracle/oradata/orcl/pdbseed/pdbseed_temp01.dbf','/u01/app/oracle/oradata/orcl/sarah/temp01.dbf') ######## Log File: /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log Tue Oct 20 19:38:01 2015 CREATE PLUGGABLE DATABASE sarah ADMIN USER root IDENTIFIED BY * ROLES=(CONNECT) file_name_convert=('/u01/app/oracle/oradata/orcl/pdbseed/system01.dbf','/u01/app/oracle/oradata/orcl/sarah/system01.dbf', '/u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf','/u01/app/oracle/oradata/orcl/sarah/sysaux01.dbf','/u01/app/oracle/oradata/orcl/pdbseed/pdbseed_temp01.dbf','/u01/app/oracle/oradata/orcl/sarah/temp01.dbf') Tue Oct 20 19:39:16 2015 **************************************************************** Pluggable Database SARAH with pdb id - 4 is created as UNUSABLE. If any errors are encountered before the pdb is marked as NEW, then the pdb must be dropped **************************************************************** Deleting old file#5 from file$ Deleting old file#7 from file$ Adding new file#12 to file$(old file#5) Adding new file#13 to file$(old file#7) Successfully created internal service sarah at open ALTER SYSTEM: Flushing buffer cache inst=0 container=4 local **************************************************************** Post plug operations are now complete. Pluggable database SARAH with pdb id - 4 is now marked as NEW. **************************************************************** Completed: CREATE PLUGGABLE DATABASE sarah ADMIN USER root IDENTIFIED BY * ROLES=(CONNECT) file_name_convert=('/u01/app/oracle/oradata/orcl/pdbseed/system01.dbf','/u01/app/oracle/oradata/orcl/sarah/system01.dbf', '/u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf','/u01/app/oracle/oradata/orcl/sarah/sysaux01.dbf','/u01/app/oracle/oradata/orcl/pdbseed/pdbseed_temp01.dbf','/u01/app/oracle/oradata/orcl/sarah/temp01.dbf') alter pluggable database sarah open Pluggable database SARAH dictionary check beginning Pluggable Database SARAH Dictionary check complete Opening pdb SARAH (4) with no Resource Manager plan active XDB installed. XDB initialized. Pluggable database SARAH opened read write Completed: alter pluggable database sarah open CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/u01/app/oracle/oradata/orcl/sarah/sarah_users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/u01/app/oracle/oradata/orcl/sarah/sarah_users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ALTER DATABASE DEFAULT TABLESPACE "USERS" Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS" |
Activity Log:
|
1 2 3 4 5 6 7 |
[oracle@rhel6 trace]$ cat /u01/app/oracle/cfgtoollogs/dbca/orcl/sarah/plugDatabase.log database_running /u01/app/oracle/diag/rdbms/orcl/orcl/trace /u01/app/oracle/oradata/orcl/pdbseed/system01.dbf /u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/orcl/pdbseed/pdbseed_temp01.dbf [oracle@rhel6 trace]$ |
二、SQL*Plus：
首先查看下当前数据库中的PDB状态：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SQL> select name,cdb,open_mode,con_id from v$database; NAME CDB OPEN_MODE CON_ID --------- --- -------------------- ---------- ORCL YES READ WRITE 0 SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SQL> set linesize 900; SQL> col name for a10 SQL> select con_id,dbid,guid,name,open_mode from v$pdbs; CON_ID DBID GUID NAME OPEN_MODE ---------- ---------- -------------------------------- ---------- ---------- 2 4136160811 2286665FE02C1878E0538093A8C0C318 PDB$SEED READ ONLY 3 2340684404 2286894348E51AA1E0538093A8C0CF3E PDBORCL MOUNTED 4 2109501081 2295446A87C50F72E0538093A8C01FF9 SARAH READ WRITE SQL> |
当前库中，有两个PDB：1、PDBORCL；2、SARAH。
下面，用命令行创建一个新的PDB：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
SQL> create pluggable database alan 2 admin user root identified by abcd1234 3 file_name_convert=('/u01/app/oracle/oradata/orcl/pdbseed/system01.dbf','/u01/app/oracle/oradata/orcl/alan/system01.dbf','/u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf','/u01/app/oracle/oradata/orcl/alan/sysaux01.dbf','/u01/app/oracle/oradata/orcl/pdbseed/pdbseed_temp01.dbf','/u01/app/oracle/oradata/orcl/alan/temp01.dbf'); Pluggable database created. SQL> SQL> select con_id,dbid,guid,name,open_mode from v$pdbs; CON_ID DBID GUID NAME OPEN_MODE ---------- ---------- -------------------------------- ---------- ---------- 2 4136160811 2286665FE02C1878E0538093A8C0C318 PDB$SEED READ ONLY 3 2340684404 2286894348E51AA1E0538093A8C0CF3E PDBORCL MOUNTED 4 2109501081 2295446A87C50F72E0538093A8C01FF9 SARAH READ WRITE 5 1583010700 2295B60A8049100BE0538093A8C065F2 ALAN MOUNTED SQL> SQL> alter pluggable database alan open; Pluggable database altered. SQL> select con_id,dbid,guid,name,open_mode from v$pdbs; CON_ID DBID GUID NAME OPEN_MODE ---------- ---------- -------------------------------- ---------- ---------- 2 4136160811 2286665FE02C1878E0538093A8C0C318 PDB$SEED READ ONLY 3 2340684404 2286894348E51AA1E0538093A8C0CF3E PDBORCL MOUNTED 4 2109501081 2295446A87C50F72E0538093A8C01FF9 SARAH READ WRITE 5 1583010700 2295B60A8049100BE0538093A8C065F2 ALAN READ WRITE SQL> |
——————————————————————
Done。
