[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 o
ORA-01078 ORA-01565 ORA-17503 ORA-15077
最新推荐文章于 2019-10-23 10:45:53 发布
这篇博客介绍了在Oracle数据库启动过程中遇到的错误,包括ORA-01078、ORA-01565、ORA-17503和ORA-15077。博主通过切换到Oracle用户并以sysdba身份登录,然后对ASM磁盘组进行挂载操作,最终成功解决了问题,使得数据库正常启动并运行。
摘要由CSDN通过智能技术生成