主机环境基本上和前面文章中描述的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博客 ” ,链接:https://blog.itpub.net/4227/viewspace-544614/ ,如需转载,请注明出处,否则将追究法律责任。