How to unregister R12 while OID is corrupted

If OID is corrupted and you want to forcefully deregister OID from R12, run the following command.
$FND_TOP/bin/txkrun.pl -script=SetSSOReg -removereferences=yes

libXtst.so.6 cannot open shared object file error during Oracle Installation

The "libXtst.so.6 cannot open shared object file" is quite common if you install any oracle product on 64bit system and misses something in the system

How to change the Oracle EBusiness Suite url

Normally while you install oracle R12 it takes the hostname as url name. So, you can access the oracle apps instance as http://:/OA_HTML/AppsLogin

XML gateway is not working in R12.1.3

We are configuring XML gateway in R12 system.

We have configuged for OTA and trying to ping same server using 
http://:/OA_HTML/US/ECXOTAPing.htm

Oracle Performance Tuning - Storage Tuning Part 2

-->

Oracle Performance Tuning - Storage Tuning Part 1

The process of Elimination of Tablespace Fragmentation

Honeycomb tablespaces are very easy to be fixed using the following command.

Alter tablespace APPS_TS_TX_DATA coalesce;