使用sqlplus连接Oracle时,报错提示如下图:
ORA-01034 - Oracle not available
ORA-27101 - shared memory realm does not exist
解决方案:
依次执行以下命令:
1、sqlplus /nolog
2、conn / as sysdba
3、startup
C:\Users\Manstro>sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on 星期五 12月 23 14:13:42 Copyright (c) 1982, , Oracle. All rights reserved.SQL> conn / as sysdbaConnected to an idle instance.SQL> startup已连接到空闲例程。SQL> startupORACLE 例程已经启动。Total System Global Area 3423965184 bytesFixed Size 2180544 bytesVariable Size 2684357184 bytesDatabase Buffers 721420288 bytesRedo Buffers 16007168 bytes数据库装载完毕。数据库已经打开。