Oracle 10g rac升級(10.2.0.1 Rac到10.2.0.4)

簡要介紹了Linux下oracle10g rac環境的升級過程

環境如下：

OS: Linux AS 4 U4 32 bit

DBMS: Oracle 10.2.0.1

節點： IBM 3655, 主機名分別為rac01、rac02、rac03

儲存: EMC Celerra NS40 ,採用ASM

word文件包括完整的圖片,下載地址:

http://studycow.itpub.net/resource/37461/28197

[@more@]

三節點Oracle 10.2.0.1 Rac升級到10.2.0.4

環境：
OS: Linux AS 4 U4 32 bit
DBMS: Oracle 10.2.0.1
節點： IBM 3655, 主機名分別為rac01、rac02、rac03
儲存: EMC Celerra NS40 ,採用ASM
補丁下載地址：

升級過程如下：

1 停止資料庫服務，用rman做了全庫備份，再用tar備份了ORA_CRS_HOME和ORACLE_HOME
2 找到安裝rac安裝時第一臺節點,將Patchset上載到rac01伺服器,解壓安裝包

3 升級crs ,oracle10g支援滾動升級crs,我使用了非滾動升級

3.1 每個節點分別停止 EM和 isqlplus
[oracle@rac01 orcl]$ emctl stop dbconsole
TZ set to Asia/Chungking
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[oracle@rac01 ~]$ isqlplusctl stop
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
iSQL*Plus instance on port 5561 is not running ...

3.2 關閉每個節點上的監聽程式

backup]$ srvctl stop listener -n rac01
[oracle@rac02 backup]$ srvctl stop listener -n rac02
[oracle@rac02 backup]$ srvctl stop listener -n rac03

3.3 停止 資料庫例項
[oracle@rac01 orcl]$ srvctl stop database -d orcl

3.4 停止每個節點的ASM例項
[oracle@rac01 orcl]$ srvctl stop asm -n rac01
[oracle@rac01 orcl]$ ssh rac02
Last login: Fri Aug 1 03:59:58 2008 from rac01
[oracle@rac02 ~]$ srvctl stop asm -n rac02
[oracle@rac02 ~]$ srvctl stop asm -n rac03

3.5 停止資料庫服務(此環境沒有配置資料庫服務)

[oracle@rac01 orcl]$ srvctl stop service -d orcl -s orcl
PRKO-2120 : The internal database service orcl cannot be managed with srvctl.

3.6 停止每個節點的ASM例項
[oracle@rac01 orcl]$ srvctl stop asm -n rac01
[oracle@rac01 orcl]$ ssh rac02
Last login: Fri Aug 1 03:59:58 2008 from rac01
[oracle@rac02 ~]$ srvctl stop asm -n rac02
[oracle@rac02 ~]$ srvctl stop asm -n rac03

3.7 停止每個節點的應用
[oracle@rac02 ~]$ srvctl stop nodeapps -n rac01
[oracle@rac02 ~]$ srvctl stop nodeapps -n rac02
[oracle@rac02 ~]$ srvctl stop nodeapps -n rac03

