系统环境：
操作系统： AIX 5.3.8
Oracle： Oracle 10gR2
故障现象：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
[oracle@aix213 ~]$sqlplus /
as
sysdba
SQL*Plus: Release
10.2.
0.1.
0
- Production
on
Thu Jul
24
11
:
28
:
52
2014
Copyright (c)
1982
,
2005
, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release
10.2.
0.1.
0
- 64bit Production
With the Partitioning, OLAP
and
Data Mining options
SQL> create diskgroup datafile
2
normal redundancy
3
failgroup fg1 disk
'/dev/rlv_data1'
4
failgroup fg2 disk
'/dev/rlv_data2'
;
create diskgroup datafile
*
ERROR
at
line
1
:
ORA
-15018
: diskgroup cannot be created
ORA
-15031
: disk specification
'/dev/rlv_data2'
matches no disks
ORA
-15014
: location
'/dev/rlv_data2'
is
not
in
the discovery set
ORA
-15031
: disk specification
'/dev/rlv_data1'
matches no disks
ORA
-15014
: location
'/dev/rlv_data1'
is
not
in
the discovery set
|
查看ASM Instance pfile文件：
[oracle@aix213 dbs]$cat init+ASM.ora
*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/u01/app/oracle/admin/+ASM/udump'
asm_diskstring='/dev/rasm*'
asm_diskgroups='DATAFILE','REDO','ARCH'
错误原因：
asm_diskstring='/dev/rasm*'，此处与'/dev/rlv_data1','/dev/rlv_data2'不匹配
更改成：
asm_diskstring='/dev/r*’后，问题解决！
本文转自 客居天涯 51CTO博客，原文链接：http://blog.51cto.com/tiany/1529579，如需转载请自行联系原作者
![【数据库】解决 oracle: SQL 错误 [900] [42000]: ORA-00900: 无效 SQL 语句](https://ucc.alicdn.com/pic/developer-ecology/f790f8e9ea28458da1cf5cbb69a7d12a.jpg?x-oss-process=image/resize,h_160,m_lfit)
