12C手动创建CDB容器库

1、创建pfile参数文件

[oracle@test soft]$ more initcdbtest.ora
*.audit_file_dest='/u01/app/oracle/admin/cdbtest/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/oradata/cdbtest/control01.ctl','/oradata/cdbtest/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='cdbtest'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=cdbtestXDB)'
*.open_cursors=500
*.pga_aggregate_target=536870912
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.enable_pluggable_database=true
*.sga_target=1203765248
*.undo_tablespace='UNDOTBS1'

2、使用修改好的参数文件将库启动到nomount状态

[oracle@test soft]$ export ORACLE_SID=cdbtest
[oracle@test soft]$ sqlplus / as sysdba

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

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

Connected to an idle instance.

SQL> startup nomount pfile='/soft/initcdbtest.ora';
ORACLE instance started.

Total System Global Area 1207959552 bytes
Fixed Size            2923776 bytes
Variable Size          486540032 bytes
Database Buffers      704643072 bytes
Redo Buffers           13852672 bytes

3、创建相关目录和密码文件

点击(此处)折叠或打开

[oracle@test ~]$ mkdir -p /u01/app/oracle/admin/cdbtest/adump/
[oracle@test ~]$ mkdir -p /oradata/cdbtest/pdbseed/
oracle@test dbs]$ orapwd password='oracle' file=orapwcdbtest entries=5

4、使用脚本创建cdb容器库，下面是修改好的脚本。

CREATE DATABASE cdbtest
  USER SYS IDENTIFIED BY oracle
  USER SYSTEM IDENTIFIED BY oracle
  LOGFILE GROUP 1 ('/oradata/cdbtest/redo01.log')
             SIZE 200M BLOCKSIZE 512,
          GROUP 2 ('/oradata/cdbtest/redo02.log')
             SIZE 200M BLOCKSIZE 512,
          GROUP 3 ('/oradata/cdbtest/redo03.log')
             SIZE 200M BLOCKSIZE 512
  MAXLOGHISTORY 1
  MAXLOGFILES 16
  MAXLOGMEMBERS 3
  MAXDATAFILES 1024
  CHARACTER SET ZHS16GBK
  NATIONAL CHARACTER SET AL16UTF16
  EXTENT MANAGEMENT LOCAL
  DATAFILE '/oradata/cdbtest/system01.dbf'
    SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
  SYSAUX DATAFILE '/oradata/cdbtest/sysaux01.dbf'
    SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
  DEFAULT TABLESPACE deftbs
     DATAFILE '/oradata/cdbtest/deftbs01.dbf'
     SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
  DEFAULT TEMPORARY TABLESPACE tempts1
     TEMPFILE '/oradata/cdbtest/temp01.dbf'
     SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
  UNDO TABLESPACE undotbs1
     DATAFILE '/oradata/cdbtest/undotbs01.dbf'
     SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
  ENABLE PLUGGABLE DATABASE
    SEED
    FILE_NAME_CONVERT = ('/oradata/cdbtest/',
                         '/oradata/cdbtest/pdbseed/')
    SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
    SYSAUX DATAFILES SIZE 100M
  USER_DATA TABLESPACE usertbs
    DATAFILE '/oradata/cdbtest/usertbs01.dbf'
    SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

5、将pdb$seed库打开致读写状态

SQL> alter session set "_oracle_script"=true;

Session altered.

SQL> alter pluggable database pdb$seed close;

Pluggable database altered.

SQL> alter pluggable database pdb$seed open;
alter pluggable database pdb$seed open
*
ERROR at line 1:
ORA-00704: bootstrap process failure
ORA-00942: table or view does not exist

-- repeat again
SQL> alter pluggable database pdb$seed open;

Pluggable database altered.

SQL> show pdbs

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

6、使用sqlplus执行下面的脚本

SQL>@?/rdbms/admin/catalog.sql
SQL>@?/rdbms/admin/catblock.sql
SQL>@?/rdbms/admin/catproc.sql
SQL>@?/rdbms/admin/catoctk.sql
SQL>@?/rdbms/admin/owminst.plb
SQL>@?/sqlplus/admin/pupbld.sql

7、脚本执行完之后，可询视图验证是否创建成功

SQL> select name,cdb,open_mode from v$database;

NAME     CDB OPEN_MODE
--------- --- --------------------
CDBTEST YES READ WRITE

SQL> show pdbs

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