ORA-06508 ONT_HEADER_Def_Hdlr

ERROR :
Unable To Open The Sales Order Form ORA-06508 ONT_HEADER_Def_Hdlr in R12.1.1 with 11.1.0.7
Error while opening Sales Order Form


CAUSE :



The issue is caused by the following setup:
Shared pool memory is not big enough . This issue is described in Bug: 4577202


SOLUTION:

To implement the solution, please execute the following steps:

1. Increase the following parameter:
a. shared pool size
b. shared pool reserved size
c. db cache size

Note : You can first increase the shared pool size by
SQL> ALTER SYSTEM SET shared_pool_size =’600M’ SCOPE=BOTH;
SQL> alter system flush shared_pool;
Now retest the issue.
REFERENCE:
Open Sales Order Error ORA-06580 ONT_HEADER_Def_Hdlr Default_Record [ID 838592.1]

 

  • August 31, 2012 | 38 views