oracle shutdown immediate无响应,Oracle Shutdown immediate无响应

oracle database SHUTDOWN: waiting for active calls to complete。

oracle 数据库在 一次shutdown immediate 时hang住。

alter日志内容如下(日志具体路径在/ebspool/ceshi22/db/tech_st/11.1.0/admin/CESHI22_prod/diag/rdbms/ceshi22/CESHI22/trace)：

Mon Oct 18 13:06:09 2010

Active call for process 15846 user 'ebsora' program'oracle@prod'

Active call for process 14575 user 'ebsora' program'oracle@prod'

SHUTDOWN: waiting for active calls to complete.

Mon Oct 18 13:19:32 2010

Incremental checkpoint up to RBA [0x3.191e6d.0], current log tail at RBA [0x3.191e75.0]

Mon Oct 18 13:39:41 2010

Incremental checkpoint up to RBA [0x3.191e89.0], current log tail at RBA [0x3.191e91.0]

Mon Oct 18 13:59:51 2010

Incremental checkpoint up to RBA [0x3.191ea3.0], current log tail at RBA [0x3.191ea8.0]

Mon Oct 18 14:01:42 2010

SHUTDOWN: Active sessions prevent database close operation

Instance shutdown aborted

Mon Oct 18 14:01:42 2010

Starting background process SMCO

Mon Oct 18 14:01:42 2010

SMCO started with pid=40, OS id=16861

Mon Oct 18 14:02:11 2010

Beginning global checkpoint up to RBA [0x3.191eb3.10], SCN: 276461174

Completed checkpoint up to RBA [0x3.191eb3.10], SCN: 276461174

Mon Oct 18 14:02:16 2010

Stopping background process SMCO

Shutting down instance: further logons disabled

Shutting down instance (immediate)

License high water mark = 61

Mon Oct 18 14:07:19 2010

Active call for process 15846 user 'ebsora' program'oracle@prod'

Active call for process 14575 user 'ebsora' program'oracle@prod'

SHUTDOWN: waiting for active calls to complete.

metalink上相关的解决方法：

Locate and kill any client connections to the database at the Unix level, as

follows:

1. Locate any client connections to the database using ps, and grep for any

processes belonging to this .

Example: ps -ef | grep V733

2. Look for processes that include a 'Local=No' designation.

Example: osupport 6235 1 0 Nov 24 0:01 oracleV733 (LOCAL=NO)

3. Kill the Unix process(es) with the 'Local=No' designation.

Example: Kill -9 6235

将'Local=No' 的进程kill掉 数据库就马上正常关闭了

操作如下：

bash-3.00$ ps -ef|grep 15846

ebsora 17006 16923   0 14:24:54 pts/2       0:00 grep 15846

ebsora 15846     1   0 11:39:40 ?           6:29 oracleCESHI22 (LOCAL=NO)

bash-3.00$ ps -ef|grep 14575

ebsora 17008 16923   0 14:25:07 pts/2       0:00 grep 14575

ebsora 14575     1   0 09:57:07 ?           6:51 oracleCESHI22 (LOCAL=NO)

bash-3.00$ kill -9 15846

<