Error creating ADDM report: ORA-00604: error occurred at recursive SQL level 1 ORA-01426: numeric ov
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