原文地址:http://blog.itpub.net/23135684/viewspace-747223/
相关文章:《静默(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文件。根据提示完成相应的设置,在模板最开始有如下的提示:
确保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. ##
##############################################################################
根据上面的提示,可以利用这个模板来创建数据库、删除数据库、配置数据库,创建模板和克隆模板。这里我们只创建数据库,所以将模板的其他部分内容去掉,只保留如下内容(仅供修改参考,不可直接使用):
......
#-----------------------*** End of CREATEDATABASE section ***------------------------
本次创建数据库完整的dbca.rsp文件可以到这里 下载dbca.rsp。
3.在oracle用户下执行以下命令以静默方式创建数据库:
--end--
#-----------------------------------------------------------------------------
# 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 config database -d oracledb
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--