SQL> shutdown immediate
。。。。。一直等待
警报日志:
[oracle@liumujing trace]$ more alert_bianxueqing.log
Thu Feb 21 16:34:55 2013
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Thu Feb 21 16:34:56 2013
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 9
All dispatchers and shared servers shutdown
Thu Feb 21 16:36:05 2013
Instance shutdown cancelled
Shutting down instance (immediate)
Shutting down instance: further logons disabled
License high water mark = 9
All dispatchers and shared servers shutdown
Thu Feb 21 16:41:23 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:46:33 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:51:40 2013
SHUTDOWN: Active processes prevent shutdown operation
Thu Feb 21 16:56:49 2013
SHUTDOWN: Active processes prevent shutdown operation
从中可看出每隔5分钟出现一条
SHUTDOWN: Active processes prevent shutdown operation
模拟情境如下:
打开两个sqlplus 并以sys身份连接上去
以sqlplus1、sqlplus2表示
sqlplus2内容:
[oracle@liumujing ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 21 17:06:12 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> host
[oracle@liumujing ~]$
sqlplus1内容:
SQL> shutdown immediate
---- 一直在等待,shutdown immediate被hang住
解决方法:
sqlplus2退出sys连接
[oracle@liumujing ~]$ exit
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@liumujing ~]$
sqlplus1:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>