Re: startup hangs

paar_at_nortel.ca (Augustin Paar) writes:

> on an HP running HP-UX 9.05. At this time I cannot get Oracle back on
> its feet. We had some network problems over the weekend and / got full
> on the server machine, I logged in, found some of the reasns why the
> file system got full, recoverred some space, tried to shut down CMVC and
> then shut down Oracle. Things would not shut down properly, so I used a
> more radical approach (I guess the sledge hammer approach which I will
> never do again ;-). Now every time I try to restart the Oracle server
> the 'startup' command just hangs. then I end up with a process
> oracle<SID> which will not die ntil a reboot, even after running ipcrm

well ... these might be worth trying:

1. check your archive log directory. don't delete anything in here unless you have a backup. if all the online logs are full you need enough space for one log file. don't delete anything without backing it up first
2. have a look at the oracle logfile. default location is $ORACLE_HOME/rdbms/log/alert_XXX.log.
3. did the db go down while some tablespaces where in backup mode? you should get a message that 'datafile x needs recovery', but try a 'startup mount; select * from v$backup;' anyway.
4. before doing anything drastic, it might be a good idea to backup everything you still have.
5. check the os-error-logs for disk drive problems. fsck the oracle file systems. if you can't 'kill -9' a process, it hangs in a device driver (at least on the platforms i am familiar with)
6. do a 'startup nomount' ... is the instance started? you only mentioned one process, maybe you only get this far. try to remember any recent changes in your initSID.ora ...

good luck
juergen Received on Tue Jan 05 1999 - 12:33:12 CST