Solaris 10下遷移10G RAC (四)

最近做了一個rac資料庫的遷移，中間涉及到很多部分內容，包括rac環境的搭建、ASM的設定、資料庫的遷移、升級等。
本文是這次遷移工作的第四部分：安裝資料庫軟體。

安裝資料庫軟體

安裝完clusterware後，就可以進行安裝資料庫的操作了。

檢查當前系統是否滿足安裝資料庫的條件

bash-3.00$ ./runcluvfy.sh stage -pre dbinst -n pre1,pre2

Performing pre-checks for database installation

Checking node reachability...

Node reachability check passed from node "pre1".

Checking user equivalence...

User equivalence check passed for user "oracle".

Checking administrative privileges...

User existence check passed for "oracle".

Group existence check passed for "oinstall".

Membership check for user "oracle" in group "oinstall" [as Primary] passed.

Group existence check passed for "dba".

Membership check for user "oracle" in group "dba" passed.

Administrative privileges check passed.

Checking node connectivity...

Node connectivity check passed for subnet "172.0.2.0" with node(s) pre2,pre1.

Node connectivity check passed for subnet "10.0.0.0" with node(s) pre2,pre1.

Suitable interfaces for VIP on subnet "172.0.2.0":

pre2 ce0:172.0.2.3 ce0:172.0.2.4

pre1 ce0:172.0.2.1 ce0:172.0.2.2

Suitable interfaces for the private interconnect on subnet "10.0.0.0":

pre2 ce1:10.0.0.2

pre1 ce1:10.0.0.1

Node connectivity check passed.

Checking system requirements for 'database'...

Total memory check passed.

Free disk space check passed.

Swap space check passed.

System architecture check passed.

Operating system version check passed.

Package existence check passed for "SUNWarc".

Package existence check passed for "SUNWbtool".

Package existence check passed for "SUNWhea".

Package existence check passed for "SUNWlibm".

Package existence check passed for "SUNWlibms".

Package existence check passed for "SUNWsprot".

Package existence check passed for "SUNWsprox".

Package existence check passed for "SUNWtoo".

Package existence check passed for "SUNWi1of".

Package existence check passed for "SUNWi1cs".

Package existence check passed for "SUNWi15cs".

Package existence check passed for "SUNWxwfnt".

Package existence check passed for "SUNWlibC".

Package existence check failed for "SUNWscucm:3.1".

Check failed on nodes:

pre2,pre1

Package existence check failed for "SUNWudlmr:3.1".

Check failed on nodes:

pre2,pre1

Package existence check failed for "SUNWudlm:3.1".

Check failed on nodes:

pre2,pre1

Package existence check failed for "ORCLudlm:Dev_Release_06/11/04,_64bit_3.3.4.8_reentrant".

Check failed on nodes:

pre2,pre1

Package existence check failed for "SUNWscr:3.1".

Check failed on nodes:

pre2,pre1

Package existence check failed for "SUNWscu:3.1".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SEMMNI".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SEMMNS".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SEMMSL".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SEMVMX".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SHMMAX".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SHMMIN".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SHMMNI".

Check failed on nodes:

pre2,pre1

Kernel parameter check failed for "SHMSEG".

Check failed on nodes:

pre2,pre1

Group existence check passed for "dba".

Group existence check passed for "oinstall".

User existence check passed for "oracle".

User existence check passed for "nobody".

System requirement failed for 'database'

Checking CRS integrity...

Checking daemon liveness...

Liveness check passed for "CRS daemon".

Checking daemon liveness...

Liveness check passed for "CSS daemon".

Checking daemon liveness...

Liveness check passed for "EVM daemon".

Checking CRS health...

CRS health check passed.

CRS integrity check passed.

Checking node application existence...

Checking existence of VIP node application (required)

Check passed.

Checking existence of ONS node application (optional)

Check passed.

Checking existence of GSD node application (optional)

Check passed.

Pre-check for database installation was unsuccessful on all the nodes.

從返回的資訊來看，失敗的地方可以分為兩個部分：

第一部分是包檢測失敗，這個原因在前面已經講過了，不會影響安裝，可以忽略。

第二部分是系統核心引數檢測有問題，實際上我已經在/etc/system中設定了相關的核心引數，並且已經生肖，我估計是因為solaris10中，runcluvfy.sh檢測的是資源控制器中設定的引數，而不是/etc/system中設定的引數，所以會報錯。如果你確定已經正確地在/etc/system中設定了合理的引數，則這個錯誤問題不大，不會影響安裝。

正式開始安裝oracle software

在pre1上以root執行：

# xhost +

access control disabled, clients can connect from any host

# su - oracle

Sun Microsystems Inc. SunOS 5.10 Generic January 2005

$ bash

bash-3.00$ export DISPLAY=172.0.2.1:1.0

bash-3.00$ cd /backup/soft/database/

bash-3.00$ ls

10gr2_db_sol.cpio install runInstaller welcome.html

doc response stage

bash-3.00$ ./runInstaller

在介面中選擇自定義安裝、下一步，選擇oracle主目錄

下一步，選擇需要安裝的節點，這裡把所有節點都選擇（pre1），

下一步，選擇需要安裝的元件

下一步，oracle進行一系列的檢查，都透過後點選下一步

選擇系統組（dba）

下一步，選擇安裝內容，這裡需要用ASM，所以選擇第二項，oracle會自動先安裝oracle software，然後再安裝ASM。

下一步，開始安裝，oracle在第一個節點安裝結束後，會自動把檔案複製到其他節點中。

安裝完軟體後，需要配置監聽，配置完監聽後，oracle會自動執行dbca，配置ASM，

輸入sys密碼，

設定引數檔案的路徑，因為現在還沒有共享儲存，故選擇第一個IFILE，注意把路徑修改至：

$ORACLE_HOME/dbs/init+ASM.ora

下一步，oracle開始建立ASM例項，例項建立完畢後，進入ASM DISKGROUP設定介面：

輸入DISK GROUP名稱：DATA

選擇外部冗餘

在/dev/rdsk/c3t0d0s6、/dev/rdsk/c3t0d2s6前打勾，把這兩個分割槽作為ASM磁碟組的磁碟，點選下一步建立磁碟組。

下一步，點選finish。

Oracle還會彈出一個介面要求建庫，這裡打算用其他地方恢復一個資料庫到本地，所以直接選擇cancel，

最後需要在所有節點以root使用者執行一個指令碼：

bash-3.00# /oracle/app/product/10.2/database/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /oracle/app/product/10.2/database

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Creating /usr/local/bin directory...

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /var/opt/oracle/oratab file...

Entries will be added to the /var/opt/oracle/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

至此，oracle軟體安裝完畢。