ORA-02097/ORA-15014 (ORA-02097: parameter cannot be modified because specified value is invalid)


Wanted to change the asm_diskstring to a new value. Existing diskstring was set to
SQL> show parameter string
NAME TYPE VALUE
————— ———– ————-
asm_diskstring string /dev/rdsk/c*

Issued the SQL
SQL> alter system set asm_diskstring =’/dev/rdsk/tag*’
/
alter system set asm_diskstring =’/dev/rdsk/tag*’
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-15014: path ‘/dev/rdsk/c2t200400A0B81843A2d0s6′ is not in the discovery set

It error out with ORA-02097/ORA-15014. The value specified in the ALTER SYSTEM command was correct. After querying few asm views, found that ASM does not allow changing the asm_diskstring, if the disks (diskgroups) with the existing discovery string are mounted.

SQL> select name, state,total_mb, free_mb from v$asm_diskgroup
/
NAME STATE TOTAL_MB FREE_MB
—— ———– ———- ———-
FRA MOUNTED 481254 207822

So dismounted the diskgroup
SQL> alter diskgroup FRA dismount
/
Diskgroup altered.

SQL> select name, state,total_mb, free_mb from v$asm_diskgroup
/
NAME STATE TOTAL_MB FREE_MB
—— ———– ———- ———-
FRA DISMOUNTED 0 0

Again executed the same command to change the diskstring, which was successful this time.
SQL> alter system set asm_diskstring =’/dev/rdsk/tag*’
/
System altered.

SQL> show parameter string
NAME TYPE VALUE
————— ———– —————
asm_diskstring string /dev/rdsk/tag*

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: