Oracle 11g RAC自動(dòng)打GI PSU補(bǔ)丁(11.2.0.4.8)

濱海網(wǎng)站建設(shè)公司成都創(chuàng)新互聯(lián)公司,濱海網(wǎng)站設(shè)計(jì)制作，有大型網(wǎng)站制作公司豐富經(jīng)驗(yàn)。已為濱海上千余家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\成都外貿(mào)網(wǎng)站建設(shè)公司要多少錢(qián)，請(qǐng)找那個(gè)售后服務(wù)好的濱海做網(wǎng)站的公司定做！

打補(bǔ)丁(11.2.0.4.8)，可以參考補(bǔ)丁p21523375_112040_Linux-x86-64.zip中的reamme.html文件，文件中詳細(xì)介紹了如何打補(bǔ)丁，以下為概要本實(shí)驗(yàn)的簡(jiǎn)單記錄。

1、 下載補(bǔ)丁并上傳至所有集群節(jié)點(diǎn)

上傳補(bǔ)丁p21523375_112040_Linux-x86-64.zip到各節(jié)點(diǎn)/mnt目錄，解壓后賦權(quán)移至/tmp目錄中。

#unzip p21523375_112040_Linux-x86-64.zip

#chown –R grid:oinstall  21523375

#mv /mnt/21523375  /tmp/

2、升級(jí)OPatch工具（所有節(jié)點(diǎn)grid與oracle用戶均需執(zhí)行）

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、創(chuàng)建OCM文件(所有節(jié)點(diǎn)均需執(zhí)行)

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

Jason1節(jié)點(diǎn)

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節(jié)點(diǎn)

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(所有節(jié)點(diǎn)均需執(zhí)行)(無(wú)需關(guān)閉任何組件及資源)

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#

補(bǔ)丁安裝完畢之后，查看集群資源狀態(tài)

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、根據(jù)輸出結(jié)果可以觀察到打補(bǔ)丁的順序?yàn)椋宏P(guān)閉RAC-->補(bǔ)丁RAC -->關(guān)閉CRS -->補(bǔ)丁CRS -->啟動(dòng)CRS-->啟動(dòng)RAC

      2、ACFS driver install actions failed，該報(bào)錯(cuò)查看日志顯示為CRS-10001:20-Jan-1613:31 ACFS-9109: oracleacfs.ko driver failed to load.當(dāng)初安裝grid執(zhí)行root.sh時(shí)也有過(guò)同樣的報(bào)錯(cuò)，打過(guò)補(bǔ)丁p17475946_112040_Linux-x86-64.zip之后可以正常執(zhí)行root.sh（參考該鏈接處理suse11sp3執(zhí)行root.sh失敗bug處理）?，F(xiàn)在不知道為什么打完補(bǔ)丁之后還會(huì)有同樣的問(wèn)題。

      3、集群資源中該資源為offline,是因?yàn)閛racleacfs.kodriver failed to load加載失敗導(dǎo)致。重啟動(dòng)各節(jié)點(diǎn)資源將恢復(fù)正常。

ora.registry.acfs

               ONLINE  OFFLINE     jason1                                      

               ONLINE  OFFLINE     jason2    

5、加載修改SQL文件到數(shù)據(jù)庫(kù)修改數(shù)據(jù)字典

 

在RAC環(huán)境中僅需在一個(gè)節(jié)點(diǎn)執(zhí)行以下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補(bǔ)丁版本

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、報(bào)錯(cuò)處理

補(bǔ)丁自動(dòng)升級(jí)時(shí)報(bào)如下錯(cuò)誤

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 #

該報(bào)錯(cuò)可以參考GI OPatch升級(jí) The opatch Component check failed. This patch is not applicable for...鏈接處理。

文章名稱(chēng)：InstallationOracle11gR2RAC---自動(dòng)打GIPSU補(bǔ)丁(11.2.0.4.8)
新聞來(lái)源：http://aaarwkj.com/article16/ipdcdg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站建設(shè)、靜態(tài)網(wǎng)站、網(wǎng)站導(dǎo)航、Google、App設(shè)計(jì)、品牌網(wǎng)站制作

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)