解决ORA-12012、ORA-27369报错：删除一个JOB

最新推荐文章于 2026-01-07 17:44:06 发布

转载最新推荐文章于 2026-01-07 17:44:06 发布 · 631 阅读

本文详细描述了在Oracle数据库环境中，遇到J2任务自动执行失败的问题，并通过查看错误日志、执行SQL查询和删除相关任务，最终解决了任务无法正常运行的问题。

今天搭建DG的时候顺手把参数文件中JOB和RESOURCE MANAGER的参数删了：

prod.resource_manager_plan='FORCE:DEFAULT_MAINTENANCE_PLAN'
*.resource_manager_plan='DEFAULT_MAINTENANCE_PLAN'

点击(此处)折叠或打开

*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
prod.resource_manager_plan='FORCE:DEFAULT_MAINTENANCE_PLAN'
*.resource_manager_plan='DEFAULT_MAINTENANCE_PLAN'
*.undo_management='auto'
*.undo_tablespace='UNDOTBS1'

DG搭建没问题，ALERT报错如下：

点击(此处)折叠或打开

Sat Dec 05 11:29:41 2015
Archived Log entry 67 added for thread 1 sequence 15 ID 0x121ed0d0 dest 1:
LNS: Standby redo logfile selected for thread 1 sequence 16 for destination LOG_ARCHIVE_DEST_2
Sat Dec 05 12:15:08 2015
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_18735.trc:
ORA-12012: error on auto execute of job "SYS"."J2"
ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
Sat Dec 05 13:15:09 2015
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_22202.trc:
ORA-12012: error on auto execute of job "SYS"."J2"
ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
Sat Dec 05 14:15:08 2015
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_25650.trc:
ORA-12012: error on auto execute of job "SYS"."J2"
ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory

很明显是J2不能正常运行了，当然惯例还是要看下报错信息：

点击(此处)折叠或打开

[oracle@oracle151 bak]$ oerr ora 12012
12012, 00000, "error on auto execute of job %s"
// *Cause: An error was caught while doing an automatic execution of a job.
// *Action: Look at the accompanying errors for details on why the execute
// failed.
[oracle@oracle151 bak]$ oerr ora 27369
27369, 00000, "job of type EXECUTABLE failed with exit code: %s"
// *Cause: A problem was encountered while running a job of type EXECUTABLE.
// The cause of the actual problem is identified by the exit code.
// *Action: Correct the cause of the exit code and reschedule the job.

找到罪魁祸首：

点击(此处)折叠或打开

SQL> select OWNER,JOB_NAME from DBA_SCHEDULER_JOBS where JOB_NAME like '%J2';
OWNER JOB_NAME
------------------------------ ------------------------------
SYS J2
SQL> exec DBMS_SCHEDULER.DROP_JOB ('J2');
PL/SQL procedure successfully completed.
SQL> select OWNER,JOB_NAME from DBA_SCHEDULER_JOBS where JOB_NAME like '%J2';
no rows selected

   再看alert，错误没有了。

   参考官方文档：
   Oracle Database PL/SQL Packages and Types Reference 11g Release 2 (11.2)
   128 DBMS_SCHEDULER
   官方文档链接：
   http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#CIHHBGGI

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29781254/viewspace-1853999/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29781254/viewspace-1853999/