Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle DB frozen

Oracle DB frozen

Please Help.
When I try to startup my database it is instanced, mounted, but not opened. it freezes during this process.
I have Oracle 8.1.7 on HP-UX 11.0

Please help. This is the second time it happens and last time I just restarted the server and the problem was fixed, today it is not functioning....


Patti Johnson
Respected Contributor

Re: Oracle DB frozen

please post the contents of you alert.log file.
Honored Contributor

Re: Oracle DB frozen

Hi Camacho,

Based on the symptoms you describe here, as well as your previous thread, I believe you have a defective disk drive. Scan syslog and alertlog for clues as to which drive is the culprit.

I hope you have a good backup.


Re: Oracle DB frozen

I am afraid some kind damage may be in my hard drive. could It be possible that some sector of my hard drive can be damaged only and when oracle tries to access that sector the system hangs as in windows happens?


Patrick Wallek
Honored Contributor

Re: Oracle DB frozen

Yes, that is entirely possible.

When oracle starts it tries to open ALL files that are part of the database. If a hard drive is damaged and a file cannot be opened then the DB will not start and will show symptoms exactly like you see.

If you look at your /var/adm/syslog/syslog.log file and your alert log file for the DB then you should have a good idea of the failure point.
Hein van den Heuvel
Honored Contributor

Re: Oracle DB frozen

be sure to check the Oracle Alert Log for details on errors found in a (background) process which could not directly communicated with the command originator.

In turn that Alert.log may point to a .TRC file with details on the problem.

Was the database shut down cleanly or brought down abruptly (system crash, Oracle process failure or 'shutdown abort' request)?
Your database may well be trying to apply redo logs.

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting

Honored Contributor

Re: Oracle DB frozen

hi Camacho,

Unless you post your alert.log, we will not be able to identify the root cause of your problem.

Make sure that there are no errors in your syslog.log or no errors displayed when you run dmesg.

if you need any further assistance, please upload more information from both the files mentioned above.

kind regards
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)

Re: Oracle DB frozen

Thank you very much for your help.

Last Friday I restarted my server and the database started properly. As reccomended previously. I will purchase a new hard disk (As Spex and Patrick suggest). My syslog sent an scsi disconnect message I guess this is the real problem. All your comments have been useful enough to give me a better undestanding on this.

Thank everyone