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

最新推荐文章于 2024-10-05 15:25:14 发布

tomason

最新推荐文章于 2024-10-05 15:25:14 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle

本文链接：https://blog.csdn.net/eradba/article/details/8964926

这篇博客介绍了在Oracle数据库启动过程中遇到的错误，包括ORA-01078、ORA-01565、ORA-17503和ORA-15077。博主通过切换到Oracle用户并以sysdba身份登录，然后对ASM磁盘组进行挂载操作，最终成功解决了问题，使得数据库正常启动并运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[root@rac10g2 bin]# su - oracle
[oracle@rac10g2 ~]$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 23 13:03:45 2013


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


Connected to an idle instance.


SQL> 
SQL> 
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA1/rac10g/spfilerac10g.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA1/rac10g/spfilerac10g.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL> exit




[oracle@rac10g2 ~]$ export ORACLE_SID=+ASM2  
[oracle@rac10g2 ~]$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 23 13:21:56 2013


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




Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options


SQL> select name,state from