Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC 11gR1 : ASM doesn't start with ORA-00304

YadorSep 15 2011 — edited Sep 15 2011

Hello,

I install Oracle RAC on 2 nodes. Version 11.1.0.6, patched to 11.1.0.7
Platform is Linux Red Hat Enterprise x86

Cluster installation was OK.
I've installed two Oracle Home, one for ASM, one for DB.

I created two diskgroups in ASM, all is OK.

In my cluster, all seems to be OK:

[oracle@pes-ora-vm1 oracle]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE pes-ora-vm1
ora....M1.lsnr application ONLINE ONLINE pes-ora-vm1
ora....vm1.gsd application ONLINE ONLINE pes-ora-vm1
ora....vm1.ons application ONLINE ONLINE pes-ora-vm1
ora....vm1.vip application ONLINE ONLINE pes-ora-vm1
ora....SM2.asm application ONLINE ONLINE pes-ora-vm2
ora....M2.lsnr application ONLINE ONLINE pes-ora-vm2
ora....vm2.gsd application ONLINE ONLINE pes-ora-vm2
ora....vm2.ons application ONLINE ONLINE pes-ora-vm2
ora....vm2.vip application ONLINE ONLINE pes-ora-vm2

But when I want to connect to my ASM instance to query a view, it says "Connected to an idle instance"

If I try a startup:

SQL> startup
ORA-00304: requested INSTANCE_NUMBER is busy

Here is my init+ASM1.ora

-----
[oracle@pes-ora-vm1 oracle]$ more /orabin/app/oracle/product/11.1.0/asm/dbs/init+ASM1.ora

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Cluster Database
###########################################
cluster_database=true

###########################################
# Miscellaneous
###########################################
diagnostic_dest=/orabin/app/oracle
instance_type=asm
instance_name=+ASM1
###########################################
# Pools
###########################################
large_pool_size=12M

asm_diskgroups='DATA','FRA'

db_unique_name=+ASM

+ASM1.instance_number=1
+ASM2.instance_number=2

-----

Can someone help me ?

Thanks in advance,
Regards.

Yann

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2011

Added on Sep 15 2011

#11g, #asm, #linux, #performance-availability, #rac, #rac-asm-clusterware-installation

12 comments

2,143 views