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.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database Down abnormally

Ashish Vijay
Occasional Visitor

Database Down abnormally

Hi
We have two HP databse server with HP-UX 11.11 installed on it. A internal application is running on our department and whole database server is stored on it. Oracle 10g is installed on it.
Veritas cluster solution is installed on it. Sometime Database is down automatically. Wat can be the problem and wat can be solution for it?
2 REPLIES
Steven E. Protter
Exalted Contributor

Re: Database Down abnormally

Shalom,

Check the oracle alert logs for problems. There will be an error message that corresponds with downtime and it can be helpful in finding the problem. Post it here or search http://metalink.oracle.com for the solution.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: Database Down abnormally

hi,

The alert.log should give you the exact times when the database was shutdown. If you find a similarity between the downtime periods then it must be schedule script that is performing the shutdown. Otherwise, an unsual condition is causing the instance to crash.

You will need to also investigate into any system errors as well. Check you /var/adm/syslog/syslog.log


hope this helps too!

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