Tuesday, 2 August 2016

How to apply Opatch in Oracle Home in ERP R12

Please follow the below process to apply Opatch on Oracle Home.

[appltrn@trn ~]$ su - root
Password:
[root@trn ~]# su - appltrn
[appltrn@trn ~]$ . /u01/appltrn/TRN/inst/apps/TRN_trn/ora/10.1.3/TRN_trn.env
[appltrn@trn ~]$ echo $ORACLE_HOME
/u01/appltrn/TRN/apps/tech_st/10.1.3
[appltrn@trn ~]$ export PATH=$PATH:$PATH:/u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch
[appltrn@trn ~]$ echo $PATH
/u01/appltrn/TRN/apps/tech_st/10.1.3/bin:/u01/appltrn/TRN/inst/apps/TRN_trn/ora/                                                                                        ltrn/TRN/apps/tech_st/10.1.3/Apache/Apache/bin:/u01/appltrn/TRN/apps/tech_st/10.                                                                                        .1.3/appsutil/jdk/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/jdk/jre/bin:/u01/appl                                                                                        st/apps/TRN_trn/admin/scripts:/u01/appltrn/TRN/apps/tech_st/10.1.3/perl/bin:/u01                                                                                        u01/appltrn/TRN/apps/apps_st/appl/ad/12.0.0/bin:/u01/appltrn/TRN/apps/tech_st/10                                                                                        u01/appltrn/TRN/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/usr/kerberos/bin:/usr/                                                                                        appltrn/TRN/apps/tech_st/10.1.3/appsutil/jdk/bin:/u01/appltrn/TRN/apps/tech_st/1                                                                                        N/inst/apps/TRN_trn/ora/10.1.3/opmn/bin:/u01/appltrn/TRN/inst/apps/TRN_trn/ora/1                                                                                        trn/TRN/apps/tech_st/10.1.3/oui/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch:                                                                                        .3/jdk/jre/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/perl/bin:/usr/bin:/usr/ccs/b                                                                                        _st/10.1.3/perl/bin:/u01/appltrn/TRN/apps/tech_st/10.1.2/bin:/u01/appltrn/TRN/ap                                                                                        ltrn/TRN/apps/tech_st/10.1.3/appsutil/jdk/jre/bin::/u01/appltrn/TRN/apps/tech_st                                                                                        :/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/u01/appltrn/TRN/                                                                                        pltrn/TRN/apps/tech_st/10.1.3/ant/bin:/home/appltrn/bin:/u01/appltrn/TRN/apps/te
[appltrn@trn ~]$ cd /u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch/8411487/




[appltrn@trn 8411487]$ sh /u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch/opatch app                                                                                        ly -invPtrLoc /u01/appltrn/TRN/inst/apps/TRN_trn/admin/oraInst.loc

Oracle Interim Patch Installer version 1.0.0.0.57
Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /u01/appltrn/TRN/apps/tech_st/10.1.3
Oracle Home Inventory : /u01/appltrn/TRN/apps/tech_st/10.1.3/inventory
Central Inventory     : /u01/appltrn/TRN/inst/apps/TRN_trn/admin/oraInventory
   from               : /u01/appltrn/TRN/inst/apps/TRN_trn/admin/oraInst.loc
