runaway processes on UNIX
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: runaway processes on UNIX

  1. #1
    Join Date
    Nov 2000
    Posts
    173
    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

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Investigate


    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width