Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27486: insufficient privilegesDBMS_SCHEDULER

508936Mar 12 2008 — edited Mar 14 2008
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2008
Added on Mar 12 2008
3 comments
12,869 views