dbms_scheduler and external job

From: goran bogdanovic <goran00_at_gmail.com>
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-l
Received on Thu Mar 27 2008 - 09:05:48 CDT

Original text of this message