plsql dbms_jobs 自动调度失败

报错信息：  ORA-12011: execution of 1 jobs failed ORA-06512: at "SYS.DBMS_IJOB", line 812 ORA-06512: at line 1

可见，job创建成功了，但执行出错。查询ORA-12011错误的说明如下：

ORA-12011: execution of string jobs failed Cause: An error was caught in dbms_ijob.run from one or more jobs which were due to be run. Action: Look at the alert log for details on which jobs failed and why.   SQL> select value from v$diag_info where name='Diag Trace';
 
VALUE
--------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/ycps/ycps1/trace

上面查找到alert log的路径，日志文件内容如下：

Thu Aug 16 14:30:57 2012
Errors in file /u01/app/oracle/diag/rdbms/ycps/ycps1/trace/ycps1_ora_2622362.trc:
ORA-12012: 自动执行作业 84 出错
ORA-01031: 权限不足
ORA-06512: 在 "YCPS.PRO_CREATE_SEQ", line 15
ORA-06512: 在 line 1

 

转载于:https://www.cnblogs.com/xyg-zyx/p/9082023.html