紧急，客户的oracle不能shutdown immediate

ccw2003

现象：
数据库480G左右，advance queue 有连接
shutdown immediate执行后1个小时后出现
active session prevent database close operation.不能正常shutdown.
操作：
手动alter system kill session 把所有aquser的连接删除成killed状态
并且改aq_tm_process=0
再次执行shutdown immediate执行后1个小时后仍然出现active session prevent database close operation.不能正常shutdown.

alert.log内容
LTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;
Wed Dec 24 23:45:17 2003
Restarting dead background process EMN0
EMN0 started with pid=11
Thu Dec 25 14:45:17 2003
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 62
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Dec 25 14:50:26 2003
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Restarting dead background process EMN0
EMN0 started with pid=11
Thu Dec 25 14:45:17 2003
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 62
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Dec 25 14:50:26 2003
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
Active process 0 user '' program 'PSEUDO'
SHUTDOWN: waiting for logins to complete.
Thu Dec 25 15:46:22 2003
SHUTDOWN: Active sessions prevent database close operation
Thu Dec 25 00:47:22 2003
idle dispatcher 'D000' terminated, pid = (9, 4))

请教是可能是什么原因？我怎样调查?谢谢了

txfy

piner
又是MTS
从来不用这个，需要更多的信息
或许是BUG

chao_ping
licence high water mark 才60多个也用MTS，真是浪费资源啊。

所以我的建议也是先Disable MTS。
根据这两位老大的意见，取消mts

ccw2003

dispatch的设置是我忘了comment了
谢谢

yikaikai

http://211.99.196.144:8090/forum1/frontshow/dispbbs.jsp?boardid=84&id=8954

ccw2003

谢谢回复，但我在windows下找不到orakill命令。
并且如何调查才可以找到原因，执行shutdown immediate正常停止数据库呢？
等答复

biti_rainy

http://www.cnoug.org/cgi-bin/topic_show.cgi?id=2934&h=1&bpg=1&age=30

ccw2003

跟我的情况简直是一模一样，最后是怎样解决的呀？我用了alter system kill session杀过进程，现在linux的process ID 已经没有了，但在oracle中还是有status is KILLED的进程显示。

OCPHUI

好象是BUG在搞鬼。

我曾SHUTDOWN IMMEDIATE了半個小時。

真是讓人擔驚受怕的。

ccw2003

我现在不是一两个小时的问题，是试的4次shutdown immediate每次等了1个多小时候，告诉我不可以shutdown数据库有启动起来了。根本不能shutdown immediate.谁有什么高招？

ccw2003

我现在求一种成功的方法，因为是客户的数据库，要去碰之前要添申请单。
alter system checkpoint
shutdown immediate一定可以成功？
shutdown abort又不能保证不受损，下次启动。
可怎么办呀？os 是linux7.2 ,server is dell poweredge6650,普通scsi硬盘raid5加hotspare