ORA-01034和ORA-27101错误解决-优快云博客

本文针对在Windows XP SP3环境下启动Oracle 10g R2时出现的ORA-01034和ORA-27101错误进行了解释与解决。通过设置环境变量oracle_sid为实例名的方式成功解决了“共享内存区域不存在”的问题。

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

环境：WindowsXP SP3 + Oracle 10g R2

cmd

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\zhonglisha>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on 木 2月 23 13:06:22 2012

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

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

　　问题描述
=======

在试图启动数据库的时候,Oracle报告下列错误：

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

　　基本解释

=======

Error: ORA-27101 
Text: shared memory realm does not exist  
-------------------------------------------
Cause: Unable to locate shared memory realm  
Action: Verify that the realm is Accessible

　　问题解决：

========

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\zhonglisha>set oracle_sid= 实例名

转载于:https://www.cnblogs.com/javadu/archive/2012/02/23/2364669.html