ASM not starting up after system reboot

nukavarapu

new member
Joined: Aug '08
Posts: 2
offline
Reputation:3

Posted 3 years ago
#

We have a 2 node prototype RAC cluster running on 2 nodes using iscsi and OCFS, ASM. After reboot of the 2 nodes ASM is giving the following error message.

ORA-29760: instance_number parameter not specified

Here is the result of crs_stat -t..

[oracle@satya dbs]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SRV1.cs application ONLINE UNKNOWN usha
ora....cl2.srv application ONLINE UNKNOWN usha
ora.orcl.db application ONLINE UNKNOWN usha
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora...._taf.cs application ONLINE UNKNOWN usha
ora....cl1.srv application ONLINE UNKNOWN satya
ora....cl2.srv application ONLINE UNKNOWN usha
ora....SM1.asm application ONLINE OFFLINE
ora....YA.lsnr application ONLINE ONLINE satya
ora.satya.gsd application ONLINE ONLINE satya
ora.satya.ons application ONLINE ONLINE satya
ora.satya.vip application ONLINE ONLINE satya
ora....SM2.asm application ONLINE OFFLINE
ora....HA.lsnr application OFFLINE OFFLINE
ora.usha.gsd application ONLINE ONLINE usha
ora.usha.ons application ONLINE ONLINE usha
ora.usha.vip application ONLINE ONLINE usha

Can you please advise me,what is missing here.
thanks,
satya
Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 73
offline
Reputation:96

Posted 3 years ago
#
Hi Satya,

Looking at description for error ORA-2970 we see following
```
oerr ora 29760
29760, 00000, "instance_number parameter not specified"
// *Cause: The init.ora file did not contain a value for the instance_number
//         which is required to identify this instance to other instances of
//         the database running on the same cluster
// *Action: Assign a value to the instance_number parameter in the init.ora
//          parameter file
```
So it looks like the instance_number parameter is not specified. Or it could be that instance is not able to access the correct spfile. Is your ASM spfile on OCFS? If yes, can you check if it can access it.

Cheers
Amit

Cheers
Amit
http://askdba.org/weblog/
nukavarapu

new member
Joined: Aug '08
Posts: 2
offline
Reputation:3

Posted 3 years ago
#

Thank You, Amit. I will check back with you after making that change.
Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 73
offline
Reputation:96

Posted 3 years ago
#

Cool!! Do update ASM alert log entry also in case issue does not resolve..
Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 73
offline
Reputation:96

Posted 3 years ago
#

Cool!! Do update ASM alert log entry also in case issue does not resolve..

Topic Closed

This topic has been closed to new replies.

AskDBA.org Forum Forum for Oracle DBA's

Automatic Storage Management

[closed] ASM not starting up after system reboot (4 posts)

About This Topic

Tags

Topic Closed