ORA-01078，ORA-01565，ORA-17503，ORA-15077

最新推荐文章于 2019-03-27 13:52:02 发布

ck1694

最新推荐文章于 2019-03-27 13:52:02 发布

阅读量437

点赞数

文章标签：数据库

问题：

启动数据库的时候报错如下：
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-15077: could not locate ASM instance serving a required diskgroup -----------------由该信息我们可以推测，可能是ASM实例有问题了。
SQL> exit
Disconnected

查看一下相关的配置文件和设备文件，将属主设置正确：

修改设备权限：
[root@oraserver ~]# chown oracle:dba -R /dev/oracleasm
[root@oraserver ~]# chown oracle:dba -R /dev/raw

[root@rac1 ~]# vi /etc/udev/permissions.d/50-udev.permissions

# raw devices
ram*:root:disk:0660
#raw/*:root:disk:0660
raw/*:oracle:dba:0660

然后先启动ASM，再启动数据库
[oracle@oraserver ~]$ export ORACLE_SID=+ASM
[oracle@oraserver ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 15 17:31:51 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance. -------------由此看出，ASM实例确实是没启动。
SQL> startup
ASM instance started

Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@oraserver ~]$ export ORACLE_SID=orcl --------------一定不要忘了将环境变量修改回来，改成数据库实例的。
[oracle@oraserver ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 15 17:32:23 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 436207616 bytes
Fixed Size 1219856 bytes
Variable Size 130024176 bytes
Database Buffers 301989888 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>

OK！~~~

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20802110/viewspace-1063183/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20802110/viewspace-1063183/