3.8 檢視CRS資源狀態，全部變成了offline
[oracle@rac02 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application OFFLINE OFFLINE
ora....orcl.cs application OFFLINE OFFLINE
ora....cl1.srv application OFFLINE OFFLINE
ora....cl2.srv application OFFLINE OFFLINE
ora....cl3.srv application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....l3.inst application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....01.lsnr application OFFLINE OFFLINE
ora.rac01.gsd application OFFLINE OFFLINE
ora.rac01.ons application OFFLINE OFFLINE
ora.rac01.vip application OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE
ora....02.lsnr application OFFLINE OFFLINE
ora.rac02.gsd application OFFLINE OFFLINE
ora.rac02.ons application OFFLINE OFFLINE
ora.rac02.vip application OFFLINE OFFLINE
ora....SM3.asm application OFFLINE OFFLINE
ora....03.lsnr application OFFLINE OFFLINE
ora.rac03.gsd application OFFLINE OFFLINE
ora.rac03.ons application OFFLINE OFFLINE
ora.rac03.vip application OFFLINE OFFLINE

3.9 停止每個節點上的CRS

[root@rac01 ~]# /u02/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@rac01 ~]# ssh rac02
password:
Last login: Fri Aug 1 03:54:09 2008 from 172.16.0.129
[root@rac02 ~]# /u02/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@rac02 ~]# ssh rac03
password:
Last login: Fri Aug 1 00:56:25 2008 from 172.16.0.40
[root@rac03 ~]# /u02/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
3.10 執行 runInstaller開始啟動oui，注意選擇ORA_CRS_HOME目錄，隨後oracle自動選擇了RAC中的所有節點

3.11 一直往下next，全部成功。最後出現的視窗上要求在每個節點上完成以下兩步：
 以root使用者身份登入，停止crs服務
# CRS_home/bin/crsctl stop crs
 以root使用者身份執行root102指令碼
# CRS_home/install/root102.sh

先停止crs
[root@rac01 ~]# /u02/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

執行root102.sh指令碼，指令碼提示補丁包應用成功

[root@rac01 ~]# /u02/app/oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u02/app/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/u02/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u02/app/oracle/product' is not owned by root
WARNING: directory '/u02/app/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems..
10204 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :
node 1: rac01 rac01_priv rac01
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully

4 升級資料軟體
4.1 在每個節點上停止isqlplus
[oracle@rac01 ~]$ isqlplusctl stop
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
iSQL*Plus instance on port 5561 is not running ...
[oracle@rac01 ~]$ ssh rac02
Last login: Fri Aug 1 04:03:29 2008 from rac01

4.2 在每個節點上停止EM
[oracle@rac02 ~]$ emctl stop dbconsole
TZ set to Asia/Chungking
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.

4.3 關閉ASM例項
[oracle@rac02 backup]$ srvctl stop asm -n rac01
[oracle@rac02 backup]$ srvctl stop asm -n rac02
[oracle@rac02 backup]$ srvctl stop asm -n rac03

4.4 關閉資料庫
backup]$ srvctl stop database -d orcl

4.5 關閉每個節點上的監聽程式

backup]$ srvctl stop listener -n rac01
[oracle@rac02 backup]$ srvctl stop listener -n rac02
[oracle@rac02 backup]$ srvctl stop listener -n rac03

4.6 執行runInstaller啟動oui,選擇ORACLE_HOME，同樣Oracle已經自動選擇了所有rac節點;一直next，沒出現什麼錯誤。

4.7 執行最後一個介面時，Oracle提示在每個節點以root使用者執行root.sh指令碼

在rac01上的執行過程如下：

[root@rac01 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/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.

5 升級資料庫，我使用了DBUA工具
5.1 啟動dbua工具後，會讓使用者選擇升級ASM還是資料庫，由於我們的是從10.2.0.1的基礎上升級，不需要升級ASM，直接跳過,如低於此版本而是必須先升級ASM。

5.2 升級資料庫
要求輸入SYS使用者密碼

一直next,過程中Oracle發現無效物件，忽略


選擇編譯無效物件和編譯並行度



執行升級

整個資料庫升級過程大概持續了1個小時，最後終於大功告成，升級成功！

附：此次升級解決的bug

為了解決一個bug,使用者要求升級rac環境，要求的解決bug，metalink解決如下:
Subject: ORA-600 [kgmgchd1]
Doc ID: Note:139068.1 Type: REFERENCE
Last Revision Date: 03-APR-2008 Status: PUBLISHED

Note: For additional ORA-600 related information please read Note 146580.1

PURPOSE:
This article represents a partially published OERI note.
It has been published because the ORA-600 error has been
reported in at least one confirmed bug.
Therefore, the SUGGESTIONS section of this article may help
in terms of identifying the cause of the error.
This specific ORA-600 error may be considered for full publication
at a later date. If/when fully published, additional information
will be available here on the nature of this error.

SUGGESTIONS:
If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.

Known Issues:
Bug# 5721941 See Note 5721941.8
Additional diagnostict for OERI[kgmgchd1]
Fixed: 10.2.0.4, 11.1.0.6