Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
来源:互联网 发布:林黛玉美图 知乎 编辑:程序博客网 时间:2024/05/24 01:48
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RAC_DISK/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/RACDB/spfileRACDB.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
--检查ASM实例运行情况
[oracle@node1 ~]$ srvctl status asm -n node1
ASM instance +ASM1 is running on node node1.
[oracle@node1 ~]$ srvctl status asm -n node2
ASM instance +ASM2 is not running on node node2.
[oracle@node1 ~]$
能看出,在节点2(也就是出问题的节点)上ASM实例并没有启动 ,明显是asm实列没有startup.数据库的spfile又放在asm区,由于asm实列没有起来,导致数据库找不到磁盘组。
[oracle@node2 dbs]$ export ORACLE_SID=+ASM2
[oracle@node2 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 17 08:57:56 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 92274688 bytes
Fixed Size 1217884 bytes
Variable Size 65890980 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
[oracle@node2 dbs]$ export ORACLE_SID=RACDB2
SQL> startup
ORACLE instance started.
Total System Global Area 184549376 bytes
Fixed Size 1218412 bytes
Variable Size 96471188 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/kipos/archive/2009/03/16/3993913.aspx
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决(及ORA-15100和ora-1031)
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
- ORA-01078 ORA-01565 ORA-17503 ORA-15077
- ORA-01078 ORA-01565 ORA-17503 ORA-15056 ORA-17503 ORA-15001 ORA-06512
- ORA-01078、ORA-01565、ORA-17503…
- oracle exp ORA-31600和ORA-00942问题的解决
- 解决oracle ORA-09925问题
- ORA
- ora
- Oracle 数据库登录时出现ORA-12514 、ORA-01034、ORA-27101、ORA-01033 错误的解决
- ORA-01830问题的解决
- ORA-01830问题的解决
- ORA-22866问题的解决
- ORA-27092问题的解决
- ora-04091问题的解决
- ora-27054问题的解决
- ORA-14452问题的解决
- 通信和通讯的区别
- MEX 文件编写基础知识
- 网络七层协议具体是什么?
- 虚拟化方面的技术文章
- 再见了!HON
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
- Linux 磁盘限额
- 命令模式
- 初读《COM技术内幕》有感
- 来到JJ5900595
- linux /dev目录
- linux用户和用户组
- 复选框的全选实现方式
- C++读书笔记之泛型编程&&虚函数表&&volatile