dbms_scheduler and external job
- From: "goran bogdanovic" <goran00@xxxxxxxxx>
- To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 Mar 2008 15:05:48 +0100
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
Other related posts:
