| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle screws up Sun host
Hi Rick,
not Sun specific, but maybe helpful :
HP-UX 64 bit, Oracle 8170 and/or 8172 64 bit, HPUX 11.00 : processes started 'running away' and eating up 100% cpu on one of 4 processors. Kill that process and everything worked fine again, for a bit. Then another, seemingly random, process would hit the 100% and we go back around the loop. Eventually, one of Oracle's own background processes would take the hit and at that point Oracle would have to be shutdown. The solution was to upgrade to 8174 as there was a problem in 64 bit HPUX runing 64 bit Oracle. This solved the problems we were having.
Use of shutdown abort :
Shutdown abort fills the instance there and then. It does not rollback any uncommitted transactions - which shutdown immediate does do - but on the next startup, Oracle detects the abort and carriesd out 'instance recovery' to make sure that all committed transactions have indeed had theire data written to disc. Uncommitted trasactions are effectively ignored. There is no harm in using it - unless you then delete the on-line redologs :o)
Shutdown immediate may appear to hang because any uncommitted transactions have to be rolled back, so if there is one that is hal an hour into it's processing, then that half hour of work needs to be rolled back and could tak another half hour to do so.
Killing the server :
Ok, I've never had to kill the server to fix an Oracle problem. However, I have found that even after a shutdown abort, some oracle processes were still running. Kill -9 sorted them out. Usually, I've found that these can be detected by starting the database to get told that 'oracle is still running, shut it down first'. Shutdown tells me that 'instance is not running' - so I go off looking for any oracle process associuated with that instance, and kill them. Then the startup works fine :o)
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.comReceived on Tue Apr 22 2003 - 08:28:55 CDT
-------------------------------------
 |
 |