SMO mount error in oracle using ASM

[bjloveunix]

Hi,everyone,

     I have error in mount a error in oracle using ASM,  how  can i solve this problem?

--[ INFO] SMO-13046: Operation GUID ff8080812890c089012890c08dd20001 starting on Profile PROFILEASM
--[ INFO] SD-00028: Beginning to connect device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f6c5801288f6c5dc20001_0.
--[ INFO] SD-00029: Finished connecting device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f6c5801288f6c5dc20001_0.
--[ INFO] PLAT-00010: Creating mapping from disk "/dev/sdb1" to raw device "/dev/raw/raw10".
--[ INFO] ASM-00500: Changing ASM Disk Group name in header of disk /dev/raw/raw10 from DG1 to DG1_20100513162059538_1.
--[ INFO] ASM-00000: Mounting ASM Disk Group DG1_20100513162059538_1 on host dell67.
--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] FLOW-11010: Operation transitioning to abort due to prior failure.
--[ INFO] SD-00019: Discovering storage resources for all system devices.
--[ INFO] SD-00020: Finished storage discovery for all system devices.
--[ INFO] SD-00034: Beginning to disconnect device(s) [/dev/sdb].
--[ INFO] SD-00035: Finished disconnecting device(s) [/dev/sdb].
--[ WARN] FLOW-11011: Operation aborted
--[ERROR] FLOW-11008: Operation failed: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] SMO-13032: Cannot perform operation: Backup Mount.  Root cause: SMO-11007: Error cloning from snapshot: FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ INFO] SMO-13039: Successfully aborted operation: Backup Mount
--[ERROR] SMO-13048: Backup Mount Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:00:33.300

[neto]

Hi All

This is neto from Brazil

How are you?

IMHO the issue is:

--[ INFO] PLAT-00010: Creating mapping from disk "/dev/sdb1" to raw device "/dev/raw/raw10".

Based on it, you have mounted sdb1 to raw10 and worked.

--[ INFO] ASM-00000: Mounting ASM Disk Group DG1_20100513162059538_1 on host dell67.

--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed

ORA-15024: discovered duplicately numbered ASM disk 0

Seems to me that ASM instance doesn't have configure the ASM disktring and ASM is trying to discover all disks and ASM could be discovering two disks with same id (sdb1 and raw10).

You could try to use the following on ASM configuration: (ASM disk string)

Add:

/dev/raw/, /opt/NetApp/mount/

Please let me know the results

All the best

neto

[bjloveunix]

Thanks  neto

     Before test smo mount  for ASM,I have set ASM configure asm_diskstring='/dev/raw/raw*'

ALTER SYSTEM SET asm_diskstring='/dev/raw/raw*' SCOPE=BOTH

so ASM should not discovery other path, such as /dev/sdb1

--[ INFO] ASM-00500: Changing ASM Disk Group name in header of disk /dev/raw/raw10 from DG1 to DG1_20100513162059538_1.
How smo change the header name disk /dev/raw/raw10 from DG1 to DG1_20100513162059538_1

[neto]

Hi my friend

This is neto from Brazil

How are you?

Worked?

All the best

neto

[bjloveunix]

my os is rhel5.4,and smo's version is 3.0.0 for linux

Automatic Storage Management support library (ASMLib) must be used when using ASM with iSCSI or FCP on Linux.?

[jessick]

And that version of SMO is not supported with RHEL 5U4. You need to be

on either 3.0.2 or, preferred, 3.0.3 and be using SDU 4.1.1.

-Mark

[bjloveunix]

Sorry,my smo's version is 3.0.3, not 3.0.0

Does smo for linus only support asmlib, not support raw device?

[neto]

But what I suggested worked or not? I didn't understand

[bjloveunix]

Hi, neto

I set asm_diskstring  to  /dev/raw/, /opt/NetApp/mount/ ,but  smo mount report  the sam error.

[neto]

Could you please do me a favor

export ORACLE_SID=+ASM

sqlplus / as sysdba

show parameter asm

[bjloveunix]

The asm configure paremater,asm_diskstring has been set to /dev/raw/raw*

SQL>  show parameters asm

asm_diskgroups                       string                 DG1
asm_diskstring                       string                 /dev/raw/raw*
asm_power_limit                      integer                1

[neto]

Could you please copy here the exactly error?

[bjloveunix]

New error information for smo mount:

asm_diskstring has changed to /dev/raw/raw*

--[ INFO] SMO-13046: Operation GUID ff808081289458650128945869dd0001 starting on Profile PROFILEASM
--[ INFO] SD-00028: Beginning to connect device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f688501288f688a0a0001_0.
--[ INFO] SD-00029: Finished connecting device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f688501288f688a0a0001_0.
--[ INFO] PLAT-00010: Creating mapping from disk "/dev/sdd1" to raw device "/dev/raw/raw11".
--[ INFO] ASM-00500: Changing ASM Disk Group name in header of disk /dev/raw/raw11 from DG1 to DG1_20100514090543623_1.
--[ INFO] ASM-00000: Mounting ASM Disk Group DG1_20100514090543623_1 on host dell67.
--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100514090543623_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] FLOW-11010: Operation transitioning to abort due to prior failure.
--[ INFO] SD-00019: Discovering storage resources for all system devices.
--[ INFO] SD-00020: Finished storage discovery for all system devices.
--[ INFO] SD-00034: Beginning to disconnect device(s) [/dev/sdd].
--[ INFO] SD-00035: Finished disconnecting device(s) [/dev/sdd].
--[ WARN] FLOW-11011: Operation aborted
--[ERROR] FLOW-11008: Operation failed: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100514090543623_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] SMO-13032: Cannot perform operation: Backup Mount.  Root cause: SMO-11007: Error cloning from snapshot: FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100514090543623_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ INFO] SMO-13039: Successfully aborted operation: Backup Mount
--[ERROR] SMO-13048: Backup Mount Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:00:23.617

