This document will list the possible meta characters for asm_diskstring parameter
Solution
* and [] are the two valid meta characters for asm_diskstring parameter.SQL> alter system set asm_diskstring='/dev/raw/raw*' scope=both;System altered.SQL> select path from v$asm_disk;PATH--------------------------------------------------------------------------------/dev/raw/raw1/dev/raw/raw2/dev/raw/raw3/dev/raw/raw4/dev/raw/raw5/dev/raw/raw11/dev/raw/raw12/dev/raw/raw7/dev/raw/raw8/dev/raw/raw9/dev/raw/raw10/dev/raw/raw612 rows selected.SQL> alter system set asm_diskstring='/dev/raw/raw[1-5]' scope=both;System altered.SQL> select path from v$asm_disk order by 1;PATH--------------------------------------------------------------------------------/dev/raw/raw1/dev/raw/raw2/dev/raw/raw3/dev/raw/raw4/dev/raw/raw5Characters like $ [0-9*] ^ _ etc would either give error, or will be ignored.SQL> alter system set asm_diskstring='/dev/raw/raw$' scope=both;alter system set asm_diskstring='/dev/raw/raw$' scope=both*ERROR at line 1:ORA-02097: parameter cannot be modified because specified value is invalidORA-15031: disk specification '/dev/raw/raw$' matches no disksORA-15056: additional error message
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
转载于:https://www.cnblogs.com/hibernate315/archive/2011/04/25/2399054.html
相关资源:数据结构—成绩单生成器