解决连接Oracle 11g报ORA-01034和ORA-27101的错误
背景:
使用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
解决方法是执行以下命令:
1、sqlplus /nolog
2、conn / as sysdba
3、startup
C:\Users\Manstro>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
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 3423965184 bytes
Fixed Size 2180544 bytes
Variable Size 2684357184 bytes
Database Buffers 721420288 bytes
Redo Buffers 16007168 bytes
数据库装载完毕。
数据库已经打开。