本文记录了一次Oracle数据库在关闭过程中遇到的问题及现象。主要表现为数据库长时间停留在关闭状态，且无法继续进行。通过查看alert日志发现数据库在关闭过程中出现了错误，并一直等待活动调用完成。文章还提及了可能的解决方案来源。
停数据库是遇到异常，一直等待，查看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. 就没有在继续，查看资料
提到oracle Metalink上的
1039389.6，其内容如下：
出现此问题故留底以备查
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20957014/viewspace-731615/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/20957014/viewspace-731615/
扫一扫
777
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
