How to apply patch in Oracle Apps R12.2 A step by step guide

From R12.2 onwards oracle has introduced online patching functionality.
Online Patching
Online patching uses the latest feature of the Oracle database 11gR2 which is called “Edition Based

Installation of Oracle Apps R12.2.x Step by Step guide

In this article, installation of R12.2.x has been shown with detail installation screen. This is a single node installation where database and apps will be installed in same server. This installation was done on a linux

Oracle data buffer tuning scripts

Here, I'll discuss two scripts which I use often to check the oracle data buffer performance.

How to analyze v$active_session_history table to find the wait events in oracle

v$active_session_history is a important table to find the wait events inside oracle. In this article we'll show to use this table to find following important information.

How to identify the timing when database parameters exceeding predefined threshold value

The following powerful script can be used to identify the timing when the oracle database is exceeding some

SYSAUX tablespace is growing erratically due to growth of WRI$_OPTSTAT_HISTHEAD_HISTORY table

This is a bug of oracle. If gather schema takes much time it doesn't complete the full operation and  WRI$_OPTSTAT_HISTHEAD_HISTORY keeps up growing. It exhausts the SYSAUX tablespace. Oracle recommends a patch to be applied to resolve the above problem. But, in our case there is some

How to move a table to a tablespace with higher block size

For improving performance we need to move table to a different tablespace with higher block size. Higher blocksize increase the performance of select query tremendously. The following short article shows the process of creating the higher block tablespace and moving the table to it.

How to delete tempfile in temporary tablespace in Oracle database

First identify the temporary tablespace and corresponding datafiles issueing following command.

ORA-27123 error during oracle database start

Issue
While starting the oracle database 10g [10.1.0.5.0], we get the following error.

ORA-27123: unable to attach to shared memory segment

How to delete tempfile in temporary tablespace in Oracle database

First identify the temporary tablespace and corresponding datafiles issuing following command.

How to Disable all scheduled Concurrent Request in R12

The following query will disable all the scheduled concurrent request in Oracle R12.

How to use Logminer to analyze the archive log

Here is a simple example of using logminer to analyze redo or archive logs.

opidcl aborting process unknown ospid (xxxx_xxxxxxx) due to error ORA-28

In oracle database version 11.1.0.7, we have encountered the following error message.
opidcl aborting process unknown ospid (12874_47230856307152) due to error ORA-28

While creating user in Oracle Apps it's showing error that AppsDN password has been expired

The "AppsDN" user is a special administration account which eBiz uses to connect to OID for management and administrative tasks when integrating with OID/SSO. First check whether AppsDN password has been expired. To

A simple example of configuring Logminer to analyze the archive log or redo files

Logminer is a oracle tool to analyze the archive log files or log files in Oracle. In this article I have shown a very simple example how to setup a logminer.

How to use RMAN incremental backup to synchronize out of sync Disaster Recovery [DR] site or Standby Database

In many ways your standby database can become out of sync with primary database. It may happen due to following reasons.

ORA-10173 Dynamic Sampling time out error

In the alert log file, we have encountered the following error.
ORA-10173 Dynamic Sampling time-out error

How to Kill Inactive session in Oracle Database

The following is the process or steps to kill the inactive session in Oracle Apps.

How to create java heap dump for debuging any jvm related issues in Oracle Apps

If you are facing JVM related error in Oracle Apps R12 for identifying exact cause of error, you can generate the JVM Heap dumps for identifying exactly

Step by step guide for creating Disaster Recovery site for Oracle Apps R12

In this article, I tried to explain Disaster Recovery [DR] site creation for R12 in elaborate manner. It's a very much practical hands on article. By, following each steps carefully any one can create a R12 Disaster Recovery site. I tried to avoid theoretical details about Disaster Recovery unless required for practical implementation. Here I have given a real DR site creation process.