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?
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.
-- //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
-- //www.freelists.org/webpage/oracle-l
