TypeCodes

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 »