topic Re: SMO mount error in oracle using ASM in Data Protection

SMO mount error in oracle using ASM

bjloveunix — Thu, 05 Jun 2025 07:14:35 GMT

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

Re: SMO mount error in oracle using ASM

neto — Thu, 13 May 2010 11:12:39 GMT

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

Re: SMO mount error in oracle using ASM

bjloveunix — Thu, 13 May 2010 13:52:13 GMT

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

Re: SMO mount error in oracle using ASM

neto — Thu, 13 May 2010 14:15:09 GMT

Hi my friend

This is neto from Brazil

How are you?

Worked?

All the best

neto

Re: SMO mount error in oracle using ASM

bjloveunix — Thu, 13 May 2010 14:17:58 GMT

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.?

Re: SMO mount error in oracle using ASM

jessick — Thu, 13 May 2010 14:27:09 GMT

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

Re: SMO mount error in oracle using ASM

bjloveunix — Thu, 13 May 2010 14:34:06 GMT

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

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

Re: SMO mount error in oracle using ASM

neto — Thu, 13 May 2010 14:37:09 GMT

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

Re: SMO mount error in oracle using ASM

bjloveunix — Thu, 13 May 2010 14:42:33 GMT

Hi, neto

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

Re: SMO mount error in oracle using ASM

neto — Thu, 13 May 2010 15:04:09 GMT

Could you please do me a favor

export ORACLE_SID=+ASM

sqlplus / as sysdba

show parameter asm

Re: SMO mount error in oracle using ASM

bjloveunix — Fri, 14 May 2010 01:06:43 GMT

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

Re: SMO mount error in oracle using ASM

neto — Fri, 14 May 2010 01:11:09 GMT

Could you please copy here the exactly error?

Re: SMO mount error in oracle using ASM

bjloveunix — Fri, 14 May 2010 01:16:09 GMT

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

Re: SMO mount error in oracle using ASM

neto — Fri, 14 May 2010 01:20:09 GMT

Could you please collect

Connect to ASM instance

select name, state from v$asm_diskgroup;

select name, path from v$asm_disk;

Re: SMO mount error in oracle using ASM

bjloveunix — Fri, 14 May 2010 01:29:08 GMT

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.

Re: SMO mount error in oracle using ASM

neto — Fri, 14 May 2010 01:37:09 GMT

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

Re: SMO mount error in oracle using ASM

bjloveunix — Fri, 14 May 2010 01:44:28 GMT

[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

Re: SMO mount error in oracle using ASM

neto — Fri, 14 May 2010 01:47:39 GMT

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

Re: SMO mount error in oracle using ASM

bjloveunix — Fri, 14 May 2010 02:27:15 GMT

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

Re: SMO mount error in oracle using ASM

neto — Fri, 14 May 2010 02:33:09 GMT

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