Re: dbms_scheduler and external job
Date: Sat, 29 Mar 2008 12:48:36 +0100
What's the stack trace from the tracefile ? Looking at the functions that get executed before the crashing function may provide some insight where the problem could be.
On Thu, Mar 27, 2008 at 3:05 PM, goran bogdanovic <goran00_at_gmail.com> wrote:
> 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:
> 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
> It sounds like a bug to me.
> Did anyone else have encountered similar error?
-- ========================= Stefan P Knecht Senior Consultant Infrastructure Managed Services Trivadis AG Europa-Strasse 5 CH-8152 Glattbrugg Phone +41-44-808 70 20 Fax +41-808 70 12 Mobile +41-79-571 36 27 stefan.knecht_at_trivadis.com http://www.trivadis.com OCP 9i/10g SCSA SCNA ========================= -- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 29 2008 - 06:48:36 CDT