ORA-01034:ORACLE not available ORA-27101:shared memory realm does not existMicrosoft Windows XP [版本 5.1.2600](C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\z>sqlplusSQL*Plus:Release 11.2.0.1.0 Production on 星期三 8月 18

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/29 09:10:52

ORA-01034:ORACLE not available ORA-27101:shared memory realm does not existMicrosoft Windows XP [版本 5.1.2600](C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\z>sqlplusSQL*Plus:Release 11.2.0.1.0 Production on 星期三 8月 18
ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\z>sqlplus
SQL*Plus:Release 11.2.0.1.0 Production on 星期三 8月 18 00:03:14 2010
Copyright (c) 1982,2010,Oracle.All rights reserved.
请输入用户名:system
输入口令:
ERROR:
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
进程 ID:0
会话 ID:0 序列号:0
请输入用户名:
本来装了ORACLE 后来出来点意外 从新安装了下 就出现了这个问题

ORA-01034:ORACLE not available ORA-27101:shared memory realm does not existMicrosoft Windows XP [版本 5.1.2600](C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\z>sqlplusSQL*Plus:Release 11.2.0.1.0 Production on 星期三 8月 18
To resolve this issue with ORA-27101,you should be sure that ORACLE_HOME and ORACLE_SID are correct,and ORACLE_HOME should not have trailing slash.Here is the MOSC example to accompany ORA-27101
一搬来说,要解决ORA-27101,我的经验是:要保证ORACLE_HOME 和ORACLE_SID是正确的,并且,ORACLE_HOME不能在尾部有斜杠“/”
方法:
ORACLE_HOME斜杠符号问题
$ echo $ORACLE_HOME
$ /app/oracle/817/