昨夜在关闭rac数据库一个节点的时候,数据库就卡在那不动了,我看了一眼日志:
Thu Mar 12 22:11:05 2015
Active call for process 307218 user 'oracle' program 'oracle@gpsrac1 (PZ99)'
SHUTDOWN: waiting for active calls to complete.
Thu Mar 12 22:23:57 2015
IPC Send timeout detected. Receiver ospid 307218
Thu Mar 12 22:23:57 2015
Errors in file /u01/app/oracle/admin/apts/bdump/apts1_pz99_307218.trc:
Thu Mar 12 22:27:02 2015
MMNL absent for 1319 secs; Foregrounds taking over
Thu Mar 12 22:29:07 2015
IPC Send timeout detected. Receiver ospid 307218
Thu Mar 12 22:29:07 2015
Errors in file /u01/app/oracle/admin/apts/bdump/apts1_pz99_307218.trc:
Thu Mar 12 22:32:34 2015
查看日志,提示正在等待一个进程完成。只好手工将此进程kill,数据库关闭:
ps -ef | grep pz99
oracle 307218 1 0 04:30:30 - 0:05 ora_pz99_apts1
......................
将进程杀掉:
kill -9 307218
Thu Mar 12 22:11:05 2015
Active call for process 307218 user 'oracle' program 'oracle@gpsrac1 (PZ99)'
SHUTDOWN: waiting for active calls to complete.
Thu Mar 12 22:23:57 2015
IPC Send timeout detected. Receiver ospid 307218
Thu Mar 12 22:23:57 2015
Errors in file /u01/app/oracle/admin/apts/bdump/apts1_pz99_307218.trc:
Thu Mar 12 22:27:02 2015
MMNL absent for 1319 secs; Foregrounds taking over
Thu Mar 12 22:29:07 2015
IPC Send timeout detected. Receiver ospid 307218
Thu Mar 12 22:29:07 2015
Errors in file /u01/app/oracle/admin/apts/bdump/apts1_pz99_307218.trc:
Thu Mar 12 22:32:34 2015
查看日志,提示正在等待一个进程完成。只好手工将此进程kill,数据库关闭:
ps -ef | grep pz99
oracle 307218 1 0 04:30:30 - 0:05 ora_pz99_apts1
......................
将进程杀掉:
kill -9 307218
上metalink查找了一下这个问题,解决方法也是kill进程,对这个问题的解释如下:
Explanation:
============
The database is waiting for pmon to clean up processes, but pmon is unable to
clean them. The client connections to the server are causing the shutdown
immediate or normal to hang. Killing them allows pmon to clean up and release
the associated Oracle processes and resources.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25116248/viewspace-1458588/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25116248/viewspace-1458588/