ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT"
Hi
Windows Edition : 2008 enterprise 64bit
Oracle version : 11.1.0.7
Problem Description :-
I am taking export backup at night whenever i review the log file i get the following error end of the export
=================================
exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2026
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 52
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_JOB_EXPORT.grant_exp for object 29287
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2026
ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 52
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_JOB_EXPORT.grant_exp for object 29288
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.
====================================
I have searched from the net as well the forum here and i got the following steps to do
Rerun the %oracle_home%\rdbms\admin*\CATRM.SQL* script connected
as SYS.
EXPLENATION
------------------
If CATEXP.SQL was rerun after CATPROC.SQL (this runs CATRM.SQL) the
modification made to the EXP_FULL_DATABASE role by CATRM.SQL no longer exist
since CATEXP.SQL drops and creates the EXP_FULL_DATABASE role.
The privileges granted to the role by CATRM.SQL are necessary to export the
resource manager objects.
Whenever i run the above script and do export its goes smoothly but after 2 days again same error will come i was running the script for the past 2 weeks now every 3 days but still the error will come again
any idea on how to fix this issue ??
appreciate your help
thanks in advance