General discussion

Locked

HP Unix/Oracle Defunct Processes Hanging

By JeffreyMangan ·
HP Unix/Oracle Defunct Processes Hanging Around
I'm using a warehouse management software on HP11.0 with Oracle 817 I have another program on NT that connects to the HP via RPC connection.When user logs onto the NT client it spawns a process on HP. When they log off NT client the spawned process should die, but sometimes these processes and their Oracle shadow processes hang and create a defunct process. these continue to run and eat CPU. How can I stop these from happening ?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

HP Unix/Oracle Defunct Processes Hanging

by cpfeiffe In reply to HP Unix/Oracle Defunct Pr ...

I'm a Unix admin, but don't know much about Oracle. Anyway, we just had a very similiar problem here. We run HP-UX 11.00 with Oracle 8.1.7 running a data warehouse. We have an Informatica server and Windows clients that connect to Oracle via various methods. Sometimes the user or the server would close a connection, but the process would stay open on the Unix server and consume a nearly a whole CPU by itself. Our Oracle DBA looked into it and apparently there were internal hangs within Oracle that prevented Oracle from sending the kill signal to the OS. He reported this to Oracle and they said there was a patch for it. I don't know what patch he installed, I just know that there is a patch from Oracle for internal hangs with 8.1.7 so you should pursue this with Oracle. Good luck.

Collapse -

HP Unix/Oracle Defunct Processes Hanging

by JeffreyMangan In reply to HP Unix/Oracle Defunct Pr ...

The answer lead me in the right direction. There was an Oracle setting in the sqlnet.ora that fixed the problem. It was a bequeath statement that causes the child process to have a PID of 1 making it susceptable to clean up.

Collapse -

HP Unix/Oracle Defunct Processes Hanging

by JeffreyMangan In reply to HP Unix/Oracle Defunct Pr ...

If a patch or config change would do the trick, can you name the patch or config file ?

Collapse -

HP Unix/Oracle Defunct Processes Hanging

by JeffreyMangan In reply to HP Unix/Oracle Defunct Pr ...

This question was closed by the author

Back to Linux Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums