11gR2使用dbca静默(silent)创建RAC数据库

    相关文章：《静默(silent)安装Oracle 11gR2 Grid Infrastructure软件(for RAC)》http://space.itpub.net/23135684/viewspace-747199

              《静默(silent)安装Oracle Database 11gR2软件》http://space.itpub.net/23135684/viewspace-741933

    假设Clusterware和Database软件已经成功安装，且Clusterware运行正常，执行下面的步骤，通过dbca工具以静默的方式创建数据库。

1.创建相应ASM磁盘组：

SQL>  create diskgroup data external redundancy 

  2  disk

  3  '/dev/oracleasm/disks/DATA01',

  4  '/dev/oracleasm/disks/DATA02'

  5  ATTRIBUTE 'compatible.asm'='11.2.0.0.0';

Diskgroup created.

SQL> create diskgroup arch external redundancy

  2  disk

  3  '/dev/oracleasm/disks/ARCH01',

  4  '/dev/oracleasm/disks/ARCH02'

  5  ATTRIBUTE 'compatible.asm'='11.2.0.0.0'

  6  ;

Diskgroup created.

SQL> select group_number,name,state from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE

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

           1 OCRVDISK                       MOUNTED

           2 DATA                           MOUNTED

           3 ARCH                           MOUNTED
    确保RAC所有节点都成功MOUNT，如果其他节点没有MOUNT，执行alter diskgroup mount;命令加载ASM磁盘组。

2.编辑响应文件：
    默认的响应文件模板位于安装介质目录下的response/dbca.rsp文件。根据提示完成相应的设置，在模板最开始有如下的提示：

## Examples :                                                               ##

##     1. dbca -progress_only -responseFile                 ##

##        Display a progress bar depicting progress of database creation    ##

##        process.                                                          ##

##                                                                          ##

##     2. dbca -silent -responseFile                        ##

##        Creates database silently. No user interface is displayed.        ##

##                                                                          ##

##     3. dbca -silent -createDatabase -cloneTemplate                       ##

##                       -responseFile                      ##

##        Creates database silently with clone template. The template in    ##

##        responsefile is a clone template.                                 ##

##                                                                          ##

##     4. dbca -silent -deleteDatabase -responseFile        ##

##        Deletes database silently.                                        ##

##############################################################################

    根据上面的提示，可以利用这个模板来创建数据库、删除数据库、配置数据库，创建模板和克隆模板。这里我们只创建数据库，所以将模板的其他部分内容去掉，只保留如下内容（仅供修改参考，不可直接使用）：

#-----------------------------------------------------------------------------

# GENERAL section is required for all types of database creations.

#-----------------------------------------------------------------------------

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "oracledb"

SID = "oracledb"

NODELIST=rac1,rac2

TEMPLATENAME = "General_Purpose.dbc"

SYSPASSWORD = "oracle_Schic1"

SYSTEMPASSWORD = "oracle_Schic1"

SYSMANPASSWORD = "oracle_Schic1"

DBSNMPPASSWORD = "oracle_Schic1"

STORAGETYPE=ASM

DISKGROUPNAME=DATA

ASMSNMP_PASSWORD="oracle_Schic1"

RECOVERYGROUPNAME=ARCH

CHARACTERSET = "ZHS16GBK"

NATIONALCHARACTERSET= "UTF8"

......

#-----------------------*** End of CREATEDATABASE section ***------------------------

    本次创建数据库完整的dbca.rsp文件可以到这里 下载dbca.rsp。

3.在oracle用户下执行以下命令以静默方式创建数据库：

[oracle@rac1 ~]$ dbca -responseFile /u01/soft/database/response/dbca.rsp -silent

Copying database files

1% complete

3% complete

9% complete

15% complete

21% complete

27% complete

30% complete

Creating and starting Oracle instance

32% complete

36% complete

40% complete

44% complete

45% complete

48% complete

50% complete

Creating cluster database views

52% complete

70% complete

Completing Database Creation

73% complete

76% complete

85% complete

94% complete

100% complete

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/oracledb/oracledb.log" for further details.

4.检查数据库状态：

[oracle@rac1 ~]$ srvctl status database -d oracledb

Instance oracledb1 is running on node rac1

Instance oracledb2 is running on node rac2

[oracle@rac1 ~]$ srvctl config database -d oracledb

Database unique name: oracledb

Database name: oracledb

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/oracledb/spfileoracledb.ora

Domain: 

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: oracledb

Database instances: oracledb1,oracledb2

Disk Groups: DATA,ARCH

Mount point paths: 

Services: 

Type: RAC

Database is administrator managed

[grid@rac1 ~]$ crsctl stat res -t

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

NAME           TARGET  STATE        SERVER                   STATE_DETAILS       

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

Local Resources

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

ora.ARCH.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.DATA.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.OCRVDISK.dg

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.asm

               ONLINE  ONLINE       rac1                     Started             

               ONLINE  ONLINE       rac2                     Started             

ora.gsd

               OFFLINE OFFLINE      rac1                                         

               OFFLINE OFFLINE      rac2                                         

ora.net1.network

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

ora.ons

               ONLINE  ONLINE       rac1                                         

               ONLINE  ONLINE       rac2                                         

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac1                                         

ora.cvu

      1        ONLINE  ONLINE       rac1                                         

ora.oc4j

      1        ONLINE  ONLINE       rac1                                         

ora.oracledb.db

      1        ONLINE  ONLINE       rac1                     Open                

      2        ONLINE  ONLINE       rac2                     Open                

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                         

ora.rac2.vip

      1        ONLINE  ONLINE       rac2                                         

ora.scan1.vip

      1        ONLINE  ONLINE       rac1              

[grid@rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 25-OCT-2012 01:21:57

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                25-OCT-2012 00:00:02

Uptime                    0 days 1 hr. 21 min. 56 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/grid/11.2.0/network/admin/listener.ora

Listener Log File         /u01/app/gridbase/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.11.2.11)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.11.2.1)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "oracledb" has 1 instance(s).

  Instance "oracledb1", status READY, has 1 handler(s) for this service...

Service "oracledbXDB" has 1 instance(s).

  Instance "oracledb1", status READY, has 1 handler(s) for this service...

The command completed successfully

[grid@rac1 ~]$ lsnrctl status listener_scan1

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 25-OCT-2012 01:22:02

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

STATUS of the LISTENER

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

Alias                     LISTENER_SCAN1

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                24-OCT-2012 23:51:08

Uptime                    0 days 1 hr. 30 min. 55 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/grid/11.2.0/network/admin/listener.ora

Listener Log File         /u01/app/grid/11.2.0/log/diag/tnslsnr/rac1/listener_scan1/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.11.2.15)(PORT=1521)))

Services Summary...

Service "oracledb" has 2 instance(s).

  Instance "oracledb1", status READY, has 1 handler(s) for this service...

  Instance "oracledb2", status READY, has 1 handler(s) for this service...

Service "oracledbXDB" has 2 instance(s).

  Instance "oracledb1", status READY, has 1 handler(s) for this service...

  Instance "oracledb2", status READY, has 1 handler(s) for this service...

The command completed successfully

                          

    之后根据具体的情况对数据库作出调整。

--end--

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

转载于:http://blog.itpub.net/23135684/viewspace-747223/