[RAC] Oracle PSU 적용 실패 시

1부 PSU auto 적용

(1). 최신 OPatch로 교체
– README.html을 열어보면 필요한 OPatch 버전이 있으므로 해당 버전 이상의 OPatch로 교체해준다.
– 패치번호 6880880으로 검색 후에 최신 버전으로 Download.
– GRID_HOME, ORACLE_HOME 경로에 있는 OPatch 교체

(2). PSU 파일을 unzip
(3). README.html 확인 후 진행
– 패치에 필요한 정보나 설치 과정과 command, Known Issue등 이 정리되어 있다.

(4). Auto 적용을 위한 ocm rsp 파일 생성
– OPatch/ocm/bin/emocmrsp 수행

(5). Auto로 Patch 적용
– PSU unzip 한 경로에서 패치 수행
– /oracle/app/11.2.0/grid/OPatch/opatch auto –ocmrf /oracle/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
– 수행 시 자동으로 한쪽씩 내리며 PSU 적용 됨

(6). Catbundle.sql 수행

(7). PSU 적용 확인
– opatch lsinventory를 통해 적용된 패치 내역 확인.

(8). dba_registry_history를 통해 패치 적용 내역을 확인할 수 있다.

2부 PSU auto 실패 시 napply 적용

1. 양쪽 Node EM DBCONSOLE 정지

$ emctl stop dbconsole

2. Opatch napply실시

p17272731 opatch 실시(root user)

# cd $GI_HOME/OPatch/ocm/bin/

# ls

[oracle@ ~]$ cd /oracle/OPa*

[oracle@OPatch]$ ls

README.txt jlib opatch.pl opatchprereqs oplan

crs ocm opatchauto-dir operr scripts

docs opatch opatchdiag operr.bat version.txt

emdpatch.pl opatch.bat opatchdiag.bat operr_readme.txt

# cd ocm/bin

# ./emocmrsp

OCM Installation Response Generator 10.3.7.0.0 – Production

Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved.

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 (ocm.rsp) was successfully created.

[oracle@bin]$ ls -l

-rwxr-x— 1 oracle dba 9063 Nov 27 2009 emocmrsp

-rw-r–r– 1 oracle oinstall 623 Jul 16 05:58 ocm.rsp

[root@install]# ./rootcrs.pl –unlock

/* 스크립트 수행하면 grid 홈폴더에 파일들이 oracle:dba 권한으로 풀린다. */

Using configuration parameter file: ./crsconfig_params

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘rac01’

CRS-2673: Attempting to stop ‘ora.crsd’ on ‘rac01’

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on ‘rac01’

CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ‘rac01’

CRS-2673: Attempting to stop ‘ora.DATA.dg’ on ‘rac01’

CRS-2673: Attempting to stop ‘ora.rac01.vip’ on ‘rac01’

CRS-2677: Stop of ‘ora.rac01.vip’ on ‘rac01’ succeeded

CRS-2672: Attempting to start ‘ora.rac01.vip’ on ‘rac02’

CRS-2677: Stop of ‘ora.LISTENER_SCAN1.lsnr’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.scan1.vip’ on ‘rac01’

CRS-2677: Stop of ‘ora.scan1.vip’ on ‘rac01’ succeeded

CRS-2672: Attempting to start ‘ora.scan1.vip’ on ‘rac02’

CRS-2676: Start of ‘ora.rac01.vip’ on ‘rac02’ succeeded

CRS-2676: Start of ‘ora.scan1.vip’ on ‘rac02’ succeeded

CRS-2672: Attempting to start ‘ora.LISTENER_SCAN1.lsnr’ on ‘rac02’

CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ‘rac02’ succeeded

CRS-2677: Stop of ‘ora.DATA.dg’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.asm’ on ‘rac01’

CRS-2677: Stop of ‘ora.asm’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.ons’ on ‘rac01’

CRS-2677: Stop of ‘ora.ons’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.net1.network’ on ‘rac01’

CRS-2677: Stop of ‘ora.net1.network’ on ‘rac01’ succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘rac01’ has completed

CRS-2677: Stop of ‘ora.crsd’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.crf’ on ‘rac01’

CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘rac01’

CRS-2673: Attempting to stop ‘ora.evmd’ on ‘rac01’

CRS-2673: Attempting to stop ‘ora.asm’ on ‘rac01’

CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘rac01’

CRS-2677: Stop of ‘ora.evmd’ on ‘rac01’ succeeded

CRS-2677: Stop of ‘ora.crf’ on ‘rac01’ succeeded

CRS-2677: Stop of ‘ora.mdnsd’ on ‘rac01’ succeeded

CRS-2677: Stop of ‘ora.asm’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘rac01’

