dbms_scheduler and external job
Date: Thu, 27 Mar 2008 15:05:48 +0100
Message-ID: <6d0a3ba80803270705o6f91ad84w2ca2f3538384ea5a@mail.gmail.com>
Hi all,
While working with scheduler and external jobs on 11g (OS: RHEL 4 U6 -
64-bit) I have encountered the error:
SQL> exec DBMS_SCHEDULER.run_job('FTJOB');
BEGIN DBMS_SCHEDULER.run_job('FTJOB'); END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 31854
Session ID: 295 Serial number: 20
- from trace fie:
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xC8]
[PC:0x1218199, Exception [type: SIGSEGV, Address not
mapped to object] [ADDR:0xC8] [PC:0x1218199, jslve_execute0()+3927]
Incident 24154 created, dump file:
/opt/oracle/diag/rdbms/stat/stat/incident/incdir_24154/stat_ora_31652_i24154.trc
ORA-07445: exception encountered: core dump [jslve_execute0()+3927]
[SIGSEGV] [ADDR:0xC8] [PC:0x1218199] [Address not mapped to object] []
ssexhd: crashing the process...
Shadow_Core_Dump = partial
This job calls one bash shell script (which works fine when executed
directly from bash prompt). This kind of scheduler jobs afaik works fine in
10g.
It sounds like a bug to me.
Did anyone else have encountered similar error?
Thanks
goran
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2008 - 09:05:48 CDT