IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: July 2008

CM terminated with status 139 (Segmentation fault) – Oracle Apps 11i

2 Comments Posted by on July 30, 2008

Problem Statement: In one of the instance, I faced an issue regarding concurrent manager. None of the concurrent mangers were coming up. When I checked the Internal Monitor (Which is responsible for bring up Internal Manager) it was showing the status deactivated. Click on Internal Monitor in CM Administration Screen -> Process -> Internal Manager [...]

Oracle Applications 11i , , ,

Error Viewing CM log files – “File server could not verify its initialization parameters” – Oracle Apps 11i

Leave a Comment Posted by on July 30, 2008

Some times we face following error while viewing CM log files from Concurrent Manager Administer screen. ‘File server could not verify its initialization parameters’ Cause: The issue is because of the syntax error in listener.ora file on appmgr side. If you check the parameter APPLFSTT in listener.ora on appmgr side (cd $TNS_ADMIN), you will see [...]

Oracle Applications 11i ,

Enabling Forms Tracing – Oracle E-Business Suite R12

1 Comment Posted by on July 29, 2008

Introduction: Some times we need to diagnose the issue or error coming in forms. For such situation we need to get more information about the issue we are facing in forms. One of the best way to get such information is using tracing. Many types of tracing are available in forms. We will discuss couple [...]

Oracle Application R12 , , ,

Tuning JVM in Oracle E-Business Suite

Leave a Comment Posted by on July 24, 2008

Introduction: This post is based on an interesting article that I came across. I have provided the link to those articles in the reference section. Also the main inspiration of this article are the performance issues that I am facing daily in my ST applications. When we talk about JVM which are used for a [...]

Oracle Middleware , ,

Oracle RAC 10g – Cache Fusion

46 Comments Posted by on July 21, 2008

Introduction: This post is about Oracle Cache Fusion technology, which is implemented in Oracle database 10g RAC. We are going to discuss just about cache fusion. You should have the architecture knowledge about RAC. Please check Oracle documentation for understanding Oracle RAC architecture. Also you can visit my previous post about Oracle RAC installation to [...]

Oracle Database 10g , , , , , ,

Database Statistics and CBO

Leave a Comment Posted by on July 16, 2008

Introduction One of the greatest problems with the Oracle Cost-based optimizer was the failure of the Oracle DBA to gather accurate schema statistics. In order for the CBO to make an intelligent decision about the best execution plan for your SQL, it must have information about the table and indexes that participate in the query. [...]

Oracle Database 10g , , ,

Important tables for ADPATCH

3 Comments Posted by on July 1, 2008

Here are some of the important tables used by and updated by ADPATCH utility. AD_APPL_TOPS This table holds the various APPL-TOP’s in the Oracle Applications installation that have ever been patched. AD_APPLIED_PATCHES AD_APPLIED_PATCHES holds information about the “distinct” Oracle Applications patches that have been applied. If 2 patches happen to have the same name but [...]

Oracle Application R12, Oracle Applications 11i , ,

Follow

Get every new post delivered to your Inbox.

Join 130 other followers