Below is the document containing the most common database waits seen during the day to day activity of an Oracle DBA. It contains the possible causes and different ways to alleviate the wait. Log file location in Oracle application 11i. Below is the ready reckoner for the location of various log files in Oracle apps 11i. This is very much helpful when troubleshooting any issue.

Compute Classic Instance Timezone Change. OAM stops working after SSL. R12 Spam workflow notification emails. R12 eMC vs 11i eMC. 1 - RPM issues with OEL.

This blog is about Oracle Apps DBA activities and Core Oracle DBA activities and Real Application Clusters Administration. It aims to list practical problems which DBA encounters and possible solutions to them. This blog also aims to record good howto articles for quick reference for DBAs. Friday, March 14, 2008. How to find which is the latest patch applied? Dilip Reddy OCP No! I am better than that. Friday, March 7, 2008. On HP unix - uname -r.

What queries are running in the database. Failed to open a sesion for the virtual machine. Installation of Oracle 12c database on Oracle Enterprise Linux 6. Installation of Oracle E-Business R12. 2 on Oracle Enterprise Linux 6. Blog for DBA, RAC, EBS DBA.

Bulk collect comes handy for plsql. Find the current SQL in the database. Important for Windows Oracle Apps customer. How to find blocking session and kill the session from database. R12 - Shortcut to access the forms URL and sysadmin Responsibility page. Applications Short Name for most of the Apps Products. To find the StartCD version - R12. How to find an AD patchset level? ARCHIVE LOG START is DEPRECATED in 11g. On November 27, 2010.

Creating custom top in release12. Opening forms from linux machine. Replacing Jinitiator with JRE for Oracle Apps 11i. Enabling SSL for E-Business suite 11i. Executing gather schema statistics at backend. How to find patchset level.

Challenging the challenges over a decade. Place for Architects, Administrators and Developers. All Scripts at one place. DBAD Tblspc DFile Dtls GBs.

Friday, January 19, 2018. Unix script to extract File Name and Base Path from File Path. Thursday, January 4, 2018. Hi , Some time we may need to process a table of records for which you might need to create a temporary table to process the records. To avoid SQL Table we can use PLSQL table as given below. TYPE t tab IS TABLE OF t record;.

Thursday, November 20, 2014. NetApp Plug-in for Oracle RMAN. Wednesday, September 10, 2014. Restarting the CIFS on the filer did solve the problem for a few minutes, but within half an hour the the problems were back again.