- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Instance Crashed
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 11:03 PM
тАО10-16-2002 11:03 PM
Instance Crashed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 11:11 PM
тАО10-16-2002 11:11 PM
Re: Instance Crashed
The first thing is to check if this instance is still running by running the "ps -edf | grep oradb".
If this instance is still running, first connect to the database and shtudown this instgance with Force option and then startup again. It should be fine. Don't forget to check previously if there is no user managing this instance.
I hope this should help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 11:37 PM
тАО10-16-2002 11:37 PM
Re: Instance Crashed
Parthiban
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2002 12:14 AM
тАО10-17-2002 12:14 AM
Re: Instance Crashed
Seems like the redologs might be the problem.
Do the follwing in svrmgrl:
SVRMGR> connect internal
SVRMGR> startup mount
SVRMGR> recover database until cancel;
SVRMGR> alter database open resetlogs;
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2002 09:39 PM
тАО10-17-2002 09:39 PM
Re: Instance Crashed
Good point - can you recover at all?
You may like to try Andreas' suggestion from SQL*Plus as I gather you're using 9.2 and svrmgrl has been dropped in 9i.
Are you running in archivelog mode? Do you have a backup you can use and then recover to a point in time just before your crash?
Something like:
RECOVER DATABASE UNTIL TIME 18-OCT-2002:15:32:00
cheers.
Barbara
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2002 10:02 PM
тАО10-17-2002 10:02 PM
Re: Instance Crashed
Parthiban
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2002 10:11 PM
тАО10-17-2002 10:11 PM
Re: Instance Crashed
If you have two instances on the same machine this could be a problem.
You can reboot the box to clear all the memory used areas of Oracle and try mounting the instance.
Also check the alert log and post the messages when you do a mount or nomount.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2002 10:14 PM
тАО10-17-2002 10:14 PM
Re: Instance Crashed
LOG_CHECKPOINT_TIMEOUT in your init.ora file of the instance.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2002 10:15 PM
тАО10-17-2002 10:15 PM
Re: Instance Crashed
I also suspect the values for the kernel parameters.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2002 10:19 PM
тАО10-17-2002 10:19 PM