Database Tuning (MOSC)

MOSC Banner

Error creating ADDM report: ORA-00604: error occurred at recursive SQL level 1 ORA-01426: numeric ov

edited May 19, 2010 7:13PM in Database Tuning (MOSC) 2 commentsAnswered
 Hi

Our repository version is 10.2.0.4, the target database version is 10.2.0.2. When trying to create an ADDM report, I got an error: Task TASK_611 has been created, but following error occurs during the execution time : ORA-00604: error occurred at recursive SQL level 1 ORA-01426: numeric overflow ORA-06512: at "SYS.PRVT_ADVISOR", line 1624 ORA-06512: at "SYS.DBMS_ADVISOR", line 186 ORA-06512: at line 1

The target database was recently re-created, it's a two-node RAC on 64-bit Solaris. Before the instances re-creation, there were similar error creating ADDM on one of the instances; after re-creation, both instances have errors creating ADDM reports. Please help.

Thanks

May

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center