恳求解决ORA-10997: another startup/shutdown operation of this instance inprogress

yewaa82 2011-11-15 11:41:52

我的系统是win2003，数据库是oracle10g
数据库有段时间没用了，今天启动的时候就报错了
startup
startup nomount
startup mount
startup pfile=‘d:。。。’
startup force
均报如下的错，不知道是怎么回事
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
网上有人说是数据库没成功关闭，使用startup force可以解决，可是我试了之后还是报一样的错
服务也重启了很多次了，问题依然存在
使用shutdown immediate报如下的错：
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

请问有那位大侠知道怎么解决吗？恳求解决方案！

...全文

1999 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

yewaa82 2011-11-17

打赏
举报

所有方法都试过了，还是没用
只好卸了重装。。。
还是谢谢各位好心人。。

傻儿哥 2011-11-16

打赏
举报

ORA-27101: shared memory realm does not exist

貌似和启动参数有关，也可能和哪个sqlnet.ora参数有关。
建议LZ google 下 ora 27101
下面帖子可以参考下
http://space.itpub.net/10595277/viewspace-368788

yewaa82 2011-11-16

打赏
举报

Thread 1 advanced to log sequence 91
Current log# 3 seq# 91 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jul 20 14:24:36 2011
Starting background process EMN0
EMN0 started with pid=106, OS id=4568
Wed Jul 20 14:24:36 2011
Shutting down instance: further logons disabled
Wed Jul 20 14:24:36 2011
Stopping background process QMNC
Wed Jul 20 14:24:37 2011
Stopping background process CJQ0
Wed Jul 20 14:24:37 2011
Stopping background process MMNL
Wed Jul 20 14:24:37 2011
Stopping background process MMON
Wed Jul 20 14:24:37 2011
Shutting down instance (immediate)
License high water mark = 12
Wed Jul 20 14:24:37 2011
Stopping Job queue slave processes
Wed Jul 20 14:24:37 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown

这是alert日志里面最后的部分，之后再没有记录了
先执行以下 shutdown immediate
然后再startup 这些都已经尝试过了

不知道什么原因会引起这种情况。。。

cosio 2011-11-15

打赏
举报

shutdown immediate;

或是

shutdown abort;



然后在startup!

huangdh12 2011-11-15

打赏
举报

看看 alert.log 里面报的错误信息吧贴出来

先执行以下 shutdown immediate
然后再startup

yewaa82 2011-11-15

打赏
举报

服务都启动了

cosio 2011-11-15

打赏
举报

看一下,管理的服务,oracle的各服务都启动了嘛?

yewaa82 2011-11-15

打赏
举报

你是说当前操作的trace文件吗？
trace文件内容如下,没见到什么异常呀

TKPROF: Release 10.2.0.1.0 - Production on 星期二 11月 15 15:35:17 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Trace file: orcl_ora_7440.trc
Sort options: default

********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: orcl_ora_7440.trc
Trace file compatibility: 10.01.00
Sort options: default

0 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
988 lines in trace file.
0 elapsed seconds in trace file.