Linux下oracle11.2.0.4RAC安裝補丁
一、備份數據
略
二、GI補丁安裝
1、更新patch p6880880 版本在11.2.0.3.6以上，下載最新的patch，直接解壓後，將GI和Database原來自帶的OPatch備份（$ORACLE_HOME路徑下）
mv OPatch OPatch.bak
cp -R OPatch / $ORACLE_HOME
opatch version
2、解壓grid補丁包
3、檢查環境
/OPatch/opatchlsinventory -detail -oh
4、安裝GI補丁
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp-no_banner -output
2）安裝補丁
在補丁的說明文檔中，這一步有兩種情況
Case 1: GI Home and the Database Homes that are not shared and ACFS file system is not configured.
As root user, execute the following command on each node of the cluster:
# opatch auto /27475913 -ocmrf
Case 2: GI Home is not shared, Database Home is shared, ACFS may be used.
我這個環境是第一種情況，所以就直接使用第一種情況安裝，在一節點執行完，再在二節點執行
三、Database補丁安裝
1、檢查環境
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
2、Database補丁安裝
在補丁的說明文檔中，可以使用滾動升級方式（三種模式）
All-Node Patch
. Shutdown all Oracle instances on all nodes
. Apply the patch to the RAC home on all nodes
. Bring all instances up
Minimum downtime
. Shutdown all the Oracle instances on node1
. Apply the patch to the RAC home on node 1
. Shutdown all the Oracle instances on node 2
. Apply the patch to the RAC home on node 2
. Shutdown all the Oracle instances on node 3
. At this point, instances on nodes 1 and 2 can be brought up
. Apply the patch to the RAC home on node 3
. Startup all the Oracle instances on node 3
Rolling patch (no downtime)
. Shutdown all the Oracle instances on node1
. Apply the patch to the RAC home on node 1
. Start all the Oracle instances on node 1
. Shutdown all the Oracle instances on node 2
. Apply the patch to the RAC home on node 2
. Start all the Oracle instances on node 2
. Shutdown all the Oracle instances on node 3
. Apply the patch to the RAC home on node 3
. Start all the Oracle instances on node 3
判斷補丁是否可以支持滾動升級，可以使用以下語句
- 9i or 10gR1: opatch query -is_rolling
- 10gR2: opatch query -all [unzipped patch location] |grep rolling
- 10gR2 on Windows: opatch query -all [unzippedpatch location] | findstr rolling
- Later 10gR2 or 11g: opatch query-is_rolling_patch [unzipped patch location]
我這裡由於還沒有建庫，所以我就直接apply補丁（在一節點執行完，再在二節點執行）
3、更新數據字典
啟動資料庫後，執行以下腳本
cd $ORACLE_HOME/rdbms/adminsqlplus /nologSQL> CONNECT / AS SYSDBASQL> STARTUPSQL> @catbundle.sql psu applySQL> QUIT
cd $ORACLE_HOME/rdbms/adminsqlplus /nologSQL> CONNECT / AS SYSDBASQL> @utlrp.sql
SQL > @dbmsjdev.sqlSQL > exec dbms_java_dev.disable
四、檢查補丁應用情況
opatch lsinventory
TAG:abaoDiary |