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

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Thu, 21 Jan 2010 15:28:53 +0000
Message-ID: <5e317f311001210728m46758446t7de3d8451e020943_at_mail.gmail.com>

As ASM is up have you checkd that
'+FRONT_INDEX/fyac/controlfile/current.256.708705589' is there?

Pete

On Wed, Jan 20, 2010 at 2:56 PM, <troach_at_gmail.com> wrote:

> 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
> ------------------------------
> *From: *thierry gascard <tgascard_at_gmail.com>
> *Date: *Wed, 20 Jan 2010 15:47:31 +0100
> *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.
>
>
>
>
>

-- 
Regards

Pete

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

Received on Thu Jan 21 2010 - 09:28:53 CST