Applying CPU patch (11.2.0.1.1) in 11gr2 step by step (OPatch failed With Error Code 73)
STEPS FOR APPLY PATCHES IN ORACLE 11GR2 (11.2.0.1.0)
STEPS:
1.Database Version
2.OS version
3.Backup
4.Opatch Version
5.Download patch for 11.2.0.1.0 & Latest Optach Utility
6.Sessions Status (How many users connected to the session)
7.Invalid objects
8.Check any Job scheduled or running for the database (Cron Tab)
9.Shutdown the database
10.Shutdown the Listener and agent
11.Check Patch conflicts
12.Apply Opatch
13.Post Installation
14.Check the status from registry$history
Note : Before applying patch, please read “Readme.html” file in patch zip file
1. Database Version
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
[oracle@chromepro ~]$ file /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
[oracle@chromepro ~]$ file /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
[oracle@chromepro ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 6 23:42:43 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
2. OS version
[oracle@chromepro ~]$ uname -a
Linux chromepro 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT 2010 i686 i686 i386 GNU/Linux
[oracle@chromepro ~]$ file /bin/ls
/bin/ls: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, stripped
3. Take the backup of ORACLE HOME & oraInventory
[oracle@chromepro u02]$ tar -cvf /u02/OHOME_CRQ9715.tar $ORACLE_HOME
[oracle@chromepro u02]$ tar -cvf ORAINV_CRQ9715.tar /u01/app/oraInventory/
4. Opatch Version
[oracle@chromepro u02]$ opatch version
Invoking OPatch 11.1.0.6.6
OPatch Version: 11.1.0.6.6
OPatch succeeded.
Note : *We need 11.2.0.0.0 or later version for patch apply. Download the latest OPatch version from My Oracle Support.
*If you get error ( Command not found..), while entering the Opatch Command, then you shoul enter following Command……
[oracle@chromepro u02]$ exportPATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@chromepro u02]$ ls
11.2.0.1.1 11.2.0.1.3 11.2.0.1.6 lost+found OHOME_CRQ9715.tar ORAINV_CRQ9715.tar p6880880_112000_LINUX.zip
[oracle@chromepro u02]$ mv p6880880_112000_LINUX.zip /u01/app/oracle/product/11.2.0/dbhome_1/
[oracle@chromepro dbhome_1]$ mv OPatch OLD_OPatch
[oracle@chromepro dbhome_1]$ unzip p6880880_112000_LINUX.zip
[oracle@chromepro dbhome_1]$ cd OPatch
[oracle@chromepro OPatch]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
5. Download Patch
Now we have to download a CPU patch from my oracle support. You can get Latest CPU and PSU from MOS Doc id : Quick Reference to Patchset Patch Numbers [ID 753736.1]
Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)
6. Session Status
SQL> select count(1) from v$session where username is not null;
COUNT(1)
----------
1
7. Invalid Object
SQL> select OBJECT_NAME, OBJECT_TYPE from dba_objects where status = 'INVALID';
no rows selected
8. Cron Tab
Check any Job Scheduled for the database in OS Level.
[oracle@chromepro 9352237]$ crontab -l 59 23 * * * /home/ chromepro /bin/backup.sh
[oracle@chromepro 9352237]$ crontab -e 59 23 * * * /home/ chromepro /bin/backup.sh
9. Shutdown the database
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
10. Shutdown the Listener and OEM Agent
[oracle@chromepro 9352237]$ ps -ef | grep tns
oracle 6587 1 0 Sep06 ? 00:00:00 /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle 8432 5943 0 00:57 pts/2 00:00:00 grep tns
[oracle@chromepro 9352237]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-SEP-2015 00:58:09
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
[oracle@chromepro 9352237]$ ps -ef | grep tns
oracle 8435 5943 0 00:58 pts/2 00:00:00 grep tns
[oracle@chromepro 9352237]$ ps -ef | grep agent
oracle 5560 5524 0 Sep06 ? 00:00:00 /usr/bin/ssh-agent /bin/sh -c exec -l /bin/bash -c "/usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients"
oracle 8450 5943 0 00:58 pts/2 00:00:00 grep agent
[oracle@chromepro 9352237]$ emctl stop agent
11. Determine whether any currently installed one-off patches conflict with the PSU patch:
[oracle@chromepro 11.2.0.1.1]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 9352237
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-09-07_01-35-52AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
12. Apply the patch
[oracle@chromepro OPatch]$ cd /u02/11.2.0.1.1/
[oracle@chromepro 11.2.0.1.1]$ ls
9352237 p9352237_112010_LINUX.zip
[oracle@chromepro 11.2.0.1.1]$ cd 9352237/
[oracle@chromepro 9352237]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_28_34/apply2015-09-07_01-28-34AM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_28_34/apply2015-09-07_01-28-34AM_1.log
OPatch failed with error code 73
Note : Opatch is failed due to “oracle” is active. So we have to check that any process is related to this binary.
[oracle@chromepro OPatch]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin/
[oracle@chromepro bin]$ ls -lrt oracle
-rwsr-s--x 1 oracle oinstall 173515991 Sep 6 18:43 oracle
[oracle@chromepro bin]$ /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle: 10184e
[oracle@chromepro bin]$ kill -9 10184
Note : We kill that process. Now apply the patch
[oracle@chromepro bin]$ cd /u02/11.2.0.1.1/9352237/
[oracle@chromepro 9352237]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_52_19/apply2015-09-07_01-52-18AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 9352237
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '9352237' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...
Patching component oracle.rdbms, 11.2.0.1.0...
Patching component oracle.oraolap, 11.2.0.1.0...
Patching component oracle.rdbms.deconfig, 11.2.0.1.0...
Patching component oracle.javavm.server, 11.2.0.1.0...
--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Patch Set Update Installation (PSU Deinstallation) **
** is not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this PSU, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************
--------------------------------------------------------------------------------
Patch 9352237 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_52_19/apply2015-09-07_01-52-18AM_1.log
OPatch succeeded.
13. Post Installation
[oracle@chromepro ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/
[oracle@chromepro admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 7 02:34:54 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 456146944 bytes
Fixed Size 1337184 bytes
Variable Size 306186400 bytes
Database Buffers 142606336 bytes
Redo Buffers 6017024 bytes
Database mounted.
Database opened.
SQL> @catbundle.sql psu apply
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
14. Check the Patch is applied or not..
[oracle@chromepro 9352237]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-09-07_02-42-15AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-07_02-42-15AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: chromepro
ARU platform id: 46
ARU platform description:: Linux x86
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 9352237 : applied on Mon Sep 07 01:57:28 IST 2015
Unique Patch ID: 12243774
Created on 24 Mar 2010, 05:22:35 hrs PST8PDT
Bugs fixed:
8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548
8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974
7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983
9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535
8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705
8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784
8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202
8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328
8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358
9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385
8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237
8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736
--------------------------------------------------------------------------------
OPatch succeeded.
SQL> select * from registry$history;
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SER
-------------------- ---------- ---------- ---------- ---------- ------------------------------ ----------
07-SEP-15 02.04.05.2 APPLY SERVER 11.2.0.1 ########## PSU 11.2.0.1.1 PSU 68077 AM
http://somoracle4u.blogspot.com/2015/09/applying-cpu-patch-112011-in-11gr2-step.html
STEPS FOR APPLY PATCHES IN ORACLE 11GR2 (11.2.0.1.0)
STEPS:
1.Database Version
2.OS version
3.Backup
4.Opatch Version
5.Download patch for 11.2.0.1.0 & Latest Optach Utility
6.Sessions Status (How many users connected to the session)
7.Invalid objects
8.Check any Job scheduled or running for the database (Cron Tab)
9.Shutdown the database
10.Shutdown the Listener and agent
11.Check Patch conflicts
12.Apply Opatch
13.Post Installation
14.Check the status from registry$history
Note : Before applying patch, please read “Readme.html” file in patch zip file
1. Database Version
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
[oracle@chromepro ~]$ file /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
[oracle@chromepro ~]$ file /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
[oracle@chromepro ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 6 23:42:43 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
2. OS version
[oracle@chromepro ~]$ uname -a
Linux chromepro 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT 2010 i686 i686 i386 GNU/Linux
[oracle@chromepro ~]$ file /bin/ls
/bin/ls: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, stripped
3. Take the backup of ORACLE HOME & oraInventory
[oracle@chromepro u02]$ tar -cvf /u02/OHOME_CRQ9715.tar $ORACLE_HOME
[oracle@chromepro u02]$ tar -cvf ORAINV_CRQ9715.tar /u01/app/oraInventory/
4. Opatch Version
[oracle@chromepro u02]$ opatch version
Invoking OPatch 11.1.0.6.6
OPatch Version: 11.1.0.6.6
OPatch succeeded.
Note : *We need 11.2.0.0.0 or later version for patch apply. Download the latest OPatch version from My Oracle Support.
*If you get error ( Command not found..), while entering the Opatch Command, then you shoul enter following Command……
[oracle@chromepro u02]$ exportPATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@chromepro u02]$ ls
11.2.0.1.1 11.2.0.1.3 11.2.0.1.6 lost+found OHOME_CRQ9715.tar ORAINV_CRQ9715.tar p6880880_112000_LINUX.zip
[oracle@chromepro u02]$ mv p6880880_112000_LINUX.zip /u01/app/oracle/product/11.2.0/dbhome_1/
[oracle@chromepro dbhome_1]$ mv OPatch OLD_OPatch
[oracle@chromepro dbhome_1]$ unzip p6880880_112000_LINUX.zip
[oracle@chromepro dbhome_1]$ cd OPatch
[oracle@chromepro OPatch]$ opatch version
OPatch Version: 11.2.0.3.12
OPatch succeeded.
5. Download Patch
Now we have to download a CPU patch from my oracle support. You can get Latest CPU and PSU from MOS Doc id : Quick Reference to Patchset Patch Numbers [ID 753736.1]
Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)
6. Session Status
SQL> select count(1) from v$session where username is not null;
COUNT(1)
----------
1
7. Invalid Object
SQL> select OBJECT_NAME, OBJECT_TYPE from dba_objects where status = 'INVALID';
no rows selected
8. Cron Tab
Check any Job Scheduled for the database in OS Level.
[oracle@chromepro 9352237]$ crontab -l 59 23 * * * /home/ chromepro /bin/backup.sh
[oracle@chromepro 9352237]$ crontab -e 59 23 * * * /home/ chromepro /bin/backup.sh
9. Shutdown the database
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
10. Shutdown the Listener and OEM Agent
[oracle@chromepro 9352237]$ ps -ef | grep tns
oracle 6587 1 0 Sep06 ? 00:00:00 /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle 8432 5943 0 00:57 pts/2 00:00:00 grep tns
[oracle@chromepro 9352237]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-SEP-2015 00:58:09
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
[oracle@chromepro 9352237]$ ps -ef | grep tns
oracle 8435 5943 0 00:58 pts/2 00:00:00 grep tns
[oracle@chromepro 9352237]$ ps -ef | grep agent
oracle 5560 5524 0 Sep06 ? 00:00:00 /usr/bin/ssh-agent /bin/sh -c exec -l /bin/bash -c "/usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients"
oracle 8450 5943 0 00:58 pts/2 00:00:00 grep agent
[oracle@chromepro 9352237]$ emctl stop agent
11. Determine whether any currently installed one-off patches conflict with the PSU patch:
[oracle@chromepro 11.2.0.1.1]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 9352237
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-09-07_01-35-52AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
12. Apply the patch
[oracle@chromepro OPatch]$ cd /u02/11.2.0.1.1/
[oracle@chromepro 11.2.0.1.1]$ ls
9352237 p9352237_112010_LINUX.zip
[oracle@chromepro 11.2.0.1.1]$ cd 9352237/
[oracle@chromepro 9352237]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_28_34/apply2015-09-07_01-28-34AM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_28_34/apply2015-09-07_01-28-34AM_1.log
OPatch failed with error code 73
Note : Opatch is failed due to “oracle” is active. So we have to check that any process is related to this binary.
[oracle@chromepro OPatch]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin/
[oracle@chromepro bin]$ ls -lrt oracle
-rwsr-s--x 1 oracle oinstall 173515991 Sep 6 18:43 oracle
[oracle@chromepro bin]$ /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle: 10184e
[oracle@chromepro bin]$ kill -9 10184
Note : We kill that process. Now apply the patch
[oracle@chromepro bin]$ cd /u02/11.2.0.1.1/9352237/
[oracle@chromepro 9352237]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_52_19/apply2015-09-07_01-52-18AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 9352237
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '9352237' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...
Patching component oracle.rdbms, 11.2.0.1.0...
Patching component oracle.oraolap, 11.2.0.1.0...
Patching component oracle.rdbms.deconfig, 11.2.0.1.0...
Patching component oracle.javavm.server, 11.2.0.1.0...
--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Patch Set Update Installation (PSU Deinstallation) **
** is not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this PSU, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************
--------------------------------------------------------------------------------
Patch 9352237 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/9352237_Sep_07_2015_01_52_19/apply2015-09-07_01-52-18AM_1.log
OPatch succeeded.
13. Post Installation
[oracle@chromepro ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/
[oracle@chromepro admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 7 02:34:54 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 456146944 bytes
Fixed Size 1337184 bytes
Variable Size 306186400 bytes
Database Buffers 142606336 bytes
Redo Buffers 6017024 bytes
Database mounted.
Database opened.
SQL> @catbundle.sql psu apply
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
14. Check the Patch is applied or not..
[oracle@chromepro 9352237]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.1.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-09-07_02-42-15AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-07_02-42-15AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: chromepro
ARU platform id: 46
ARU platform description:: Linux x86
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 9352237 : applied on Mon Sep 07 01:57:28 IST 2015
Unique Patch ID: 12243774
Created on 24 Mar 2010, 05:22:35 hrs PST8PDT
Bugs fixed:
8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548
8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974
7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983
9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535
8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705
8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784
8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202
8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328
8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358
9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385
8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237
8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736
--------------------------------------------------------------------------------
OPatch succeeded.
SQL> select * from registry$history;
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SER
-------------------- ---------- ---------- ---------- ---------- ------------------------------ ----------
07-SEP-15 02.04.05.2 APPLY SERVER 11.2.0.1 ########## PSU 11.2.0.1.1 PSU 68077 AM
http://somoracle4u.blogspot.com/2015/09/applying-cpu-patch-112011-in-11gr2-step.html
No comments:
Post a Comment