安装PSU 11.2

来源：互联网发布：nginx正向代理https 编辑：程序博客网时间：2024/05/20 17:07

安装GRID 11.2.0.3.7步骤

1.GRID安装好后的状态：

[root@gapsdb1:/oracle11g/app/grid/log/gapsdb1/crsd]#st

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Local Resources

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

ora.DATA.dg

ONLINE ONLINE gapsdb1

ONLINE ONLINE gapsdb2

ora.LISTENER.lsnr

ONLINE ONLINE gapsdb1

ONLINE ONLINE gapsdb2

ora.asm

ONLINE ONLINE gapsdb1 Started

ONLINE ONLINE gapsdb2 Started

ora.gsd

OFFLINE OFFLINE gapsdb1

OFFLINE OFFLINE gapsdb2

ora.net1.network

ONLINE ONLINE gapsdb1

ONLINE ONLINE gapsdb2

ora.ons

ONLINE ONLINE gapsdb1

ONLINE ONLINE gapsdb2

ora.registry.acfs

ONLINE ONLINE gapsdb1

ONLINE ONLINE gapsdb2

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE gapsdb1

ora.cvu

1 ONLINE ONLINE gapsdb1

ora.gapsdb1.vip

1 ONLINE ONLINE gapsdb1

ora.gapsdb2.vip

1 ONLINE ONLINE gapsdb2

ora.oc4j

1 ONLINE ONLINE gapsdb1

ora.scan1.vip

1 ONLINE ONLINE gapsdb1

2. 准备11.2.0.3.7安装包p16742216_112030_AIX64-5L.zip,并解压到一个空目录 /oracle11g/p7中,该目录为在两节点设置的NFS共享目录,

[root@gapsdb2:/]# mount 38.19.18.132:/oracle11g/p7 /oracle11g/p7

[root@gapsdb2:/]#cd /oracle11g/p7

[root@gapsdb2:/oracle11g/p7]#ls -lrt

total 2368528

-rw-r--r-- 1 root system 450 Jun 26 23:50 bundle.xml

-rw-r--r-- 1 root system 0 Jun 26 23:50 atp_lfp

-rw-r--r-- 1 root system 21 Jun 26 23:50 README.txt

drwxr-xr-x 5 root system 256 Jun 26 23:50 16619898

drwxrwxr-x 9 root system 256 Jun 26 23:50 16619892

-rw-rw-r-- 1 root system 60252 Jul 15 11:53 README.html

3. 准备OPatch的最新版本p6880880_112000_AIX64-5L.zip，解压到grid用户的$ORACLE_HOME/下，替换原有的OPatch。

[root@gapsdb1:/oracle11g]#cd $GRID_HOME

[root@gapsdb1:/oracle11g/app/grid]#mv OPatch old_OPatch

[root@gapsdb1:/oracle11g/app/grid]#unzip p6880880_112000_AIX64-5L.zip

Archive: p6880880_112000_AIX64-5L.zip

creating: OPatch/

creating: OPatch/oplan/

inflating: OPatch/oplan/README.html

inflating: OPatch/oplan/README.txt

creating: OPatch/oplan/jlib/

inflating: OPatch/oplan/jlib/oplan.jar

inflating: OPatch/oplan/jlib/oracle.oplan.classpath.jar

inflating: OPatch/oplan/jlib/automation.jar

inflating: OPatch/oplan/jlib/OsysModel.jar

inflating: OPatch/oplan/jlib/EMrepoDrivers.jar

inflating: OPatch/oplan/jlib/Validation.jar

inflating: OPatch/oplan/jlib/ValidationRules.jar

inflating: OPatch/oplan/jlib/osysmodel-utils.jar

inflating: OPatch/oplan/jlib/CRSProductDriver.jar

creating: OPatch/oplan/jlib/apache-commons/

inflating: OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar

creating: OPatch/oplan/jlib/jaxb/

inflating: OPatch/oplan/jlib/jaxb/activation.jar

inflating: OPatch/oplan/jlib/jaxb/jaxb-api.jar

inflating: OPatch/oplan/jlib/jaxb/jaxb-impl.jar

inflating: OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar

inflating: OPatch/oplan/oplan

creating: OPatch/docs/

inflating: OPatch/docs/FAQ

inflating: OPatch/docs/Users_Guide.txt

inflating: OPatch/docs/Prereq_Users_Guide.txt

creating: OPatch/jlib/

creating: OPatch/jlib/fa/

inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.jar

inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.unix.jar

inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.windows.jar

inflating: OPatch/jlib/opatch.jar

inflating: OPatch/jlib/opatchsdk.jar

inflating: OPatch/jlib/oracle.opatch.classpath.jar

inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar

inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar

creating: OPatch/opatchprereqs/

creating: OPatch/opatchprereqs/opatch/

inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml

inflating: OPatch/opatchprereqs/opatch/rulemap.xml

inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml

creating: OPatch/opatchprereqs/oui/

inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml

inflating: OPatch/opatchprereqs/prerequisite.properties

creating: OPatch/crs/

creating: OPatch/crs/log/

inflating: OPatch/crs/auto_patch.pl

inflating: OPatch/crs/installPatch.excl

inflating: OPatch/crs/patch112.pl

inflating: OPatch/crs/patch11202.pl

inflating: OPatch/crs/patch11203.pl

inflating: OPatch/opatch

inflating: OPatch/opatch.bat

inflating: OPatch/opatch.pl

inflating: OPatch/opatch.ini

inflating: OPatch/opatchdiag

inflating: OPatch/opatchdiag.bat

inflating: OPatch/emdpatch.pl

inflating: OPatch/README.txt

creating: OPatch/ocm/

creating: OPatch/ocm/bin/

inflating: OPatch/ocm/bin/emocmrsp

creating: OPatch/ocm/doc/

creating: OPatch/ocm/lib/

inflating: OPatch/ocm/lib/emocmclnt-14.jar

inflating: OPatch/ocm/lib/emocmclnt.jar

inflating: OPatch/ocm/lib/emocmcommon.jar

inflating: OPatch/ocm/lib/http_client.jar

inflating: OPatch/ocm/lib/jcert.jar

inflating: OPatch/ocm/lib/jnet.jar

inflating: OPatch/ocm/lib/jsse.jar

inflating: OPatch/ocm/lib/log4j-core.jar

inflating: OPatch/ocm/lib/osdt_core3.jar

inflating: OPatch/ocm/lib/osdt_jce.jar

inflating: OPatch/ocm/lib/regexp.jar

inflating: OPatch/ocm/lib/xmlparserv2.jar

extracting: OPatch/ocm/ocm.zip

inflating: OPatch/ocm/ocm_platforms.txt

[root@gapsdb1:/oracle11g/app/grid]#chown -R grid:oinstall OPatch

[root@gapsdb1:/oracle11g/app/grid]#ls -l OPatch

total 232

-rwxrwxr-x 1 grid oinstall 2991 Mar 26 15:49 README.txt

drwxrwxr-x 3 grid oinstall 256 Mar 26 15:49 crs

drwxrwxr-x 2 grid oinstall 256 Mar 26 15:49 docs

-rw-rw-r-- 1 grid oinstall 23695 Mar 26 15:49 emdpatch.pl

drwxrwxr-x 3 grid oinstall 4096 Mar 26 15:49 jlib

drwxrwxr-x 5 grid oinstall 256 Mar 26 15:50 ocm

-rwx--x--- 1 grid oinstall 31493 Mar 26 15:49 opatch

-rwxrwxr-x 1 grid oinstall 19867 Mar 26 15:49 opatch.bat

-rw-rw-r-- 1 grid oinstall 49 Mar 26 15:49 opatch.ini

-rw-rw-r-- 1 grid oinstall 2576 Mar 26 15:49 opatch.pl

-rwxrwxr-x 1 grid oinstall 10056 Mar 26 15:49 opatchdiag

-rwxrwxr-x 1 grid oinstall 9352 Mar 26 15:49 opatchdiag.bat

drwxrwxr-x 4 grid oinstall 256 Mar 26 15:49 opatchprereqs

drwxrwxr-x 3 grid oinstall 256 Mar 26 15:49 oplan

[root@gapsdb1:/oracle11g/app/grid]#

grid@gapsdb1:/oracle11g/app/grid$cd OPatch

grid@gapsdb1:/oracle11g/app/grid/OPatch$./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

4. 生成OCM file（OCM response file is required and is not optional.）

grid@gapsdb1:/oracle11g/app/grid/OPatch$cd ocm

grid@gapsdb1:/oracle11g/app/grid/OPatch/ocm$cd bin

grid@gapsdb1:/oracle11g/app/grid/OPatch/ocm/bin$ls

emocmrsp

