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

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

转载于:http://blog.itpub.net/92530/viewspace-511963/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值