我的系统是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请问有那位大侠知道怎么解决吗?恳求解决方案!
数据库有段时间没用了,今天启动的时候就报错了
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请问有那位大侠知道怎么解决吗?恳求解决方案!
或是
shutdown abort;然后在startup!
是不是非得重新安装了呀?
可以进一步查看警告日志和跟踪文件,确定错误的具体原因。
oradim.log中记录ORA-03113: 通信通道的文件结束
还有什么好建议吗?
Oracle 10g中也应该有tkprof工具。
trace文件内容如下,没见到什么异常呀TKPROF: Release 10.2.0.1.0 - Production on 星期二 11月 15 15:35:17 2011Copyright (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.
然后再startup
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 = 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 这些都已经尝试过了不知道什么原因会引起这种情况
貌似和启动参数有关,也可能和哪个sqlnet.ora参数有关。
建议LZ google 下 ora 27101
下面帖子可以参考下
http://space.itpub.net/10595277/viewspace-368788