解決連線Oracle 11g報ORA-01034和ORA-27101的錯誤

xwdreamer發表於2013-11-07

參考文獻:

http://10000001.blog.51cto.com/4600383/1248367

背景:

使用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

解決方法是執行以下命令:

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.

 此時可能會報出ORA-03113這樣的錯誤,如下所示

SQL> startup
ORACLE instance started.

Total System Global Area 3423965184 bytes
Fixed Size                  2180544 bytes
Variable Size            2550139456 bytes
Database Buffers          855638016 bytes
Redo Buffers               16007168 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 9116
Session ID: 191 Serial number: 3

對於 ORA-03113: end-of-file on communication channel,可以參考另外一篇文章。

相關文章