runaway processes on UNIX

[kburrows]

Hello,

I an running 8.0.5.2.1 on unix aix 4.3.2. I reboot nightly. But everyday there are multiple oracle processes getting created. I am the only one logged onto this server. I am also trying to set up the oem 2.1 on my local nt machine to connect to this server.

Does anyone know whats going on.

Example ps -ef|grep oracle, there are too many to list.

oracle 13678 1 0 07:03:30 - 0:08 oracletst001 (LOCAL=NO)
oracle 13934 1 0 07:03:29 - 0:00 oracletst001 (LOCAL=NO)
oracle 14190 1 1 07:03:31 - 0:16 oracletst001 (LOCAL=NO)
oracle 14448 1 0 07:03:50 - 0:23 oracletst001 (LOCAL=NO)
oracle 14706 1 0 07:03:54 - 0:01 oracletst001 (LOCAL=NO)
oracle 14964 1 4 07:03:55 - 6:48 oracletst001 (LOCAL=NO)
oracle 15222 1 0 07:04:12 - 0:04 oracletst001 (LOCAL=NO)


Thanks

[padmam]

Dear Kburrows, 1st July 2001 14:43 hrs chennai

This 2 links i think would help you to learn why so many process are running.

http://www.dbasupport.com/forums/sho...threadid=10261

http://www.dbasupport.com/forums/sho...threadid=10293

Cheers

Padmam

[kris109]

We had similar problem with one of our products, which runs runform from a shell script on terminals and RF devices. Without giving any company secrets here is the result of our research:

Description

When a user’s session is disconnected, by switching off terminal or RF Hand held unit, an Oracle runaway process is left running. Oracle PMON is not cleaning up the orphan process properly. This is a known Oracle issue manifesting itself on all Unix platforms.

Refer to the following Document ID’s available on Oracle Metalink support site:
DOC ID: 1370.996
1023442.6
141937.999
140785.999
59454.996

System/Business Implications
The runway processes will be using system memory, resulting in degradation of the system ability to support the application’s performance.

Resolution:

To track and terminate any child process created out of a parent shell process, when the parent process is exited abnormaly, add anew line of code as follows to the parent shell process:

#!/bin/ksh –e

This will handle processes identified by a Unix process ID, including Oracle runform sessions.

To handle any other orphan process, a script named proc_cleanup.sh is run as a cron job on 15 minutes intervals.
Sorry, I can not post the script. However you can write similar one yourself.

[Edited by kris109 on 07-02-2001 at 06:37 PM]