Solaris10下Silent模式安装Oracle1106RAC环境（七）

主机环境基本上和前面文章中描述的SOLARIS10安装Oracle1106rac的环境基本完全一致，最主要的区别在于没有了VOLUMN CLUSTER MANAGER，于是这里打算使用Oracle的ASM。由于安装操作没有什么区别，所以这次安装选择了SILENT静默模式来安装RAC。

描述SILENT模式下数据库实例的创建。

Solaris10下Silent模式安装Oracle1106RAC环境（一）：http://yangtingkun.itpub.net/post/468/477442

Solaris10下Silent模式安装Oracle1106RAC环境（二）：http://yangtingkun.itpub.net/post/468/477443

Solaris10下Silent模式安装Oracle1106RAC环境（三）：http://yangtingkun.itpub.net/post/468/477444

Solaris10下Silent模式安装Oracle1106RAC环境（四）：http://yangtingkun.itpub.net/post/468/477446

Solaris10下Silent模式安装Oracle1106RAC环境（五）：http://yangtingkun.itpub.net/post/468/477447

Solaris10下Silent模式安装Oracle1106RAC环境（六）：http://yangtingkun.itpub.net/post/468/477448

 

下面进行最后一个步骤，数据库的建立。

首先，仍然是编辑dbca.rsp文件，创建一个建立数据库的RESPONSE文件：

[GENERAL]

RESPONSEFILE_VERSION = "11.1.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "ractest.us.oracle.com"

SID = "ractest"

NODELIST=ser1,ser2

TEMPLATENAME = "New_Database.dbt"

SYSPASSWORD = "test"

SYSTEMPASSWORD = "test"

DATAFILEDESTINATION ="+DATA/oradata/ractest"

RECOVERYAREADESTINATION="+DATA/flash_recovery_area"

STORAGETYPE="ASM"

CHARACTERSET = "ZHS16GBK"

NATIONALCHARACTERSET= "AL16UTF16"

TOTALMEMORY = "10240"

ASM_SYS_PASSWORD="asm"

简单描述一下重要的参数：

OPERATION_TYPE在这里选择设置创建数据库。

GDBNAME和SID分别设置GLOBAL_NAME和SID前缀。

NODELIST设置安装的节点列表。

TEMPLATENAME指定安装模板为新建数据库模板。

DATAFILEDESTINATION和RECOVERYAREADESTINATION分别设置数据文件和DB_RECOVERY_DEST目标的指定位置。

STORAGETYPE指定ASM存储方式。

TOTALMEMORY指定系统一个可以使用的内存总量。

下面开始安装过程：

$ dbca -silent -responsefile /data/database/response/my_db.rsp
Creating and starting Oracle instance
1% complete
3% complete
Creating database files
6% complete
Creating data dictionary views
7% complete
8% complete
9% complete
10% complete
11% complete
12% complete
14% complete
15% complete
16% complete
Adding Oracle JVM
21% complete
26% complete
31% complete
33% complete
Adding Oracle Text
35% complete
36% complete
Adding Oracle XML DB
37% complete
38% complete
39% complete
42% complete
Adding Oracle Multimedia
43% complete
44% complete
52% complete
Adding Oracle OLAP
53% complete
54% complete
55% complete
Adding Oracle Spatial
56% complete
57% complete
58% complete
59% complete
62% complete
Adding Oracle Ultra Search
63% complete
68% complete
Adding Enterprise Manager Repository
70% complete
71% complete
Adding Oracle Application Express
75% complete
78% complete
Adding Oracle Warehouse Builder
81% complete
84% complete
Creating cluster database views
85% complete
91% complete
Completing Database Creation
92% complete
93% complete
94% complete
95% complete
97% complete
100% complete
Look at the log file "/data/oracle/cfgtoollogs/dbca/ractest/ractest.log" for further details.

检查日志，发现输出和屏幕输出差不多：

$ more /data/oracle/cfgtoollogs/dbca/ractest/ractest.log
Creating and starting Oracle instance
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
Creating database files
DBCA_PROGRESS : 6%
Creating data dictionary views
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 8%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 10%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 12%
DBCA_PROGRESS : 14%
DBCA_PROGRESS : 15%
DBCA_PROGRESS : 16%
Adding Oracle JVM
DBCA_PROGRESS : 21%
DBCA_PROGRESS : 26%
DBCA_PROGRESS : 31%
DBCA_PROGRESS : 33%
Adding Oracle Text
DBCA_PROGRESS : 35%
DBCA_PROGRESS : 36%
Adding Oracle XML DB
DBCA_PROGRESS : 37%
DBCA_PROGRESS : 38%
DBCA_PROGRESS : 39%
DBCA_PROGRESS : 42%
Adding Oracle Multimedia
DBCA_PROGRESS : 43%
DBCA_PROGRESS : 44%
DBCA_PROGRESS : 52%
Adding Oracle OLAP
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 54%
DBCA_PROGRESS : 55%
Adding Oracle Spatial
DBCA_PROGRESS : 56%
DBCA_PROGRESS : 57%
DBCA_PROGRESS : 58%
DBCA_PROGRESS : 59%
DBCA_PROGRESS : 62%
Adding Oracle Ultra Search
DBCA_PROGRESS : 63%
DBCA_PROGRESS : 68%
Adding Enterprise Manager Repository
DBCA_PROGRESS : 70%
DBCA_PROGRESS : 71%
Adding Oracle Application Express
DBCA_PROGRESS : 75%
DBCA_PROGRESS : 78%
Adding Oracle Warehouse Builder
DBCA_PROGRESS : 81%
DBCA_PROGRESS : 84%
Creating cluster database views
DBCA_PROGRESS : 85%
DBCA_PROGRESS : 91%
Completing Database Creation
DBCA_PROGRESS : 92%
DBCA_PROGRESS : 93%
DBCA_PROGRESS : 94%
DBCA_PROGRESS : 95%
DBCA_PROGRESS : 97%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
 /data/oracle/cfgtoollogs/dbca/ractest.
Database Information:
Global Database Name:ractest.us.oracle.com
System Identifier(SID) Prefix:ractest

至此，数据库的安装也全部完成。

$ ORACLE_SID=ractest1
$ export ORACLE_SID
$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on 星期二 9月 2 19:38:48 2008

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

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
ractest1

SQL> select instance_name from gv$instance;

INSTANCE_NAME
----------------
ractest1
ractest2

SQL> conn sys/test@ractest2 as sysdba
已连接。
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
ractest2

 

 

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

转载于:http://blog.itpub.net/4227/viewspace-544614/