ORACLE DATABASE ADMINISTRATION: 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

[oracle@chromepro ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 6 23:42:43 2015

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)

----------

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

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

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

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

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]

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]

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

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

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

ORACLE DATABASE ADMINISTRATION

Monday, 7 September 2015

Applying CPU patch (11.2.0.1.1) in 11gr2 step by step (OPatch failed With Error Code 73)

No comments:

Post a Comment