Good point. Although, my main reason for doing this is to execute
scripts on the os from a PowerBuilder app where the os commands are
controlled by events and not able to be scheduled.
M R wrote:
> Otherwise you may use dbms_scheduler.create_job with
> job_type=>'EXECUTABLE'. This could be usefull if you dont need to wait
> for the os command to complete.
>
> Regards,
> Marius
>
> ----- Message d'origine ----
> De : LeRoy Kemnitz <lkemnitz_at_uwsa.edu>
> Cc : oracle-l_at_freelists.org
> Envoyé le : Vendredi, 12 Mai 2006, 4h25mn 19s
> Objet : Re: Daemon processes
>
> Oracle is recommending that I start to use dbms_java package to spawn
> commands to the os. What does everyone else use? Note id - 306106.1
> has examples and tells how to setup. Anyone use this?
>
>
>
> LeRoy Kemnitz wrote:
> > I am running on AIX 5.3 and oracle 10.1.0.4. I have been using
> > dbms_pipe to run our daemon code to spawn off calls to the os from
> > pl/sql for 10 years. Something is now wrong. The daemon starts
> > fine. No errors. Says 'Connected and waiting'. We use it once and
> > it works fine. With the 2nd try, it stops working and throws error -
> > ora-20011 and a -1, and then we kill it and restart it and it works
> > fine for one more time.
> > One thing we noticed is that the os is showing only one daemon
> > process. Top sessions is showing over 25 daemon processes. I kill
> > the os process and the sessions in oracle goes down by one but the
> > rest remain. I would have thought that oracle would remove the
> > sessions if they were dead. What am I missing?
> >
> > I have filed a TAR with oracle but was wondering if anyone else has
> > seen this.
> > L.
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
> --
> LeRoy Kemnitz
> UW System Administration
> Database Administrator
> 780 Regent Street, #246
> Madison, WI 53714
> Phone: (608) 265 -5775
> Fax: (608) 265 - 2090
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
--
LeRoy Kemnitz
UW System Administration
Database Administrator
780 Regent Street, #246
Madison, WI 53714
Phone: (608) 265 -5775
Fax: (608) 265 - 2090
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 12 2006 - 09:40:09 CDT
