ITPub博客

首页 > 数据库 > Oracle > 解决ORA-12012、ORA-27369报错:删除一个JOB

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

原创 Oracle 作者:糖糖TJ 时间:2015-12-05 15:01:36 0 删除 编辑
今天搭建DG的时候顺手把参数文件中JOB和RESOURCE MANAGER的参数删了:

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

点击(此处)折叠或打开

  1. *.open_cursors=300
  2. *.processes=150
  3. *.remote_login_passwordfile='EXCLUSIVE'
  4. prod.resource_manager_plan='FORCE:DEFAULT_MAINTENANCE_PLAN'
  5. *.resource_manager_plan='DEFAULT_MAINTENANCE_PLAN'
  6. *.undo_management='auto'
  7. *.undo_tablespace='UNDOTBS1'

DG搭建没问题,ALERT报错如下:

点击(此处)折叠或打开

  1. Sat Dec 05 11:29:41 2015
  2. Archived Log entry 67 added for thread 1 sequence 15 ID 0x121ed0d0 dest 1:
  3. LNS: Standby redo logfile selected for thread 1 sequence 16 for destination LOG_ARCHIVE_DEST_2
  4. Sat Dec 05 12:15:08 2015
  5. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_18735.trc:
  6. ORA-12012: error on auto execute of job "SYS"."J2"
  7. ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
  8. Sat Dec 05 13:15:09 2015
  9. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_22202.trc:
  10. ORA-12012: error on auto execute of job "SYS"."J2"
  11. ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
  12. Sat Dec 05 14:15:08 2015
  13. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_25650.trc:
  14. ORA-12012: error on auto execute of job "SYS"."J2"
  15. ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
   很明显是J2不能正常运行了,当然惯例还是要看下报错信息:

点击(此处)折叠或打开

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

点击(此处)折叠或打开

  1. SQL> select OWNER,JOB_NAME from DBA_SCHEDULER_JOBS where JOB_NAME like '%J2';

  2. OWNER JOB_NAME
  3. ------------------------------ ------------------------------

  4. SYS J2

  5. SQL> exec DBMS_SCHEDULER.DROP_JOB ('J2');


  6. PL/SQL procedure successfully completed.

  7. SQL> select OWNER,JOB_NAME from DBA_SCHEDULER_JOBS where JOB_NAME like '%J2';

  8. 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-08-01

  • 博文量
    27
  • 访问量
    37360