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

  • From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 Jan 2010 15:28:53 +0000

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@xxxxxxxxx> 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@xxxxxxxxx>
> *Date: *Wed, 20 Jan 2010 15:47:31 +0100
> *To: *<Oracle-L@xxxxxxxxxxxxx>
> *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@dbfront41 ~]  /usr/sbin/oracleasm listdisks -- OK
>
> [grid@dbfront41 ~]$ srvctl status asm -n dbfront41
> ASM is running on dbfront41
>
> [grid@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

Other related posts: