Re: Database can' t connect with ASM in 11GR2

From: <troach_at_gmail.com>
Date: Wed, 20 Jan 2010 14:56:05 +0000
Message-ID: 575036828-1263999296-cardhu_decombobulator_blackberry.rim.net-2147028044-_at_bda492.bisx.prod.on.blackberry>

I haven't installed this version yet but I would suspect the storage disks. Are they available? Are the permissions correct etc? Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: thierry gascard <tgascard_at_gmail.com> Date: Wed, 20 Jan 2010 15:47:31
To: <Oracle-L_at_FreeLists.org>
Subject: Database can' t connect with ASM in 11GR2

I try ton install grid infrastructure 11gR2 in 4 nodes with single instance for cold failover.
Oracle Database can't connect to ASM+3 in one node.

export ORACLE_SID=..
SQL> startup pfile=init.ora
ORA-00205: error in identifying control file, check alert log for more info --impossible to read controfile in asm

vi alertSID.log
ASMB started with pid=23, OS id=19002
ORA-00210: cannot open the specified control file ORA-00202: control file:
'+FRONT_INDEX/fyac/controlfile/current.256.708705589' ORA-17503: ksfdopn:2 Failed to open file +FRONT_INDEX/fyac/controlfile/current.256.708705589

ORA-15001: diskgroup "FRONT_INDEX" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied

Additional information: 32768
Additional information: 10

[grid_at_dbfront41 ~] /usr/sbin/oracleasm listdisks -- OK

[grid_at_dbfront41 ~]$ srvctl status asm -n dbfront41
ASM is running on dbfront41

[grid_at_dbfront41 ~]

SQL> select name, STATE
  2 from V$ASM_DISKGROUP;

NAME                           STATE
------------------------------ -----------
YAC_DATA                       MOUNTED
BACKUP_BDD                     MOUNTED
CRS_GRP                        MOUNTED
FRONT_DATA                     MOUNTED
FRONT_INDEX                    MOUNTED
YAC_INDEX                      MOUNTED

Why, i have 'nt this problem in other nodes ?.

Thank you for any help.

Thierry.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 20 2010 - 08:56:05 CST