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.

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

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 

Check whether Patch Applied is CPU or PSU

It all started in January 2005 with Critical Patch Updates (CPU).  Then Patch Set Updates (PSU) were added as cumulative patches that included priority fixes as well as security fixes.  Starting from October 2012 onwards, Critical Patch Update (CPU) patches will now be called Security Patch Update (SPU) patches. The patches will still be released as part of the overall Oracle Critical Patch Update (CPU) Program.

Critical Patch Update (CPU) now refers to the overall release of security fixes each quarter rather than the cumulative database security patch for the quarter.  Think of the CPU as the overarching quarterly release and not as a single patch.

Patch Set Updates (PSU) are the same cumulative patches that include both the security fixes and priority fixes.  The key with PSUs is they are minor version upgrades (e.g., 11.2.0.1.1 to 11.2.0.1.2).  Once a PSU is applied, only PSUs can be applied in future quarters until the database is upgraded to a new base version.

Security Patch Update (SPU) terminology is introduced in the October 2012 Critical Patch Update as the term for the quarterly security patch. SPU patches are the same as previous CPU patches, just a new name.  For the database, SPUs can not be applied once PSUs have been applied until the database is upgraded to a new base version.

Bundle Patches are the quarterly patches for Windows and Exadata which include both the quarterly security patches as well as recommended fixes.

Check whether Patch Applied is CPU or PSU
lsinv -bugs_fixed | grep -i cpu

lsinv -bugs_fixed | grep -i spu

References: New Patch Nomenclature for Oracle Products [ID 1430923.1]

Download Oracle Audit Vault software

The latest Oracle Audit vault available is 12.1.1.3.0. If you want to install the Audit vault only(Not Firewall) then Download the latest 12.1.1.3.0 Audit Vault Server Software only. 

Steps to download the Oracle Audit Vault software:
a)Go to https://edelivery.oracle.com
b)Select Oracle Database and Plarform Linux x86-64
c)Select Oracle Audit Vault and Database Firewall 12.1.1 Media Pack for Linux x86-64 -> 12.1.1.3 ->Part Number B73420-04
d)Oracle Audit Vault and Database Firewall (12.1.1.3.0) -Server ->V43742-01->3.2G

Download only "Oracle Audit Vault and Database Firewall (12.1.1.3.0) - Server" (V43742-01) ISO file which is of 3.2GB and burn the ISO file into DVD.

Screenshots:

Oracle Audit Vault Pre-Install Requirements

Any user can install Oracle Audit Vault. You do not need administrative privileges to complete the installation.Here are the basic Oracle Audit Vault Pre-Install Hardware Requirements:

Hardware:   x86 64-bit Server compatible with Oracle Linux Release5.8 without OS
Memory:     Min 2 GB
Disk Space: Single hard drive 125 GB
Other:    1 NIC for Audit Vault Server

Script to find duplicate datafiles in Oracle

Query to Check duplicate datafiles in Oracle

select substr ( file_name, instr( file_name, '/', -1)) file_name, count(*)
from dba_data_files
group by substr ( file_name,instr( file_name, '/', -1))
having count(*) > 1
/

XDOloader jobs are extremely slow during EBS Upgrade from11i to 12.1.1

When attempting to upgrade from EBS 11i to R12.1.1 on Linux Server the upgrade patch was extremely slow while processing XDOloader jobs and the following error encountered in Alert log file.

WARNING: inbound connection timed out (ORA-3136)

Solution:

To implement the solution, please execute the following steps:

a - Stop upgrade

b - rename /dev/random to /dev/random_org for example

c - Create a link to /dev/urandom called /dev/random

d - Restart the upgrade

After R12 upgrade when we open the URL Login screen is not coming

After EBS 11i to R12 Upgrade when we open the URL login screen is not coming.
It is because we have SSO Implemented on our Prod 11i Application.

 Solution:

Cannot Login: mod_oc4j: Response status=499 and reason=Oracle SSO, but failed to get mod_osso global context. [ID 563940.1]

Issue while opening the form after R12 Installation

After Fresh Installation of Oracle R12 or After Very First Cloning on Linux Server If you face this issue. Check RPM openmotif21-2.1.30-11.EL5.i3861. If could be one of the reason of this issue.

Error in Logfile:

13/06/13 13:22:22.473 formsweb: 10.1.3.4.0 Started

13/06/13 13:24:40.576 formsweb: ListenerServlet init()

13/06/13 13:24:41.683 formsweb: Forms session <1> aborted: runtime process failed during startup with errors /d01/app/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

 13/06/13 13:24:41.684 formsweb: Forms session <1> exception stack trace:

oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process

        at oracle.forms.servlet.RunformProcess.connect(Unknown Source)

        at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)

        at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)

        at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

        at java.lang.Thread.run(Thread.java:619)

Solution: Check RPM openmotif21-2.1.30-11.EL5.i3861

              If missing install it

ASM Background Processes

Like normal database instances ASM instance too have the usual background processes like SMON, PMON, DBWr, CKPT and LGWr. In addition to that the ASM instance also have the following background processes,

RABL - Rebalancer: It opens all the device files as part of disk discovery and coordinates the ARB processes for rebalance activity.

ARBx - Actual Rebalancer: They perform the actual rebalancing activities. The number of ARBx processes depends on the ASM_POWER_LIMIT init parameter.

ASMB - ASM Bridge: This process is used to provide information to and from the Cluster Synchronization Service (CSS) used by ASM to manage the disk resources. Responsible to communicate the database Instance to the ASM Instance, provides the heartbeat to the ASM instance.

ORBn - Rebalance ASM data extent movements. There can be many of this at the same time.

OSMB - (ASM) Any database instance that is using an ASM disk group will contain a background process called OSMB. The OSMB process is responsible for communicating with the ASM instance..Helps to manage the drive storage.