Installation Oracle11gR2 RAC---自動打GI PSU補丁(11.2.0.4.8)

Oracle 11g RAC自動打GI PSU補丁(11.2.0.4.8)

打補丁(11.2.0.4.8)，可以參考補丁p21523375_112040_Linux-x86-64.zip中的reamme.html文件，文件中詳細介紹了如何打補丁，以下為概要本實驗的簡單記錄。

1、  下載補丁并上傳至所有集群節點

上傳補丁p21523375_112040_Linux-x86-64.zip到各節點/mnt目錄，解壓后賦權移至/tmp目錄中。

#unzip p21523375_112040_Linux-x86-64.zip

#chown –R grid:oinstall  21523375

#mv /mnt/21523375  /tmp/

2、升級OPatch工具（所有節點grid與oracle用戶均需執行）

grid:

grid@jason1:/u01/app/11.2.0/grid/OPatch> ./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

grid@jason1:/u01/app/11.2.0/grid/OPatch> cd /u01/app/11.2.0/grid/

grid@jason1:/u01/app/11.2.0/grid>mv OPatch  OPatch.bak

grid@jason1:/u01/app/11.2.0/grid> unzip  p6880880_112000_LINUX.zip

grid@jason1:/u01/app/11.2.0/grid> cdOPatch

grid@jason1:/u01/app/11.2.0/grid/OPatch>./opatch version

OPatch Version: 11.2.0.3.10

OPatch succeeded.

grid@jason1:/u01/app/11.2.0/grid/OPatch>

Oracle:

oracle@jason1:~> cd/u01/app/oracle/product/11.2.0/dbhome_1/OPatch

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>cd..

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1> mv OPatch  OPatch.bak

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1>unzip p6880880_112000_LINUX.zip

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1> cd OPatch

oracle@jason1:~> cd/u01/app/oracle/product/11.2.0/dbhome_1/OPatch

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>./opatch version

OPatch Version: 11.2.0.3.10

OPatch succeeded.

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>

3、創建OCM文件(所有節點均需執行)

OCM文件的創建可參考該鏈接http://dreamsanqin.blog.51cto.com/845412/1736863

Jason1節點

grid@jason1:/u01/app/11.2.0/grid/OPatch/ocm/bin>./emocmrsp -no_banner -output /tmp/ocm.rsp

Provide your email address to be informedof security issues, install and

initiate Oracle Configuration Manager.Easier for you if you use your My

Oracle Support Email address/User Name.

Visithttp://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address fornotification of security issues.

Do you wish to remain uninformed ofsecurity issues ([Y]es, [N]o) [N]:  y

The OCM configuration response file(/tmp/ocm.rsp) was successfully created.

grid@jason1:/u01/app/11.2.0/grid/OPatch/ocm/bin>

Jason2節點

grid@jason2:/u01/app/11.2.0/grid/OPatch/ocm/bin>./emocmrsp -no_banner -output /tmp/ocm.rsp

Provide your email address to be informedof security issues, install and

initiate Oracle Configuration Manager.Easier for you if you use your My

Oracle Support Email address/User Name.

Visithttp://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address fornotification of security issues.

Do you wish to remain uninformed ofsecurity issues ([Y]es, [N]o) [N]:  y

The OCM configuration response file(/tmp/ocm.rsp) was successfully created.

grid@jason2:/u01/app/11.2.0/grid/OPatch/ocm/bin>

4、OPatch apply(所有節點均需執行)(無需關閉任何組件及資源)

Jason1：

jason1:/u01/app/11.2.0/grid/OPatch# /u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf /tmp/ocm.rsp

Executing/u01/app/11.2.0/grid/perl/bin/perl/u01/app/11.2.0/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 21523375-ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This isthe main log file:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-44-20.log

Thisfile will show your detected configuration and all the steps that opatchautoattempted to do on your system:

/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-44-20.report.log

2016-01-2012:44:20: Starting Clusterware Patch Setup

Usingconfiguration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

StoppingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StoppedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

patch/tmp/21523375/21352635  apply successfulfor home /u01/app/oracle/product/11.2.0/dbhome_1

patch/tmp/21523375/21352649/custom/server/21352649 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1

StoppingCRS...

StoppedCRS successfully

patch/tmp/21523375/21352635  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352649  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352642  apply successfulfor home  /u01/app/11.2.0/grid

StartingCRS...

InstallingTrace File Analyzer

ACFSdriver install actions failed

CRS-4123:Oracle High Availability Services has been started.

StartingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StartedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

opatchauto succeeded.

jason1:/u01/app/11.2.0/grid/OPatch#

Jason2:

jason2:/u01/app/11.2.0/grid/OPatch# /u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf /tmp/ocm.rsp

Executing/u01/app/11.2.0/grid/perl/bin/perl/u01/app/11.2.0/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 21523375-ocmrf /tmp/ocm.rsp -paramfile/u01/app/11.2.0/grid/crs/install/crsconfig_params

This isthe main log file:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_14-09-33.log

Thisfile will show your detected configuration and all the steps that opatchautoattempted to do on your system:

/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_14-09-33.report.log

2016-01-2014:09:33: Starting Clusterware Patch Setup

