ora-01034 / ORA-27101 错误.

ORA-01034 ORACLE not available
ORA-27101 shared memory realm does not exist   

Linux Error: 2:No such file or directory

 

一早登录ORACLE ,出现以上错误,以前也是出现过一次,

可能是数据库异常出错,被关闭掉了.

这台破测试服务器,换掉是唯一的办法,

 

重启数据库, 问题解决.

 

$ORACLE_BASE/admin/sid/bdump/alert_test.log

看到出现以下错误:

 

Sun Feb  1 18:37:00 2009
Thread 1 advanced to log sequence 1119
  Current log# 3 seq# 1119 mem# 0: /oracle/u02/oradata/test04/redo03.log
Sun Feb  1 19:24:59 2009
DBW0: terminating instance due to error 472
Instance terminated by DBW0, pid = 18034

 

未找到TRACE FILE. 问题继续跟进.