Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Daemon processes

Re: Daemon processes

From: LeRoy Kemnitz <lkemnitz_at_uwsa.edu>
Date: Fri, 12 May 2006 09:25:19 -0500
Message-ID: <44649ACF.2040605@uwsa.edu>


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
Received on Fri May 12 2006 - 09:25:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US