Sunday, 30 March 2014

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Issue: Error while checking the Conflict of the opatch
[oracle@TEST 17478415]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /data/oracle/db/tech_st/11.2.0
Central Inventory : /data/oracle/db/tech_st/11.2.0/admin/oui/CLONE_test/oraInventory
   from           : /data/oracle/db/tech_st/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.3.0
Log file location : /data/oracle/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2014-03-27_08-27-56AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail"not executed
Unable to create Patch Object.
Exception occured : PatchObject constructor: Input file "/data/oracle/17478415/etc/config/actions" or "/data/oracle/17478415/etc/config/inventory" does not exist.


Solution:
[oracle@TEST 17478415]$ export PATH=$PATH:/usr/ccs/bin
[oracle@TEST1 17478415]$ export PATH=$PATH:/data/oracle/db/tech_st/11.2.0/OPatch
[oracle@TEST 17478415]$ opatch prereq CheckConflictAmongPatchesWithDetail -phBaseDir /data/oracle/17478415
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /data/oracle/db/tech_st/11.2.0
Central Inventory : /data/oracle/db/tech_st/11.2.0/admin/oui/CLONE_test/oraInventory
   from           : /data/oracle/db/tech_st/11.2.0/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.3.0
Log file location : /data/oracle/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2014-03-27_08-34-55AM_1.log
Invoking prereq "checkconflictamongpatcheswithdetail"
Prereq "checkConflictAmongPatchesWithDetail" passed.
OPatch succeeded.

Friday, 28 March 2014

Steps to apply CPUJan2014 patch

Here are the steps to apply CPUJan2014(17478415) patch

1) Set Environment
export PATH=$PATH:/usr/ccs/bin
export PATH=$PATH:/data/oracle/db/tech_st/11.2.0/OPatch
which opatch
/data/oracle/db/tech_st/11.2.0/OPatch

2) Download the CPU patch.Eg.,Download CPUJan2014 patch for 11.2.0.3

3) To apply CPUJan2014, OPatch utility version 11.2.0.1.0 or later to apply this patch. Oracle recommends that you use
the latest released OPatch 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release

4) Shutdown the Application and Database

5) Backup the Database,Oracle Home,Inventory

6) Check Confliction
bash-3.2$ cd 17478415
bash-3.2$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

7) Apply opatch
unzip p17478415_112030_<platform>.zip
cd 17478415
opatch napply -skip_subset -skip_duplicate

6) Post Installation
Loading Modified SQL Files into the Database
conn "/ as sysdba"
@?/rdbms/admin/catbundle.sql cpu apply

The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series CPU.

8) Check the status from registry$history
select action,version,id,comments,bundle_series from registry$history where bundle_series like '%CPU%';

9) Compile Invalid objects by executing “utlrp.sql”

10) Check the following log files in $ORACLE_BASE/cfgtoollogs/catbundle for any errors:
catbundle_CPU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_CPU_<database SID>_GENERATE_<TIMESTAMP>.log

Wednesday, 26 March 2014

Upgrade EBS from 12.1.3 to 12.2.3

To upgrade EBS from 12.1.3 to 12.2.3 on Linux Server, we need to upgrade in two steps.Following are the documents which we should follow:

Step 1 : 
Upgrade from 12.1.3 to 12.2.0 with the following documentation
Note 1330701.1: Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

Oracle E-Business Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 Part No. E48839-02
http://docs.oracle.com/cd/V39571_01/current/acrobat/122upg12.pdf

Note 1349240.1: Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade (Doc ID 1349240.1)


Step 2 : 
Upgrade from 12.2.0 to 12.2.3 which is currently the latest version of E-Business 12.2.x 
Note 1586214.1 Oracle E-Business Suite Release 12.2.3 Readme