今天在对服务器做维护时要先关闭服务器上的物理备库,在执行shutdown immediate30分钟后发现物理备库依然没有关闭,于是查看alert日志发现内容如下:
Shutting down instance (immediate)
Starting background process EMN0
Fri Dec 12 15:04:38 CST 2014
Shutting down instance: further logons disabled
EMN0 started with pid=38, OS id=18960
Fri Dec 12 15:04:38 CST 2014
Stopping background process CJQ0
Fri Dec 12 15:04:38 CST 2014
Stopping background process MMNL
Fri Dec 12 15:04:39 CST 2014
Stopping background process MMON
License high water mark = 35
Fri Dec 12 15:04:40 CST 2014
Job queue slave processes stopped
All dispatchers and shared servers
。。。一直卡在这里
从日志信息来分析发现数据库在停止dispatcher和shared server进程时卡住了,通过ps -ef|grep oracle发现目前oracle进程中除了后台进程外并没有
其他会话连接进来,不过发现了一个可疑进程(一个oracle僵死进程),发现此进程的父进程是sqlplus进程,于是kill掉这个进程后马上就关闭了数据库。
进程信息:
oracle 15972 15934 0 13:18 pts/4 00:00:00 sqlplus as sysdba
oracle 15973 15972 0 13:18 ? 00:00:00 [oracle]
Shutting down instance (immediate)
Starting background process EMN0
Fri Dec 12 15:04:38 CST 2014
Shutting down instance: further logons disabled
EMN0 started with pid=38, OS id=18960
Fri Dec 12 15:04:38 CST 2014
Stopping background process CJQ0
Fri Dec 12 15:04:38 CST 2014
Stopping background process MMNL
Fri Dec 12 15:04:39 CST 2014
Stopping background process MMON
License high water mark = 35
Fri Dec 12 15:04:40 CST 2014
Job queue slave processes stopped
All dispatchers and shared servers
。。。一直卡在这里
从日志信息来分析发现数据库在停止dispatcher和shared server进程时卡住了,通过ps -ef|grep oracle发现目前oracle进程中除了后台进程外并没有
其他会话连接进来,不过发现了一个可疑进程(一个oracle僵死进程),发现此进程的父进程是sqlplus进程,于是kill掉这个进程后马上就关闭了数据库。
进程信息:
oracle 15972 15934 0 13:18 pts/4 00:00:00 sqlplus as sysdba
oracle 15973 15972 0 13:18 ? 00:00:00 [oracle]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20801486/viewspace-1365876/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20801486/viewspace-1365876/