Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Addition of disks to disk group DATAFRA failed

user8323990May 8 2014 — edited May 12 2014

Hi,

We have two node rac configured in AIX 6.1 and 11g R2 .


While i try to add a new ASM disk i got following errors.

ORA-15032: not all alterations performed

ORA-15075: disk(s) are not visible cluster-wide


node 1:

=====

$ ls -l /dev/ASM_FRA_Disk13

crw-rw----    1 grid     dba          25, 15 May 07 18:01 /dev/ASM_FRA_Disk13

$ ls -l /dev/rhdisk16

crw-------    1 root     system       25, 16 May 07 18:02 /dev/rhdisk16


$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu May 8 12:57:58 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select path from v$asm_disk;

PATH

--------------------------------------------------------------------------------

/dev/ASM_FRA_Disk13  <------- visible in node 1

/dev/ASM_DATA_Disk1

/dev/ASM_DATA_Disk2

/dev/ASM_FRA_Disk3

/dev/ASM_FRA_Disk4

/dev/ASM_OCRVOT_disk10

/dev/ASM_OCRVOT_disk11

/dev/ASM_OCRVOT_disk7

/dev/ASM_OCRVOT_disk8

/dev/ASM_OCRVOT_disk9

/dev/ASM_REDO_Disk5

/dev/ASM_REDO_Disk6

/dev/ASM_DATA_Disk12

13 rows selected.

node 2

=====

$ ls -l /dev/ASM_FRA_Disk13

crw-rw----    1 grid     dba          25, 15 May 08 12:01 /dev/ASM_FRA_Disk13

$ ls -l /dev/rhdisk16

crwxrwxrwx    1 root     system       25, 16 May 07 18:03 /dev/rhdisk16

$ sqlplus / as sysdba

SQL> select path from v$asm_disk;

PATH

--------------------------------------------------------------------------------

/dev/ASM_DATA_Disk1

/dev/ASM_DATA_Disk2

/dev/ASM_FRA_Disk3

/dev/ASM_FRA_Disk4

/dev/ASM_OCRVOT_disk10

/dev/ASM_OCRVOT_disk11

/dev/ASM_OCRVOT_disk7

/dev/ASM_OCRVOT_disk8

/dev/ASM_OCRVOT_disk9

/dev/ASM_REDO_Disk5

/dev/ASM_REDO_Disk6

/dev/ASM_DATA_Disk12

12 rows selected.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2014
Added on May 8 2014
2 comments
1,633 views