Oracle 连接到闲置实例返回错误ORA-1034

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com

 

ORA-01034: ORACLE not available

Cause: Oracle was not started up. Possible causes include the following:

– The SGA requires more space than was allocated for it.

– The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.


适用于:

Oracle Database – Enterprise Edition – 版本 11.2.0.4及以上
本文信息适用于任何平台。
-bash-4.1$ sqlplus system@DEP2

SQL*Plus: Release 11.2.0.4.0 Production on Fri May 8 19:05:26 2015

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

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

目标

当连接到宕机的RAC实例,预期有以下信息:

Connected to an idle instance.

解决方案

作为sysdba 登录系统,给出SAP能处理的信息:

-bash-4.1$ sqlplus sys@DEP2 as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri May 8 19:08:58 2015

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

输入密码:
Connected to an idle instance.

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号