Re: dbms_scheduler and external job

Goran

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.

Stefan



On Thu, Mar 27, 2008 at 3:05 PM, goran bogdanovic <goran00@xxxxxxxxx> 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:
> /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
>



-- 
=========================

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@xxxxxxxxxxxx
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

Other related posts: