ITPub博客

首页 > Linux操作系统 > Linux操作系统 > SHUTDOWN: waiting for active calls to complete.

SHUTDOWN: waiting for active calls to complete.

原创 Linux操作系统 作者:shiweimath 时间:2012-05-31 22:06:07 0 删除 编辑
停数据库是遇到异常,一直等待,查看alert日志如下:
Thu May 31 21:32:19 2012
ALTER SYSTEM SET db_files=5000 SCOPE=SPFILE SID='srhx1';
Thu May 31 21:32:43 2012
Shutting down instance: further logons disabled
Thu May 31 21:32:47 2012
Stopping background process CJQ0
Thu May 31 21:32:47 2012
Stopping background process QMNC
Thu May 31 21:32:49 2012
Stopping background process MMNL
Thu May 31 21:32:50 2012
Stopping background process MMON
Thu May 31 21:32:51 2012
Shutting down instance (immediate)
License high water mark = 1295
Thu May 31 21:32:51 2012
Stopping Job queue slave processes, flags = 7
Thu May 31 21:32:51 2012
Process OS id : 304772 alive after kill
Errors in file /home/oracle/admin/srhx/udump/srhx1_ora_919358.trc
Thu May 31 21:32:55 2012
Waiting for Job queue slaves to complete
Thu May 31 21:32:55 2012
Job queue slave processes stopped
  Thu May 31 21:37:54 2012
Active call for process 1337076 user 'oracle' program 'oracle@snake1 (P101)'
SHUTDOWN: waiting for active calls to complete.
    Thu May 31 21:49:22 2012
All dispatchers and shared servers shutdown
Thu May 31 21:50:06 2012
ALTER DATABASE CLOSE NORMAL
Thu May 31 21:50:06 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu May 31 21:50:11 2012
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 173677
Successful close of redo thread 1
Thu May 31 21:50:14 2012
Completed: ALTER DATABASE CLOSE NORMAL
Thu May 31 21:50:14 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu May 31 21:50:24 2012
Trace dumping is performing id=[cdmp_20120531215023]
Thu May 31 21:50:57 2012
freeing rdom 0
一直在SHUTDOWN: waiting for active calls to complete. 就没有在继续,查看资料
http://space.itpub.net/40239/viewspace-717268
提到oracle Metalink上的1039389.6,其内容如下:
Checked for relevance on 11-Dec-2008

Problem Description: 
==================== 
 
You are attempting to shut down the database and the database hangs.  The 
alert log contains the following message: 
 
 
   SHUTDOWN: Waiting for active calls to complete 
 
 
There are no other error messages in the alert log. 


Solution Description:
=====================

--------------------------------------------------------
Caveat:   This note is intended for Unix platforms primarily, but we should 
address this issue on Windows platforms as well.  On Windows, stopping the 
service is a valid workaround for these errors.
--------------------------------------------------------

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 
 
 
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.

What resources are we talking about?

1) Any non committed transactions must be rolled back
2) Any temporary space (sort segments / lobs / session temporary tables) must be freed
3) The session itself and any associated memory consumed by the session.
4) Internal locks / enqueues must be cleaned up

Often Oracle (SMON or PMON depending on whether Shared Server is used) will wait for the OS to terminate the process(es) associated with the session.  I the OS never returns, or fails to terminate them, then the instance shutdown will hang with this message (Shutdown Waiting for Active Calls to Complete)

Other means exist to achieve a quick shutdown, as outlined in Note 386408.1 - What Is The Fastest Way To Cleanly Shutdown An Oracle Database?


Note that in E-Business Environments, the same messages can be produced if the database shutdown process starts before the concurrent manager stops in the application server .

出现此问题故留底以备查

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20957014/viewspace-731615/,如需转载,请注明出处,否则将追究法律责任。

下一篇: rman-06429问题处理
请登录后发表评论 登录
全部评论

注册时间:2009-02-27

  • 博文量
    16
  • 访问量
    24913