InstallationOracle11gR2RAC---自動打GIPSU補丁(11.2.0.4.8)

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

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

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

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

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

#unzip p21523375_112040_Linux-x86-64.zip

#chown –R grid:oinstall 21523375

#mv /mnt/21523375 /tmp/

2、升級OPatch工具（所有節(jié)點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é)點均需執(zhí)行)

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

Jason1節(jié)點

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é)點

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é)點均需執(zhí)行)(無需關(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#

補丁安裝完畢之后，查看集群資源狀態(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é)果可以觀察到打補丁的順序為：關(guān)閉RAC-->補丁RAC -->關(guān)閉CRS -->補丁CRS -->啟動CRS-->啟動RAC

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

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

ora.registry.acfs

ONLINE OFFLINE jason1

ONLINE OFFLINE jason2

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

在RAC環(huán)境中僅需在一個節(jié)點執(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補丁版本

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

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...鏈接處理。

文章名稱：InstallationOracle11gR2RAC---自動打GIPSU補丁(11.2.0.4.8)
新聞來源：http://bm7419.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è)計、品牌網(wǎng)站制作

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

猜你還喜歡下面的內(nèi)容