Re: dbms_scheduler and external job

Hi Stefan,

There is no stack trace...what I have posted in OP that's it...it sound to me we have a bug in 11g ;-)

Regards,
goran

On Sat, Mar 29, 2008 at 1:48 PM, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:

> 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_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:
> > /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_at_trivadis.com
> http://www.trivadis.com
>
> OCP 9i/10g SCSA SCNA
> =========================

--
http://www.freelists.org/webpage/oracle-l