Chinaunix

标题: 机器重启后 oracle 无法启动 [打印本页]

作者: ren76ren    时间: 2009-02-12 15:43
标题: 机器重启后 oracle 无法启动
redhat 下安装oracle9i
服务器重启后
oracle 无法登陆
提示如下:
ora-01034 oracle not available
ora-27101 shared memory realm does not exist
linux error:2: no such file or directory


监听也没起来
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 12-FEB-2009 23:18:30

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                12-FEB-2009 23:08:16
Uptime                    0 days 0 hr. 10 min. 14 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/9.2.0.4/network/admin stener.ora
Listener Log File         /oracle/app/oracle/product/9.2.0.4/network/log stener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "smart" has 1 instance(s).
  Instance "smart", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@dbserver1 ~]$ Copyright (c) 1991, 2002, Oracle Corporation.  All rights  reserved.


Google了 没找到原因
作者: ren76ren    时间: 2009-02-12 15:43
帮忙给些建议
作者: football2006    时间: 2009-02-13 15:12
用pfile启动看看
作者: dingning239    时间: 2009-02-13 19:26
注意这一句:linux error:2: no such file or directory

检查你的数据文件,控制文件,参数文件都在不在了,是不是被误删除了
作者: snail506891    时间: 2009-02-14 22:18
sqlplus /nolog

connect / as sysdba

startup




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2