Usingconfiguration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

StoppingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StoppedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

patch/tmp/21523375/21352635  apply successfulfor home /u01/app/oracle/product/11.2.0/dbhome_1

patch/tmp/21523375/21352649/custom/server/21352649 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1

StoppingCRS...

StoppedCRS successfully

patch/tmp/21523375/21352635  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352649  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352642  apply successfulfor home  /u01/app/11.2.0/grid

StartingCRS...

InstallingTrace File Analyzer

ACFSdriver install actions failed

CRS-4123:Oracle High Availability Services has been started.

StartingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StartedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

opatchauto succeeded.

jason2:/u01/app/11.2.0/grid/OPatch#

補丁安裝完畢之后，查看集群資源狀態

jason2:/u01/app/11.2.0/grid/bin# ./crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

--------------------------------------------------------------------------------

LocalResources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.FRA.dg

               ONLINE  ONLINE      jason1                                       

               ONLINE  ONLINE      jason2                                      

ora.LISTENER.lsnr

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                       

ora.OCR.dg

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.asm

               ONLINE  ONLINE      jason1                  Started            

               ONLINE  ONLINE      jason2                  Started            

ora.gsd

               OFFLINE OFFLINE      jason1                                      

               OFFLINE OFFLINE      jason2                                      

ora.net1.network

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.ons

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.registry.acfs

               ONLINE  OFFLINE     jason1                                      

               ONLINE OFFLINE      jason2                                       

--------------------------------------------------------------------------------

ClusterResources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1       ONLINE  ONLINE       jason1                                      

ora.cvu

      1       ONLINE  ONLINE       jason1                                      

ora.jason1.vip

      1       ONLINE  ONLINE       jason1                                       

ora.jason2.vip

      1       ONLINE  ONLINE       jason2                                      

ora.oc4j

      1       ONLINE  ONLINE       jason1                                      

ora.oracle.db

      1       ONLINE  ONLINE       jason1                   Open               

      2       ONLINE  ONLINE       jason2                   Open               

ora.scan1.vip

      1       ONLINE  ONLINE       jason1                                      

jason2:/u01/app/11.2.0/grid/bin#

備注：1、根據輸出結果可以觀察到打補丁的順序為：關閉RAC-->補丁RAC -->關閉CRS -->補丁CRS -->啟動CRS-->啟動RAC

      2、ACFS driver install actions failed，該報錯查看日志顯示為CRS-10001:20-Jan-1613:31 ACFS-9109: oracleacfs.ko driver failed to load.當初安裝grid執行root.sh時也有過同樣的報錯，打過補丁p17475946_112040_Linux-x86-64.zip之后可以正常執行root.sh（參考該鏈接處理suse11sp3 執行root.sh失敗bug處理）。現在不知道為什么打完補丁之后還會有同樣的問題。

      3、集群資源中該資源為offline,是因為oracleacfs.kodriver failed to load加載失敗導致。重啟動各節點資源將恢復正常。

ora.registry.acfs

               ONLINE  OFFLINE     jason1                                      

               ONLINE  OFFLINE     jason2     

5、加載修改SQL文件到數據庫修改數據字典

在RAC環境中僅需在一個節點執行以下SQL。

（1）

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle.sql psu apply

SQL> QUIT

The catbundle.sql execution is reflected inthe dba_registry_history view by a row associated with bundle series PSU.

（2）

If the OJVM PSU was applied for a previousGI PSU patch, you may see invalid Java classes after execution of the catbundle.sqlscript in the previous step. If this is the case, run utlrp.sql to re-validatethese Java classes.

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @utlrp.sql

6、檢查DB補丁版本

SQL> select * from dba_registry_history;

ACTION_TIME                       ACTION   NAMESPACE VERSION   ID BUNDLE_SERIESCOMMENTS

--------------------------------- -----------------------------------------------------------------------------------------------------------------------------

24-AUG-13 12.03.45.119862 PM      APPLY   SERVER     11.2.0.4   0 PSU          Patchset 11.2.0.2.0

07-JAN-16 11.04.29.479612 PM      APPLY   SERVER     11.2.0.4   0 PSU          Patchset 11.2.0.2.0

20-JAN-16 03.31.06.023073 PM      APPLY   SERVER     11.2.0.4   8 PSU           PSU 11.2.0.4.8

SQL>

7、報錯處理

補丁自動升級時報如下錯誤

jason1:/u01/app/11.2.0/grid/OPatch # /u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf /tmp/ocm.rsp 

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 21523375 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-38-42.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-38-42.report.log

2016-01-20 12:38:42: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

The opatch Component check failed. This patch is not applicable for /u01/app/oracle/product/11.2.0/dbhome_1

The opatch Component check failed. This patch is not applicable for /u01/app/oracle/product/11.2.0/dbhome_1

Conflict check failed for oracle home  /u01/app/oracle/product/11.2.0/dbhome_1

Conflict check failed

ERROR: Conflict-Check has failed . Please refer to /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-38-42.log for details

opatch auto failed.

jason1:/u01/app/11.2.0/grid/OPatch #

該報錯可以參考GI OPatch升級 The opatch Component check failed. This patch is not applicable for...鏈接處理。