grid@gapsdb1:/oracle11g/app/grid/OPatch/ocm/bin$emocmrsp -no_banner -output grid1.rsp

Provide your email address to be informed of security issues, install and

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

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

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

The OCM configuration response file (grid1.rsp) was successfully created.

grid@gapsdb1:/oracle11g/app/grid/OPatch/ocm/bin$ls -l

total 32

-rwxrw---- 1 grid oinstall 9063 Nov 27 2009 emocmrsp

-rw-r--r-- 1 grid oinstall 621 Aug 09 13:19 grid1.rsp

5. Apply patch：

As root user execute:

# opatch auto /oracle11g/p7/16619898 -oh /oracle11g/app/grid -ocmrf /oracle11g/app/oracle/grid1.rsp[为下面的完整命令；11.2.0.3.7要求auto方式安装]

[root@gapsdb1:/oracle11g/app]#-ocmrf /oracle11g/app/grid/OPatch/ocm/bin/grid1.rsp <

Executing /oracle11g/app/grid/perl/bin/perl /oracle11g/app/grid/OPatch/crs/patch11203.pl -patchdir /oracle11g -patchn p7 -oh /oracle11g/app/grid -ocmrf /oracle11g/app/grid/OPatch/ocm/bin/grid1.rsp -paramfile /oracle11g/app/grid/crs/install/crsconfig_params

/oracle11g/app/grid/crs/install/crsconfig_params

/oracle11g/app/grid/crs/install/s_crsconfig_defs

This is the main log file: /oracle11g/app/grid/cfgtoollogs/opatchauto2013-08-09_13-28-01.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oracle11g/app/grid/cfgtoollogs/opatchauto2013-08-09_13-28-01.report.log

2013-08-09 13:28:01: Starting Clusterware Patch Setup

Using configuration parameter file: /oracle11g/app/grid/crs/install/crsconfig_params

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.crsd' on 'gapsdb1'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.cvu' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.oc4j' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'gapsdb1'

CRS-2677: Stop of 'ora.cvu' on 'gapsdb1' succeeded

CRS-2672: Attempting to start 'ora.cvu' on 'gapsdb2'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'gapsdb1'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.gapsdb1.vip' on 'gapsdb1'

CRS-2676: Start of 'ora.cvu' on 'gapsdb2' succeeded

CRS-2677: Stop of 'ora.gapsdb1.vip' on 'gapsdb1' succeeded

CRS-2672: Attempting to start 'ora.gapsdb1.vip' on 'gapsdb2'

CRS-2677: Stop of 'ora.scan1.vip' on 'gapsdb1' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'gapsdb2'

CRS-2676: Start of 'ora.scan1.vip' on 'gapsdb2' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'gapsdb2'

CRS-2676: Start of 'ora.gapsdb1.vip' on 'gapsdb2' succeeded

CRS-2677: Stop of 'ora.registry.acfs' on 'gapsdb1' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'gapsdb2' succeeded

CRS-2677: Stop of 'ora.oc4j' on 'gapsdb1' succeeded

CRS-2672: Attempting to start 'ora.oc4j' on 'gapsdb2'

CRS-2676: Start of 'ora.oc4j' on 'gapsdb2' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'gapsdb1'

CRS-2677: Stop of 'ora.asm' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'gapsdb1'

CRS-2677: Stop of 'ora.ons' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'gapsdb1'

CRS-2677: Stop of 'ora.net1.network' on 'gapsdb1' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'gapsdb1' has completed

CRS-2677: Stop of 'ora.crsd' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.evmd' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.asm' on 'gapsdb1'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'gapsdb1'

CRS-2677: Stop of 'ora.evmd' on 'gapsdb1' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'gapsdb1' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'gapsdb1' succeeded

CRS-2677: Stop of 'ora.asm' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'gapsdb1'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'gapsdb1'

CRS-2677: Stop of 'ora.cssd' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.crf' on 'gapsdb1'

CRS-2677: Stop of 'ora.crf' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'gapsdb1'

CRS-2677: Stop of 'ora.gipcd' on 'gapsdb1' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'gapsdb1'

CRS-2677: Stop of 'ora.drivers.acfs' on 'gapsdb1' succeeded

CRS-2677: Stop of 'ora.gpnpd' on 'gapsdb1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'gapsdb1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

Successfully unlock /oracle11g/app/grid

patch /oracle11g/p7/16619898 apply successful for home /oracle11g/app/grid

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

