主機環境基本上和前面文章中描述的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

連線到:
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

Solaris10下Silent模式安裝Oracle1106RAC環境（七）

相關文章