Monday, December 22, 2014

Oracle 10g/11g:Install & deploy interim patch ::19148376 for bug fixes

Oracle 10g/11g:Install & deploy interim patch ::19148376 for bug fixes


Dear User,

In this post, We will apply small sized interim patch for bug fixes that affect the business.
This interim patch specially developed for specific operating system level.
This interim patch doesn't affect any major release or update the software  binaries.
Its developed to fix the particular ORA errors comes in production to affect the problems.

This patch can be deployed easy steps to follow.

Pr-requisites.

1.  PSU Patch 11.2.0.4.0 AIX64(any other OS) Bit database software

2.  Free space of around 20 GB for taking oracle binary Backup and installing Patch sets during patching

3.  Take TAR Backup of the ORACLE_HOME post DATABASE stop

4.  Root, Grid, Oracle OS user password

5.  OPatch utility version 11.2.0.4.0 or later

6.  Hot/Cold backup of database.
 


 1.Check the running database.

[oracle@dbexprt /home/oracle]$ps -ef | grep pmon


oracle  7667950        1   0   Jul 15      -  1:52 asm_pmon_+ASM
oracle  7667950        1   0   Jul 15      -  1:52 asm_pmon_dbexperdb
  oracle 44565652 39716272   0 06:01:08  pts/0  0:00 grep pmon

2.Check Database home for running databases.

cat /etc/oratab.

3.Shutdown the listeners.

ps -ef|grep tns or ps -ef | grep lsn

[oracle@dbexprt /home/oracle]$lsnrctl stop LISTENER

4.Shutdown databases.

Shutdown ASM database (if configured.)

set ORACLE_HOME= /grid11g/11.2.0.4/product/apps/grid

sqlplus  / as sysasm
sql>shutdown

5.Take TAR backup of oracle binaries.

mkdir -p /backup/TAR/oracle_home_122214

cd /backup/TAR/oracle_home_122214
 [oracle@dbexprt /home/oracle]$echo $ORACLE_HOME
/orahome/11.2.0.4/product/11.2.0.4

tar -cvf ./file_name.tar /orahome/11.2.0.4/product/11.2.0.4


6.Check patch history.

 opatch lsinventory

7.Check opatch per-requisite.

Go to patch locaton .

mkdir -p /backup/patch/patch_122214

cd /backup/patch/patch_122214

unzip downloded patch.

change location to  uncompressed patch.

cd /backup/patch/patch_122214/19148376

e.g. opatch prereq CheckConflictAgainstOHWithDetail –phBaseDir (Patch Path)

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/patch/patch_122214/19148376



If any of the patch is conflict with current patch, need to check with MOS team for the same.

Else we can continue for apply the patch.

--Refer readme file from downloaded patch.

8.Apply patch.

[oracle@dbexpert /backup/patch/patch_122214/19148376]$ opatch apply


if this command is not worked then use full opatch location.

[oracle@dbexpert /backup/patch/patch_122214/19148376]$ /orahome/11.2.0.4/product/11.2.0.4/Opatch/opatch apply

Check opatch lsintventory.


9.Post deploy activity.

Start Listeners
Start ASM Database
Start Databases.



******Approx downtime of 2-3 hours****************





1 comment:

  1. After reading this post I got an idea about on this note.Really something grate in this article ,Thanks for sharing this. We are providing ORACLE courses training online. After reading this slightly am changed my way of introduction about my training to people. To know more Visit Us ORACLEOnline Training Course

    ReplyDelete

Dear User,

Thank you very much for your kind response