如果自己搞不定可以找诗檀软件专业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