ITPub博客

首页 > Linux操作系统 > Linux操作系统 > About ORA-error stack (12012, 27370, 27300, 27301)

About ORA-error stack (12012, 27370, 27300, 27301)

原创 Linux操作系统 作者:lorikyo 时间:2019-04-25 09:39:05 0 删除 编辑

About ORA-error stack (12012, 27370, 27300, 27301) 
Checked the alter log found following information:
Errors in file /u01/app/oracle/admin/x5/bdump/x52_j000_15586.trc:
ORA-12012: error on auto execute of job 9937842
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:opening pipe failed with status: 4
ORA-27301: OS failure message: Interrupted system call
ORA-27302: failure occurred at: sjsec 6
Sun Dec 14 22:55:14 2008

SQL> select job_name,additional_info, ACTUAL_START_DATE from DBA_SCHEDULER_JOB_RUN_DETAILS WHERE STATUS='FAILED';

JOB_NAME
-----------------------------------------------------------------
ADDITIONAL_INFO
--------------------------------------------------------------------------------
ACTUAL_START_DATE
---------------------------------------------------------------------------
DELETE_ARCHIVE_LOGS_JOB_RMAN
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:opening pipe failed with status: 4
ORA-27301: OS failure message: Interrupted system call
ORA-27302: failure occurred at: sjsec 6
14-DEC-08 10.54.57.180309 PM -05:00


SQL> select job_name, JOB_ACTION ,number_of_arguments,enabled  from dba_scheduler_jobs where job_name='DELETE_ARCHIVE_LOGS_JOB_RMAN';

JOB_NAME
------------------------------
JOB_ACTION
--------------------------------------------------------------------------------
NUMBER_OF_ARGUMENTS ENABL
------------------- -----
DELETE_ARCHIVE_LOGS_JOB_RMAN
/usr/bin/ksh
                  1 FALSE

SQL>  select job_name ,value,ARGUMENT_POSITION from ALL_SCHEDULER_JOB_ARGS where job_name='DELETE_ARCHIVE_LOGS_JOB_RMAN';

JOB_NAME
------------------------------
VALUE
--------------------------------------------------------------------------------
ARGUMENT_POSITION
-----------------
DELETE_ARCHIVE_LOGS_JOB_RMAN
 export ORACLE_SID=x52 ORAENV_ASK=NO; cd /usr/local/bin; . oraenv;  rman pipe OR
APIPE042C59070002 target / timeout = 120
                1

This issue is a a rman job 'DELETE_ARCHIVE_LOGS_JOB_RMAN' for  delete archive log .
The errors are usually caused by OS system call error or OS configuration issue and are in the form. of:
and  Possible this is  a bug and This issue is fixed in 11.2 (Future Release) , more detail please refer Oracle Note:6651968.8 
(Bug 6651968 - External scheduler jobs can fail ORA-27370 due to EINTR on Unix)
Please check it if there is any question please let me know first!

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

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

注册时间:2004-07-18

  • 博文量
    211
  • 访问量
    158372