Home » Server Options » RAC & Failsafe » ASM & DB Instance failured to start (Oracle 11g, HP-Unix)
ASM & DB Instance failured to start [message #482939] Tue, 16 November 2010 21:43 Go to next message
trantuananh24hg
Messages: 612
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear!

Today, I've got an error:

$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 17 09:45:50 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

idle> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/DOISOAT/spfileDOISOAT.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/DOISOAT/spfileDOISOAT.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
idle> exit
SP2-0042: unknown command "exit" - rest of line ignored.
idle> exit
Disconnected



First time, I tried to recreate spfile from pfile, however, it - the errors continued to occur. And I searched in metalink, so, I've got ID 387217.1. I've been beging followed:

1- Check the REQUIRED_RESOURCES was listed by crs_stat -p command, wasn't it? Then, the REQUIRED_RESOURCES did not contain anything
2- Modify by Metalink comment solution:
srvctl modify instance -d <database name> -i <instance name> -s <ASM instance name>


Everything is done, however, I still did not startup database instance. The above error continued, and I force to stop all by crs_stop -all.

May you help me?

Thank you!
Re: ASM & DB Instance failured to start [message #482944 is a reply to message #482939] Wed, 17 November 2010 00:27 Go to previous message
John Watson
Messages: 4676
Registered: January 2010
Location: Global Village
Senior Member
The message ORA-15077 says that your ASM instance is not running. The clusterware should have started it, but didn't. So you need to look in the logs to find out why it didn't start. It is probably quicker try to start it with SQL*Plus, then you will see the errors.
Previous Topic: Oracle now supports RAC on VMWare
Next Topic: Best practice of 11G release 2 Grid & RAC installation on Solaris 10
Goto Forum:
  


Current Time: Tue Oct 21 06:31:24 CDT 2014

Total time taken to generate the page: 0.08624 seconds