Friday, July 3, 2009

INTERMITTENT ORA-06502 DURING PEAK LOADING

In 10.2.0.3,

non reproducible ORA-06502 arises from

time to time when the production has the peak loading.


Alter system flush shared pool helps the problem for a while....


Error:

ORA-06502:

numeric or value error: associative array shape is not consistent with

session parameters

(PLS-01910)

numeric or value error: character to number conversion error (PLS-01900)

Solution:

Apply patch 5890966 to resolve the error using opatch utility.


No comments:

Post a Comment