Re: 100% CPU after thonderstorm ....

Hi,
Its best to go and login on the server itself (not remotely) and use sqldba lmode=y or svrmgrl to connect internal;

Do a select sid, serial#, username, machine, terminal from v$session to get a list of all the users still logged in and take appropriate measures to disconnect them from the database.

Through the power surge, the clients lost power on their machines. As far as the server was concerned there was still users connected to your oracle database. Therefore when all the users logged in again, you would see a dramatic increase on the CPU/DISK etc. resources. Its best to disconnect those users (or even better if you can bring the oracle database down and then bring it backup).

It is not nice to do a kill -9 on the oracle processes.

Hope this was usefull.
vinay joshi
vjoshi_at_pinnacle.co.uk

In article <35988E5D.32B3_at_bluewin.ch>,
  Ruedi.Schwitter_at_bluewin.ch wrote:
>
> Hy there
>
> after a little thonderstorm, all users (ca. 80) have lost the connect to
> the database, the network was fail for a few secondes. But the CPU on
> the server was climbing to 100% and the xload was 40 times higher than
> normal.
>
> We aren't able to made a connect internal to shutdown and start the
> database properly. At least , we must kill all the ora processes by hand
> (kill -9) and start the database again. Luckely, we havent lost any
> data, but now, we want know, who we can preserve a such database state ?
>
> Has anyone an idea ?
>
> ( I was quite new in the oracle buissness ...)
>
> Regards Ruedi :-)
> --
> Ruedi.Schwitter_at_clariden.com
> Claridenstrasse 26
> 8022 Zuerich
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 02 1998 - 09:56:53 CDT