2014. 2. 27. 01:32 오라클
RAC Database 에 Exadata Bundle Patch (Patch Set 11.2.0.4.3)
흔하지는 않은 경우인데 일반 RAC Database 에 Exadata Bundle Patch 를 적용해 본다. (Exadata 의 DB 를 일반 RAC DB 로 Migration 해야하는 작업 때문에 진행함)
현재 RAC 11.2.0.4 버전이고 bundle patch 가 적용되어 있지 않은 상태이다. 적용시킬 Exadata 패치는 11.2.0.4.3 이다.
(본래 Patchset 2 11.2.0.3.22 BP 테스트 하여야 하나 준비된 시스템이 11.2.0.4 이여서 이대로 진행함)
=> 일단 결론, 비 Exadata DB 에도 Exadata Bundle Patch 적용가능하다.
자세한 사항은 MOS 888828.1 및 Patch화일 내 README 화일 참고
1. CRS 구동중 확인
[root:/root]#ps -ef |grep d.bin
root 2470 1 0 Feb26 ? 00:00:09 /oraclegrid/product/11.2.0.4/bin/ohasd.bin reboot
oracle 3056 1 0 Feb26 ? 00:00:00 /oraclegrid/product/11.2.0.4/bin/mdnsd.bin
oracle 3069 1 0 Feb26 ? 00:00:01 /oraclegrid/product/11.2.0.4/bin/gpnpd.bin
oracle 3081 1 0 Feb26 ? 00:00:07 /oraclegrid/product/11.2.0.4/bin/gipcd.bin
root 3097 1 1 Feb26 ? 00:00:25 /oraclegrid/product/11.2.0.4/bin/osysmond.bin
oracle 3150 1 0 Feb26 ? 00:00:09 /oraclegrid/product/11.2.0.4/bin/ocssd.bin
root 3295 1 0 Feb26 ? 00:00:05 /oraclegrid/product/11.2.0.4/bin/octssd.bin reboot
oracle 3319 1 0 Feb26 ? 00:00:04 /oraclegrid/product/11.2.0.4/bin/evmd.bin
root 4006 1 0 Feb26 ? 00:00:10 /oraclegrid/product/11.2.0.4/bin/crsd.bin reboot
root 9032 6225 0 00:09 pts/1 00:00:00 grep d.bin
2. Patch 화일 압축해제
[root:/oraclegrid]#unzip p17904156_112040_Linux-x86-64.zip
Archive: p17904156_112040_Linux-x86-64.zip
creating: 17904156/
inflating: 17904156/README.txt
creating: 17904156/17839474/
creating: 17904156/17839474/etc/
creating: 17904156/17839474/etc/xml/
inflating: 17904156/17839474/etc/xml/GenericActions.xml
inflating: 17904156/17839474/etc/xml/ShiphomeDirectoryStructure.xml
creating: 17904156/17839474/etc/config/
inflating: 17904156/17839474/etc/config/actions.xml
inflating: 17904156/17839474/etc/config/deploy.xml
inflating: 17904156/17839474/etc/config/inventory.xml
creating: 17904156/17839474/files/
creating: 17904156/17839474/files/bin/
[oracle:/oraclegrid/17904156]#ls -al
total 172
drwxr-xr-x 5 root root 4096 Jan 10 00:20 .
drwxr-xr-x 9 root dba 4096 Feb 27 00:10 ..
drwxr-xr-x 4 root root 4096 Jan 10 00:18 17839474
drwxr-xr-x 5 root root 4096 Jan 10 00:18 17943261
drwxr-xr-x 5 root root 4096 Jan 10 00:20 17984784
-rw-r--r-- 1 root root 645 Jan 10 00:18 bundle.xml
-rw-rw-r-- 1 root root 99200 Feb 21 00:47 README.html
-rw-rw-r-- 1 root root 41943 Feb 21 00:47 README.txt
3. 권한 변경
chown -R oracle:oinstall /oraclegrid/17904156
4. OPatch 충돌 Check
(For Grid Home)
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17943261
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17984784
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17839474
(For Database home)
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17943261
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oraclegrid/17904156/17984784/custom/server/17984784
5. OPatch 여유공간 Check
(For Grid Home)
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17943261
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17984784
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17839474
(For Database home)
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17943261
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /oraclegrid/17904156/17984784/custom/server/17984784
6. 진행시작 (조신하게 기다리도록 한다)
[root:/oraclegrid/17904156]#opatch auto /oraclegrid/17904156
Executing /oraclegrid/product/11.2.0.4/perl/bin/perl /oraclegrid/product/11.2.0.4/OPatch/crs/patch11203.pl -patchdir /oraclegrid -patchn 17904156 -paramfile /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/s_crsconfig_defs
This is the main log file: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_00-17-47.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_00-17-47.report.log
2014-02-27 00:17:47: Starting Clusterware Patch Setup
Using configuration parameter file: /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
patch /oraclegrid/17904156/17943261 apply successful for home /oracle/product/11.2.0.4
patch /oraclegrid/17904156/17984784/custom/server/17984784 apply successful for home /oracle/product/11.2.0.4
patch /oraclegrid/17904156/17839474 apply successful for home /oracle/product/11.2.0.4
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac2'
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oraclegrid/product/11.2.0.4
patch /oraclegrid/17904156/17943261 apply successful for home /oraclegrid/product/11.2.0.4
patch /oraclegrid/17904156/17984784 apply successful for home /oraclegrid/product/11.2.0.4
patch /oraclegrid/17904156/17839474 apply successful for home /oraclegrid/product/11.2.0.4
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
7. 패치 확인
[oracle:/home/oracle]#opatch lsinventory -detail
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0.4
Central Inventory : /oraclegrid/oraInventory
from : /oracle/product/11.2.0.4/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2014-02-27_01-13-08AM_1.log
Lsinventory Output file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/lsinv/lsinventory2014-02-27_01-13-08AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (136):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Database Configuration and Upgrade Assistants 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Database Workspace Manager 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Edition Options 11.2.0.4.0
Enterprise Manager Agent 10.2.0.4.5
Enterprise Manager Agent Core Files 10.2.0.4.5
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager Database Plugin -- Agent Support 11.2.0.4.0
Enterprise Manager Database Plugin -- Repository Support 11.2.0.4.0
Enterprise Manager Grid Control Core Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Enterprise Manager Repository Core Files 10.2.0.4.5
Exadata Storage Server 11.2.0.1.0
Expat libraries 2.0.1.0.1
Generic Connectivity Common Files 11.2.0.4.0
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
JAccelerator (COMPANION) 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle 11g Warehouse Builder Required Files 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Application Express 11.2.0.4.0
Oracle Call Interface (OCI) 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.3.8.1.0
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Data Mining RDBMS Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database Gateway for ODBC 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle Database Vault J2EE Application 11.2.0.4.0
Oracle Database Vault option 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Help For Java 4.2.9.0.0
Oracle Help for the Web 2.0.14.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC Server Support Package 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle Label Security 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Message Gateway Common Files 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Annotator 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Net Services 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle ODBC Driver 11.2.0.4.0
Oracle ODBC Driverfor Instant Client 11.2.0.4.0
Oracle OLAP 11.2.0.4.0
Oracle OLAP API 11.2.0.4.0
Oracle OLAP RDBMS Files 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Partitioning 11.2.0.4.0
Oracle Programmer 11.2.0.4.0
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Real Application Testing 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Spatial 11.2.0.4.0
Oracle SQL Developer 11.2.0.4.0
Oracle Starter Database 11.2.0.4.0
Oracle Text 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle UIX 2.2.24.6.0
Oracle Universal Connection Pool 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Oracle XML Development Kit 11.2.0.4.0
Oracle XML Query 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Common Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
Provisioning Advisor Framework 10.2.0.4.3
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
regexp 2.1.9.0.0
Required Support Files 11.2.0.4.0
Sample Schema Data 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SQLJ Runtime 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
XML Parser for Oracle JVM 11.2.0.4.0
There are 136 products installed in this Oracle Home.
Interim patches (3) :
Patch 17839474 : applied on Thu Feb 27 00:22:02 KST 2014
Unique Patch ID: 17071278
Patch description: "DISKMON PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17839474)"
Created on 22 Dec 2013, 21:51:42 hrs PST8PDT
Bugs fixed:
17839474
Files Touched:
diskmon.bin --> ORACLE_HOME/bin/diskmon.bin
Patch Location in Inventory:
/oracle/product/11.2.0.4/inventory/oneoffs/17839474
Patch Location in Storage area:
/oracle/product/11.2.0.4/.patch_storage/17839474_Dec_22_2013_21_51_42
Patch 17984784 : applied on Thu Feb 27 00:21:41 KST 2014
Unique Patch ID: 17154638
Patch description: "CRS PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17984784)"
Created on 8 Jan 2014, 22:53:15 hrs PST8PDT
Bugs fixed:
16613232, 14525998, 17065496, 17551223, 16346413
Files Touched:
cluvfyrac.sh --> ORACLE_HOME/bin/cluvfyrac.sh
crsdiag.pl --> ORACLE_HOME/bin/crsdiag.pl
gnsd --> ORACLE_HOME/bin/gnsd
lsnodes --> ORACLE_HOME/bin/lsnodes
racgwrap --> ORACLE_HOME/bin/racgwrap
racgwrap.sbs --> ORACLE_HOME/bin/racgwrap.sbs
srvconfig --> ORACLE_HOME/bin/srvconfig
rootofs.sh --> ORACLE_HOME/crs/install/rootofs.sh
s_crsconfig_defs --> ORACLE_HOME/crs/install/s_crsconfig_defs
env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk
crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb
crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb
crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb
crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb
crse.msb --> ORACLE_HOME/crs/mesg/crse.msb
crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb
crsf.msb --> ORACLE_HOME/crs/mesg/crsf.msb
crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb
crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb
crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb
crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb
crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb
crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb
crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb
crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb
crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb
중간 생략
sclcus.msg --> ORACLE_HOME/srvm/mesg/sclcus.msg
sclsus.msg --> ORACLE_HOME/srvm/mesg/sclsus.msg
srvm.jar --> ORACLE_HOME/oui/jlib/srvm.jar
srvmasm.jar --> ORACLE_HOME/oui/jlib/srvmasm.jar
libsrvm11.so --> ORACLE_HOME/oui/lib/linux/libsrvm11.so
ins_srvm.mk --> ORACLE_HOME/srvm/lib/install_srvm
ins_has.mk --> ORACLE_HOME/racg/lib/install
Patch Location in Inventory:
/oracle/product/11.2.0.4/inventory/oneoffs/17984784
Patch Location in Storage area:
/oracle/product/11.2.0.4/.patch_storage/17984784_Jan_8_2014_22_53_15
Patch 17943261 : applied on Thu Feb 27 00:20:05 KST 2014
Unique Patch ID: 17071278
Patch description: "DATABASE PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17943261)"
Created on 1 Jan 2014, 21:20:56 hrs PST8PDT
Sub-patch 17741631; "DATABASE PATCH FOR EXADATA (DEC 2013 - 11.2.0.4.2) : (17741631)"
Sub-patch 17628006; "DATABASE PATCH FOR EXADATA (NOV 2013 - 11.2.0.4.1) : (17628006)"
Bugs fixed:
17288409, 13944971, 16450169, 17265217, 16180763, 16220077, 17465741
17614227, 16069901, 14010183, 16285691, 17726838, 13364795, 17088068
17612828, 17443671, 17080436, 17761775, 16721594, 16043574, 16837842
17446237, 16863422, 17332800, 13609098, 17610798, 17501491, 17239687
17468141, 17752121, 17602269, 16850630, 17346671, 17313525, 14852021
17783588, 17437634, 13866822, 12905058, 17546761
Files Touched:
/lpxm.o --> ORACLE_HOME/lib/libxml11.a
/lpxfsm.o --> ORACLE_HOME/lib/libxml11.a
xsl --> ORACLE_HOME/bin/xsl
xmlcg --> ORACLE_HOME/bin/xmlcg
xvm --> ORACLE_HOME/bin/xvm
ins_emagent.mk --> ORACLE_HOME/sysman/lib/e2eme
lxinst --> ORACLE_HOME/bin/lxinst
sdodbmig.sql --> ORACLE_HOME/md/admin/sdodbmig.sql
catmd10i.sql --> ORACLE_HOME/md/admin/catmd10i.sql
sdopatch.sql --> ORACLE_HOME/md/admin/sdopatch.sql
sdodbmig.sql --> ORACLE_HOME/md/admin/sdodbmig.sql
catmd10i.sql --> ORACLE_HOME/md/admin/catmd10i.sql
/pkv.o --> ORACLE_HOME/lib/libpls11.a
/kopt.o --> ORACLE_HOME/lib/libgeneric11.a
/qcd.o --> ORACLE_HOME/lib/libgeneric11.a
중간 생략
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/irman
libcell11.so --> ORACLE_HOME/lib/libcell11.so
orion.o --> ORACLE_HOME/rdbms/lib/orion.o
spawrio.sql --> ORACLE_HOME/rdbms/admin/spawrio.sql
utlu112i.sql --> ORACLE_HOME/rdbms/admin/utlu112i.sql
utlu112x.sql --> ORACLE_HOME/rdbms/admin/utlu112x.sql
Patch Location in Inventory:
/oracle/product/11.2.0.4/inventory/oneoffs/17943261
/oracle/product/11.2.0.4/inventory/oneoffs/17741631
/oracle/product/11.2.0.4/inventory/oneoffs/17628006
Patch Location in Storage area:
/oracle/product/11.2.0.4/.patch_storage/17943261_Jan_1_2014_21_20_56
Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle:/home/oracle]#crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
[oracle:/home/oracle]#crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[oracle:/home/oracle]#crsctl query crs softwareversion
Oracle Clusterware version on node [rac1] is [11.2.0.4.0]
패치 해봤으니 롤백하자..
[root:/root]#opatch auto /oraclegrid/17904156 -rollback
Executing /oraclegrid/product/11.2.0.4/perl/bin/perl /oraclegrid/product/11.2.0.4/OPatch/crs/patch11203.pl -patchdir /oraclegrid -patchn 17904156 -rollback -paramfile /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
/oraclegrid/product/11.2.0.4/crs/install/s_crsconfig_defs
This is the main log file: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_01-57-19.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oraclegrid/product/11.2.0.4/cfgtoollogs/opatchauto2014-02-27_01-57-19.report.log
2014-02-27 01:57:19: Starting Clusterware Patch Setup
Using configuration parameter file: /oraclegrid/product/11.2.0.4/crs/install/crsconfig_params
patch 17943261 rollback successful for home /oracle/product/11.2.0.4
patch 17984784 rollback successful for home /oracle/product/11.2.0.4
patch 17839474 rollback successful for home /oracle/product/11.2.0.4
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oraclegrid/product/11.2.0.4
patch 17943261 rollback successful for home /oraclegrid/product/11.2.0.4
patch 17984784 rollback successful for home /oraclegrid/product/11.2.0.4
patch 17839474 rollback successful for home /oraclegrid/product/11.2.0.4
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
[oracle:/home/oracle]#opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0.4
Central Inventory : /oraclegrid/oraInventory
from : /oracle/product/11.2.0.4/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2014-02-27_02-16-28AM_1.log
Lsinventory Output file location : /oracle/product/11.2.0.4/cfgtoollogs/opatch/lsinv/lsinventory2014-02-27_02-16-28AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
