通常这种错误是因为服务器为非正常关闭导致的,解决方法如下:
使用sqlplus连接oracle,提示ORA-01034和ORA-27101,具体内容如下:
ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Process ID: 0 Session ID: 0 Serial number: 0
解决方法是执行以下命令:CMD:
C:\Documents and Settings\Administrator>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 7 17:16:47 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> conn / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 778387456 bytes Fixed Size 1374808 bytes Variable Size 503317928 bytes Database Buffers 268435456 bytes Redo Buffers 5259264 bytes Database mounted. Database opened.