Oracle Grid Infrastructure stack start initiated but failed to complete at /oracle11g/p7/16619898/files/crs/install/crsconfig_lib.pm line 11627.[已成功安装，该fail由AIX操作系统Bug所致，建议先打到AIX6.1 tl08-02或直接打补丁IV35888]

[root@gapsdb1:/oracle11g/app]#

6. Check patch：

grid@gapsdb1:/home/grid$opatch lspatches

16619898;Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)

grid@gapsdb1:/home/grid$

grid@gapsdb1:/oracle11g/app/grid/OPatch/ocm/bin$opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.4

Oracle Home : /oracle11g/app/grid

Central Inventory : /oracle11g/app/oraInventory

from : /oracle11g/app/grid/oraInst.loc

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.3.0

Log file location : /oracle11g/app/grid/cfgtoollogs/opatch/opatch2013-08-09_14-30-59PM_1.log

Lsinventory Output file location : /oracle11g/app/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-08-09_14-30-59PM.txt

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

Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.3.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 16619898 : applied on Fri Aug 09 13:39:00 CDT 2013

Unique Patch ID: 16436752

Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)"

Created on 26 Jun 2013, 21:46:53 hrs PST8PDT

Bugs fixed:

16619898, 16315641, 15876003, 14275572, 13919095, 13696251, 13348650

12659561, 14305980, 14277586, 13987807, 14625969, 13825231, 12794268

13000491, 13498267, 15934834, 11675721, 14082976, 12771830, 14515980

14085018, 13943175, 14102704, 14171552, 12594616, 13879428, 12897902

12726222, 12829429, 13079948, 13090686, 12995950, 13251796, 13582411

12990582, 13857364, 15856610, 13082238, 12947871, 13256955, 13037709

14535011, 12878750, 14048512, 11772838, 13058611, 13001955, 13440962

13727853, 13425727, 12885323, 12870400, 14212634, 14407395, 13332363

13430626, 13811209, 12709476, 14168708, 14096821, 14626717, 13460353

13694885, 12857064, 12899169, 13111013, 12558569, 13323698, 10260842

13085732, 16555186, 10317921, 16077216, 13869978, 12914824, 13789135

12730342, 12950823, 13355963, 13531373, 14268365, 13776758, 12720728

13620816, 13023609, 16578706, 13024624, 13039908, 15911134, 13036424

13938166, 13011520, 13569812, 12758736, 13001901, 13077654, 13430715

13550689, 13806545, 13634583, 14271305, 12538907, 13947200, 12996428

13066371, 13483672, 12897651, 13540563, 12896850, 13241779, 12728585

12876314, 12925041, 12650672, 12398492, 12848480, 13652088, 16307750

12917897, 12975811, 13653178, 13371153, 14800989, 10114953, 14001941

11836951, 14179376, 12965049, 14773530, 12765467, 12950415, 15998768

13339443, 13965075, 16210540, 14307855, 12784559, 14242977, 13955385

12704789, 13745317, 13074261, 12971251, 13993634, 13523527, 13719731

13396284, 12639013, 12867511, 12959140, 14748254, 13912274, 12829917

12349553, 12849377, 12934171, 13843080, 14496536, 13899736, 13924431

12680491, 13334158, 10418841, 12832204, 13838047, 13002015, 14639430

15920201, 12791719, 13886023, 13821454, 12782756, 14100232, 14186070

14569263, 12873909, 13845120, 14214257, 12914722, 12842804, 12772345

12663376, 14059576, 13889047, 12695029, 13924910, 13146560, 14070200

13820621, 14304758, 12996572, 13941934, 14711358, 13019958, 13888719

16463033, 12823838, 13877508, 12983005, 12823042, 16436434, 14494305

13582706, 13617861, 12825835, 13025879, 13853089, 13410987, 13570879

13247273, 13255295, 14152875, 13912373, 13011182, 13243172, 15978267

13045518, 12765868, 11825850, 15986571, 13345868, 13683090, 12932852

13038806, 14588629, 14251904, 13396356, 13697828, 12834777, 13258062

14371335, 13657366, 12810890, 15917085, 13502441, 14637577, 13880925

13726162, 14153867, 13506114, 12820045, 13604057, 13506408, 13542331

13263435, 14009845, 12827493, 13637590, 13068077

Rac system comprising of multiple nodes

Local node = gapsdb1

Remote node = gapsdb2

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

OPatch succeeded.

grid@gapsdb1:/oracle11g/app/grid/OPatch/ocm/bin$opatch lspatches

16619898;Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)