ORA-27486: insufficient privilegesDBMS_SCHEDULER
508936Mar 12 2008 — edited Mar 14 2008Hi,
I am importing a dump into 10G database running on RH Linux AS4 machine.
I am getting this error.
IMP-00017: following statement failed with ORACLE error 27486:
"BEGIN "
"dbms_scheduler.create_program('"RUN_LOAN_BALANCES"','STORED_PROCEDURE',"
"'LENDING.Get_Loan_Balances'"
",2, FALSE,"
"'Loan Balances'"
");"
"COMMIT; END;"
IMP-00003: ORACLE error 27486 encountered
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 5
ORA-06512: at "SYS.DBMS_SCHEDULER", line 30
ORA-06512: at line 2
IMP-00091: Above error occurred on the following function and object: CREATE RUN_LOAN_BALANCES. Remaining PL/SQL blocks for this object will be skipped.
IMP-00017: following statement failed with ORACLE error 27486:
"BEGIN "
"dbms_scheduler.create_program('"RUN_DYNAMIC_DATA"','STORED_PROCEDURE',"
"'LENDING.DYNAMIC_DATA_NCM'"
",3, FADBMS_SCHEDULERDBMS_ISCHED LSE,"
"'Dynamic Data Extract'"
");"
"COMMIT; END;"
IMP-00003: ORACLE error 27486 encountered
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 5
ORA-06512: at "SYS.DBMS_SCHEDULER", line 30
ORA-06512: at line 2
IMP-00091: Above error occurred on the following function and object: CREATE RUN_DYNAMIC_DATA. Remaining PL/SQL blocks for this object will be skipped.
IMP-00017: following statement failed with ORACLE error 27486:
"BEGIN "
"dbms_scheduler.create_job('"LOAN_BALANCES_JOB"',"
"program_name=>'"RUN_LOAN_BALANCES"',"
"start_date=>'02-NOV-07 12.00.00.000000 AM +05:30', repeat_interval=> "
"'FREQ=MINUTELY;INTERVAL=1;'"
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
">"
"'Loan Balances Job'"
");"
"dbms_scheduler.enable('"LOAN_BALANCES_JOB"');"
"COMMIT; END;"
IMP-00003: ORACLE error 27486 encountered
ORA-27486: insufficient privilegesDBMS_SCHEDULERORA-06512: at "SYS.DBMS_SCHEDULER"
Please help me to solve this issue.
Regards,
Mat.