12c dbca silent create pdb

1   描述

在已有cdb orcl12c 基础之上，利用dbca 创建pdb数据库。

2   操作环境

2.1         OS info

[oracle@host01 ~]$ lsb_release -a

LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: OracleServer

Description:    Oracle Linux Server release 6.5

Release:        6.5

Codename:       n/a

[oracle@host01 ~]$ uname -a

Linux host01.example.com 2.6.32-431.el6.x86_64 #1 SMP Wed Nov 20 23:56:07 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

[oracle@host01 ~]$

2.2         DB info

[oracle@host01 ~]$ export ORACLE_SID=orcl12c

[oracle@host01 ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[oracle@host01 ~]$ sqlplus / as sysdba <<EOF

set lines 150

COL PRODUCT FORMAT A55

COL VERSION FORMAT A15

COL STATUS FORMAT A15

Col parameter for a30

SELECT * FROM PRODUCT_COMPONENT_VERSION;

col value for a50

set pages 50

select * from nls_database_parameters;

archive log list;

EOF

SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 29 14:23:13 2016

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> SQL> SQL> SQL> SQL> SQL>

PRODUCT                                                 VERSION         STATUS

------------------------------------------------------- --------------- ---------------

NLSRTL                                                  12.1.0.2.0      Production

Oracle Database 12c Enterprise Edition                  12.1.0.2.0      64bit Productio

                                                                        n

PL/SQL                                                  12.1.0.2.0      Production

TNS for Linux:                                          12.1.0.2.0      Production

SQL> SQL> SQL>

PARAMETER                      VALUE

------------------------------ --------------------------------------------------

NLS_RDBMS_VERSION              12.1.0.2.0

NLS_NCHAR_CONV_EXCP            FALSE

NLS_LENGTH_SEMANTICS           BYTE

NLS_COMP                       BINARY

NLS_DUAL_CURRENCY              $

NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR

NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM

NLS_TIME_FORMAT                HH.MI.SSXFF AM

NLS_SORT                       BINARY

NLS_DATE_LANGUAGE              AMERICAN

NLS_DATE_FORMAT                DD-MON-RR

NLS_CALENDAR                   GREGORIAN

NLS_NUMERIC_CHARACTERS         .,

NLS_NCHAR_CHARACTERSET         AL16UTF16

NLS_CHARACTERSET               WE8MSWIN1252

NLS_ISO_CURRENCY               AMERICA

NLS_CURRENCY                   $

NLS_TERRITORY                  AMERICA

NLS_LANGUAGE                   AMERICAN

20 rows selected.

SQL> SQL> Database log mode            No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     7

Current log sequence           9

SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@host01 ~]$

3   相关信息

利用数据库软件安装包中的dbca.rsp文件，构建创建pdb的response文件。如下：

[oracle@host01 ~]$ cat responsole_pdb.txt

[GENERAL]

RESPONSEFILE_VERSION = "12.1.0"

OPERATION_TYPE = "createPluggableDatabase"

[CREATEPLUGGABLEDATABASE]

SOURCEDB = "orcl12c"

PDBNAME = "PDB1"

CREATEPDBFROM = "DEFAULT"

PDBADMINUSERNAME = "oracle"

PDBADMINPASSWORD = "oracle"

Pdb如需其他设置，可对[CREATEPLUGGABLEDATABASE]部分的其他参数进行设置。本实验不再配置。

4   详细步骤操作

前提cdb orcl12c已经处于open状态。

[oracle@host01 ~]$ dbca -help dbca  [-silent | -progressOnly] {<command> <options> }  | { [<command> [options] ] -responseFile  <response file > } [-continueOnNonFatalErrors <true | false>]  <command> : -createDatabase | -configureDatabase | -createTemplateFromDB | -createCloneTemplate | -generateScripts | -deleteDatabase | -createPluggableDatabase | -unplugDatabase | -deletePluggableDatabase | -configurePluggableDatabase Enter "dbca -<command> -help" for more option [oracle@host01 ~]$ dbca -silent -responseFile responsole_pdb.txt Creating Pluggable Database 4% complete 12% complete 21% complete 38% complete 85% complete Completing Pluggable Database Creation 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl12c/PDB1/orcl12c1.log" for further details.  [oracle@host01 ~]$ cat /u01/app/oracle/cfgtoollogs/dbca/orcl12c/PDB1/orcl12c1.log The Container database selected is in the open state Pluggable database name check succeeded. Pluggable database admin user check succeeded. /u01/ has enough space. Required space is 760 MB , available space is 38494 MB. Creating Pluggable Database DBCA_PROGRESS : 4% DBCA_PROGRESS : 12% DBCA_PROGRESS : 21% DBCA_PROGRESS : 38% DBCA_PROGRESS : 85% Completing Pluggable Database Creation DBCA_PROGRESS : 100% Pluggable database "PDB1" plugged successfully. [oracle@host01 ~]$ export ORACLE_SID=orcl12c [oracle@host01 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 29 14:31:26 2016 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 PDB1                           READ WRITE NO SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/orcl12c/system01.dbf /u01/app/oracle/oradata/orcl12c/sysaux01.dbf /u01/app/oracle/oradata/orcl12c/undotbs01.dbf /u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf /u01/app/oracle/oradata/orcl12c/users01.dbf /u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/orcl12c/PDB1/system01.dbf /u01/app/oracle/oradata/orcl12c/PDB1/sysaux01.dbf /u01/app/oracle/oradata/orcl12c/PDB1/PDB1_users01.dbf 9 rows selected. SQL>

5   个人总结

pdb可以使用dbca,也可以使用create statement创建，此处官方无建议要求。

6   资料参考引用

Database Administration

Administrator's Guide

2 Creating and Configuring an Oracle Database

http://docs.oracle.com/database/121/ADMIN/create.htm#i1017640

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11780477/viewspace-2071702/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11780477/viewspace-2071702/