OUI location          : /u01/appltrn/TRN/apps/tech_st/10.1.3/oui
OUI shared library    : /u01/appltrn/TRN/apps/tech_st/10.1.3/oui/lib/linux/libor                                                                                        aInstaller.so
Java location         : /u01/appltrn/TRN/apps/tech_st/10.1.3/jre/1.4.2/bin/java
Log file location     : /u01/appltrn/TRN/apps/tech_st/10.1.3/.patch_storage/<pat                                                                                        ch ID>/*.log

Creating log file "/u01/appltrn/TRN/apps/tech_st/10.1.3/.patch_storage/8411487/A                                                                                        pply_8411487_08-07-2013_19-31-04.log"

Invoking fuser to check for active processes.

Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the lo                                                                                        cal system only.


Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/appltrn/TRN/apps/tech_st/10.1.3)
Is this system ready for updating?
Please respond Y|N >
Y
Applying patch 8411487...

Patching jar files...



Inventory is good and does not have any dangling patches.


Updating inventory...

Verifying patch...
Backing up comps.xml ...


OPatch succeeded.
[appltrn@trn 8411487]$


Second:-2

[appltrn@trn OPatch]$ cd 8467230/
[appltrn@trn 8467230]$ . /u01/appltrn/TRN/inst/apps/TRN_trn/ora/10.1.3/TRN_trn.env
[appltrn@trn 8467230]$ echo $ORACLE_HOME
/u01/appltrn/TRN/apps/tech_st/10.1.3
[appltrn@trn 8467230]$ export PATH=$PATH:/u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch/
[appltrn@trn 8467230]$ echo $PATH
/u01/appltrn/TRN/apps/tech_st/10.1.3/bin:/u01/appltrn/TRN/inst/apps/TRN_trn/ora/10.1.3/opmn/bin:/u01/appltrn/TRN/inst/apps/TRN_trn/ora/10.1.3/Apache/Apache/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/Apache/Apache/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/oui/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch:/u01/appltrn/TRN/apps/tech_st/10.1.3/appsutil/jdk/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/jdk/jre/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/perl/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/u01/appltrn/TRN/inst/apps/TRN_trn/admin/scripts:/u01/appltrn/TRN/apps/tech_st/10.1.3/perl/bin:/u01/appltrn/TRN/apps/tech_st/10.1.2/bin:/u01/appltrn/TRN/apps/apps_st/appl/fnd/12.0.0/bin:/u01/appltrn/TRN/apps/apps_st/appl/ad/12.0.0/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/appsutil/jdk/jre/bin::/u01/appltrn/TRN/apps/tech_st/10.1.2/bin:/usr/bin:/usr/sbin:/u01/appltrn/TRN/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/u01/appltrn/TRN/apps/tech_st/10.1.2/OPatch:/u01/appltrn/TRN/apps/tech_st/10.1.3/appsutil/jdk/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/ant/bin:/home/appltrn/bin:/u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch/
[appltrn@trn 8467230]$ sh /u01/appltrn/TRN/apps/tech_st/10.1.3/OPatch/opatch apply -invPtrLoc /u01/appltrn/TRN/inst/apps/TRN_trn/admin/oraInst.loc

Oracle Interim Patch Installer version 1.0.0.0.57
Copyright (c) 2007 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /u01/appltrn/TRN/apps/tech_st/10.1.3
Oracle Home Inventory : /u01/appltrn/TRN/apps/tech_st/10.1.3/inventory
Central Inventory     : /u01/appltrn/TRN/inst/apps/TRN_trn/admin/oraInventory
   from               : /u01/appltrn/TRN/inst/apps/TRN_trn/admin/oraInst.loc
OUI location          : /u01/appltrn/TRN/apps/tech_st/10.1.3/oui
OUI shared library    : /u01/appltrn/TRN/apps/tech_st/10.1.3/oui/lib/linux/liboraInstaller.so
Java location         : /u01/appltrn/TRN/apps/tech_st/10.1.3/jre/1.4.2/bin/java
Log file location     : /u01/appltrn/TRN/apps/tech_st/10.1.3/.patch_storage/<patch ID>/*.log

Creating log file "/u01/appltrn/TRN/apps/tech_st/10.1.3/.patch_storage/8467230/Apply_8467230_08-07-2013_19-44-20.log"

Invoking fuser to check for active processes.


Subset patches:  7692665,

The fixes for Patch 7692665,  are included in the patch currently
being installed (8467230).  OPatch will roll back the subset patch(es) and
install the new patch (8467230).


Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/appltrn/TRN/apps/tech_st/10.1.3)
Is this system ready for updating?
Please respond Y|N >
Y
Rolling back patch 7692665...

Creating log file "/u01/appltrn/TRN/apps/tech_st/10.1.3/.patch_storage/7692665/RollBack_7692665_08-07-2013_19-44-27.log"

Rolling back with all-node mode.
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Oracle instances have been shut down, proceeding with auto-rollback.

Removing patch 7692665...

Restoring copied files...


Updating inventory...

Back to applying patch 8467230...

Backing up 2nd copy of comps.xml ...

Applying patch 8467230...

Patching copy files...



Inventory is good and does not have any dangling patches.


Updating inventory...

Verifying patch...
Backing up comps.xml ...


OPatch succeeded.
[appltrn@trn 8467230]$

No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...