Database can' t connect with ASM in 11GR2
Date: Wed, 20 Jan 2010 15:47:31 +0100
Message-ID: <645b2a261001200647n3dfe92a1vf927bb86f3cac3e3_at_mail.gmail.com>
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 deniedAdditional 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-lReceived on Wed Jan 20 2010 - 08:47:31 CST