[neto]

Could you please collect

Connect to ASM instance

select name, state from v$asm_diskgroup;

select name, path from v$asm_disk;

[bjloveunix]

SQL> select name, state from v$asm_diskgroup;

DG1
MOUNTED

SQL> SQL> select name, path from v$asm_disk;

/dev/raw/raw8

/dev/raw/raw7

/dev/raw/raw6

/dev/raw/raw3

/dev/raw/raw4

/dev/raw/raw2

/dev/raw/raw10

DG1_0000
/dev/raw/raw1

8 rows selected.

[neto]

Please do me a favor

Disconnect /dev/raw/raw10

Run the same commands again

SQL> select name, state from v$asm_diskgroup;

SQL> SQL> select name, path from v$asm_disk;

Make sure that raw10 is disconnected

raw -qa

Check also if the clone has been disconnected.

Try again, because seems to me that the rename worked (see DG1_0000)

Please run again and collect the SMO diagnostics

[bjloveunix]

[root@dell67 log]# sanlun lun show
controller:             lun-pathname             device filename  adapter  protocol          lun size         lun state
fas3050-31:  /vol/vol4/lun2_20100513162059502_1  /dev/sdb         host20   iSCSI          3g (3221225472)     GOOD
fas3050-31:  /vol/vol2/lun3                      /dev/sdc         host20   iSCSI         50g (53687091200)    GOOD
fas3050-31:  /vol/vol4/lun2                      /dev/sdg         host20   iSCSI          3g (3221225472)     GOOD
fas3050-31:  /vol/vol2/lun6                      /dev/sde         host20   iSCSI          2g (2147483648)     GOOD
fas3050-31:  /vol/vol2/lun7                      /dev/sdf         host20   iSCSI          2g (2147483648)     GOOD

[root@dell67 log]#  snapdrive snap disconnect -lun  fas3050-31:/vol/vol4/lun2_20100513162059502_1
         - LUN fas3050-31:/vol/vol4/lun2_20100513162059502_1 ... deleted
[root@dell67 log]# sanlun lun show
controller:   lun-pathname   device filename  adapter  protocol          lun size         lun state
fas3050-31:  /vol/vol2/lun3  /dev/sdc         host20   iSCSI         50g (53687091200)    GOOD
fas3050-31:  /vol/vol4/lun2  /dev/sdg         host20   iSCSI          3g (3221225472)     GOOD
fas3050-31:  /vol/vol2/lun6  /dev/sde         host20   iSCSI          2g (2147483648)     GOOD
fas3050-31:  /vol/vol2/lun7  /dev/sdf         host20   iSCSI          2g (2147483648)     GOOD
[root@dell67 log]# exit
logout
[root@dell67 dev]# exit
exit
[oracle@dell67 dev]$ exit
exit

SQL> l
  1* select name, path from v$asm_disk
SQL> /

DG1_0000
/dev/raw/raw1

SQL> select name, state from v$asm_diskgroup;

DG1
MOUNTED

[root@dell67 ~]#  snapdrive storage show -dev

Connected LUNs and devices:

device filename        adapter path    size    proto   state   clone      lun path                     backing snapshot
----------------        ------- ----    ----    -----   -----   -----      --------                     ----------------
/dev/sdc                  -     P       50g     iscsi   online  No         fas3050-31:/vol/vol2/lun3          -
/dev/sde                  -     P       2g      iscsi   online  No         fas3050-31:/vol/vol2/lun6          -
/dev/sdf                  -     P       2g      iscsi   online  No         fas3050-31:/vol/vol2/lun7          -
/dev/sdg                  -     P       3g      iscsi   online  No         fas3050-31:/vol/vol4/lun2

[neto]

DG1_0000

/dev/raw/raw1

Did you try to execute manually?

raw /dev/raw/raw1 0 0

You have disconnected the lun, but the raw is there

[bjloveunix]

I have create a snapshot for database orcl,

orcl use asm manage storage.orcl use DG1 for storage datafile, DG1's disk is /dev/raw/rwa1

/dev/raw/raw1 is belongs to product database orcl,and we should  change /dev/raw/raw1's status .

now I want to mount the snapshot, using  smo gui,

smo create device "/dev/sdd1 for the clone_lun,and mapping from disk "/dev/sdd1" to raw device "/dev/raw/raw11".

SMO change ASM Disk Group name in header of disk /dev/raw/raw11 from DG1 to DG1_20100514090543623_1

and mount  ASM Disk Group DG1_20100514090543623_1

ORA-15024: discovered duplicately numbered ASM disk 0

after the failer,smo disconnect device(s) [/dev/sdd]  ,but not delete "/dev/raw/raw11

[neto]

That is the reason that we need that you collect smo diagnostics

If SMO already renamed the diskgroup to DG1_20100514090543623_1 there is no reason to have duplicated id

Please collect the diagnostics for this operation and upload jar file

[bjloveunix]

Hi,neto

   Attach file is diagnostics report .