OraFAQ Forum: Server Administration » Client Process not killed after database reboot

Home » RDBMS Server » Server Administration » Client Process not killed after database reboot (Oracle 9i. Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Client Process not killed after database reboot [message #298157]

Tue, 05 February 2008 03:14

Zatso
Messages: 4
Registered: February 2008

Junior Member

Hi,

I just don't understand how a process (and in my case many "select" processes on the client side) can still be active and CPU consuming after the Oracle server has been shutdowned and restarted. Only the Oracle server has been restarted, not the server machine.

Thank you for your comments

Report message to a moderator

Re: Client Process not killed after database reboot [message #298163 is a reply to message #298157]

Tue, 05 February 2008 03:34

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post what you did to see what you said you saw.

Regards
Michel

Report message to a moderator

Re: Client Process not killed after database reboot [message #298172 is a reply to message #298163]

Tue, 05 February 2008 04:07

Zatso
Messages: 4
Registered: February 2008

Junior Member

[quote Post what you did to see what you said you saw /quote]
We are using an ERP and every night we shut down the Oracle server (shut down immediate) automatically by a script and make a copy of the datafiles. Then we start the Oracle server. This morning it took ages to save the files and when the server was on at last, we looked at the processes and saw that Oracle processes of the day before (day of connection with TOAD)were still working . We had to kill them manually.
I hope this anwers your question.
Thanks for replying.

Report message to a moderator

Re: Client Process not killed after database reboot [message #298175 is a reply to message #298172]

Tue, 05 February 2008 04:13

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

TOAD is not a reliable product.
Use SQL*Plus.
From what you said, I don't know which process it is, if it is a client process or a server/shadow one.
Shut down can't let processes as it waits for the end of the processes, it is more likely there is a kill (or a bad linux configuration that leads to zombie processes).

Regards
Michel

Report message to a moderator

Re: Client Process not killed after database reboot [message #298181 is a reply to message #298175]

Tue, 05 February 2008 04:24

Zatso
Messages: 4
Registered: February 2008

Junior Member

This is what I wanted to be sure about, that shut down kill all the processes.
They were client processes (as long as Toad can be relied on) and the process scripts were "Select" on a production table.

Report message to a moderator

Re: Client Process not killed after database reboot [message #298188 is a reply to message #298157]

Tue, 05 February 2008 05:04

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

If you happen to shutdown Oracle server for any purpose than always use this opportunity to restart you OS also [applicable to servers having long uptime]. Time induced instability is a common cause for zombie processes & resource exhaustion on almost all major oses.

Regards
Manjit Kumar [mkbhati]

Report message to a moderator

Re: Client Process not killed after database reboot [message #298204 is a reply to message #298188]

Tue, 05 February 2008 05:55

Zatso
Messages: 4
Registered: February 2008

Junior Member

Thank you for this remark.
Regards.

Report message to a moderator

Previous Topic:	csv file to be loaded from FTP
Next Topic:	orastack size in bytes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:49:45 CDT 2024