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/