CRS-2677: Stop of ‘ora.ctssd’ on ‘rac01’ succeeded

CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.cssd’ on ‘rac01’

CRS-2677: Stop of ‘ora.cssd’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘rac01’

CRS-2677: Stop of ‘ora.gipcd’ on ‘rac01’ succeeded

CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘rac01’

CRS-2677: Stop of ‘ora.gpnpd’ on ‘rac01’ succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘rac01’ has completed

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

Successfully unlock /oracle/grid/11.2.0/grid

[Grid Patch]

/oracle/OPatch/opatch napply /oracle/20299017 -local -silent -oh /oracle/grid/11.2.0/grid –invPtrLoc /oracle/grid/11.2.0/grid/oraInst.loc -ocmrf /oracle/OPatch/ocm/bin/ocm.rsp

Oracle Interim Patch Installer version 11.2.0.3.11

Copyright (c) 2015, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/grid/11.2.0/grid

Central Inventory : /oracle/oraInventory

from : /oracle/grid/11.2.0/grid/oraInst.loc

OPatch version : 11.2.0.3.11

OUI version : 11.2.0.3.0

Log file location : /oracle/grid/11.2.0/grid/cfgtoollogs/opatch/opatch2015-07-16_05-46-56AM_1.log

Verifying environment and performing prerequisite checks…

OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16902043 17540582 18031683 18522512 19121548 19769496 20299017

Do you want to proceed? [y|n]

y

Y (auto-answered by -silent)

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = ‘/oracle/grid/11.2.0/grid’)

Is the local system ready for patching? [y|n]

y

Y (auto-answered by -silent)

User Responded with: Y

Backing up files…

Applying sub-patch ‘13343438’ to OH ‘/oracle/grid/11.2.0/grid’

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘13696216’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.sdo.locator, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘13923374’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Patching component oracle.network.rsf, 11.2.0.3.0…

Patching component oracle.network.listener, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘14275605’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0…

Patching component oracle.network.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms.util, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘14727310’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.sdo.locator, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘16056266’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] , [ oracle.ovm, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.network.listener, 11.2.0.3.0…

Patching component oracle.network.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.sdo.locator, 11.2.0.3.0…

Patching component oracle.rdbms.deconfig, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘16619892’ to OH ‘/oracle/grid/11.2.0/grid’

sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.4 ] , [ oracle.xdk, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.xdk.parser.java, 11.2.0.3.0…

Patching component oracle.xdk.rsf, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘16902043’ to OH ‘/oracle/grid/11.2.0/grid’

n is found.

Patching component oracle.ldap.rsf, 11.2.0.3.0…

Patching component oracle.ldap.rsf.ic, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘17540582’ to OH ‘/oracle/grid/11.2.0/grid’

is found.

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.ldap.rsf, 11.2.0.3.0…

Patching component oracle.ordim.client, 11.2.0.3.0…

Patching component oracle.rdbms.util, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Patching component oracle.sdo.locator, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.ordim.jai, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘18031683’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.ldap.rsf, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.rdbms.util, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘18522512’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.network.rsf, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘19121548’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms.rman, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Patching component oracle.ordim.client, 11.2.0.3.0…

Patching component oracle.ordim.jai, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘19769496’ to OH ‘/oracle/grid/11.2.0/grid’

e or a higher version is found.

Patching component oracle.rdbms.util, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0…

Patching component oracle.xdk.parser.java, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.xdk.rsf, 11.2.0.3.0…

Verifying the update…

Applying sub-patch ‘20299017’ to OH ‘/oracle/grid/11.2.0/grid’

ApplySession: Optional component(s) [ oracle.sysman.agent, 10.2.0.4.3 ] , [ oracle.xdk, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.xdk.parser.java, 11.2.0.3.0…

Patching component oracle.xdk.rsf, 11.2.0.3.0…

Patching component oracle.rdbms.rsf, 11.2.0.3.0…

Patching component oracle.rdbms, 11.2.0.3.0…

Verifying the update…

Composite patch 20299017 successfully applied.

Log file location: /oracle/grid/11.2.0/grid/cfgtoollogs/opatch/opatch2015-07-16_05-46-56AM_1.log

OPatch succeeded.

[root@install]# ./rootcrs.pl –patch

Using configuration parameter file: ./crsconfig_params

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

[Database Patch]

/oracle/OPatch/opatch napply /oracle/20299017 -local -silent -oh /oracle/app/product/11.2.0/db -invPtrLoc /oracle/app/product/11.2.0/db/oraInst.loc -ocmrf /oracle/OPatch/ocm/bin/ocm.rsp

3. Patch 설치 확인(oracle user)
$ opatch lsinventory –detail