Tuesday, September 23, 2008

OERR Utility to Diagnosis the Problem

OERR Stands for Oracle Error.It is used to diagnosis the problem

oradev@aplerp4 # cd $ORACLE_HOME/bin
oradev@aplerp4 # oerr ora 00060
00060, 00000, "deadlock detected while waiting for resource"
// *Cause: Transactions deadlocked one another while waiting for resources.
// *Action: Look at the trace file to see the transactions and resources
// involved. Retry if necessary.

oradev@aplerp4 # oerr ora 01555
01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"
// *Cause: rollback records needed by a reader for consistent read are
// overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
// setting. Otherwise, use larger rollback segments

oradev@aplerp4 # oerr ora 1652
01652, 00000, "unable to extend temp segment by %s in tablespace %s"
// *Cause: Failed to allocate an extent for temp segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
// files to the tablespace indicated.
Srinivas Ramineni
Oracle Applications DBA

JSP Pages Hanging in R12 After Removing Cached Class Files in _pages

In Release 12 after Removing the compiled class files from the JSP pages in the directory $COMMON_TOP/_pages and Bounce of Apache server,calling JSP pages results in hanging 'blank' screen.

In Release 11i when performing the same steps new class files are created automatically when the JSP page is called from a browser session and JSP was rendered fine.

In Release 12 it's observed that when calling the JSP no class file is created in the diretciry $COMMON_TOP/_pages

1. Change the value for the main_mode parameter to recompile (instead of justrun)

This can be achieved by doing the following actions
• Use the Context editor to change the value for "s_jsp_main_mode" in the .xml file used by autoconfig and change value from justrun to recompile
• Run Autoconfig to propagate the changes to the configuration files
• Verify that now the $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml has


main_mode
recompile


• Test the scenario failing before.
• See that now a new _.class is created when the JSP page is called.

After A Clone, Blank AppsLogin / AppsLocalLogin Page in R12?

while try to access the Applications we are facing the Blank Apps Login, After Completion of the clone Successfully.

The cause might be explained because if the system was not able to access the classes this may have as root cause jsp / class corruption or wrong $CLASSPATH.

To implement the solution, please execute the following steps:

A. Set the JSP compilation to Automatic using the following steps:
1. Use the vi editor to edit the $CONTEXT_NAME.xml context file and change the value for "s_jsp_main_mode" from "justrun"or “Compile” to "recompile"
Note: Backup the context file before editing it.

2. Run Autoconfig to propagate the changes to the configuration files.

3. Verify that now the
$INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml has


main_mode
recompile


4. Restart the Middle Tier services and access the applications to load JSP's which will cause them to be recompiled on the run.
5. After successfully accessing the applications, use the vi editor to edit the $CONTEXT_NAME.xml and revert the value for "s_jsp_main_mode" to "justrun" in order not to hamper the performance of your system.
6. Run AutoConfig to propagate the changes.

An error occurred while retrieving Oracle Applications Help information

Hi
we have upgraded our financials to Rollup 5 in R12.0.4 Instance.
Recently our Functional Consultant had find out Oracle Applications Help information is not retrieving

Error is appearing like the below mentioned.

404 NOT FOUND

An error occurred while retrieving Oracle Applications Help information

Help target US/AP/@APXINWKB_INVOICES_SUM_FOLDER_WINDOW could not be found.

Solution:

Apply the Financials Rollup 5 Help(p6941569_R12_GENERIC.zip) patch.

while applying the Financials Rollup5 patch,we have ignored to apply that patch.

Srinivas Ramineni.
Oracle Apps DBA

WARNING: "Memory Notification: Library Cache Object Loaded Into SGA"

In one of our Database(10g R2)10.2.0.1, we have found that the WARNING message "Memory Notification: Library Cache Object Loaded Into SGA" is being written continuously in alert log file.

To prevent or avoid these messages being generated, we need to adjust the size of a hidden initialization parameter "_kgl_large_heap_warning_threshold" to a high value or zero.

Note: In 10.2.0.2, the threshold is increased to 50MB.
so this should be a reasonable and recommended value.

To find out a hidden parameter value in the database.

SQL> show parameter _kgl_large_heap_warning_threshold

To change the hidden parameter value.

If you are using spfile, login as sysdba

$sqlplus /nolog
SQL> connect /as sysdba
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;

System altered.

Or if you are using init prameter file

Then, edit the initialization parameter file and add the below line.

_kgl_large_heap_warning_threshold=8388608

Shut down and re-start the database after changes

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP;

SQL> show parameter _kgl_large_heap_warning_threshold

Srinivas Ramineni
Oracle Apps DBA