Saturday, September 18, 2010

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