Oracle数据库出现ORA-01034、ORA-27101错误解决
最近在虚拟机中操作Oracle数据库SQL语句时，出现了以下两种报错：
1 ORA-27101: shared memory realm does not exist
具体的错误信息如下：
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
2 ORA-01034: ORACLE not available
具体的错误信息如下：
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 27 05:58:45 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> show parameter session
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
3 Oracle报错原因和解决办法
原因：db已经异常关闭！也就是Oracle数据库已经关闭了，那么在执行SQL语句的时候就会报错。
解决办法：重启Oracle。
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 27 06:02:19 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 285215104 bytes
Database Buffers 130023424 bytes
Redo Buffers 6094848 bytes
Database mounted.
Database opened.
打赏支持
Comments »