Oracle bug 之ORA-00600 [LibraryCacheNotEmptyOnClose]

php中文网
发布: 2016-06-07 17:03:11
原创
1022人浏览过

Oracle bug 之ORA-00600 [LibraryCacheNotEmptyOnClose]

帮一客户关闭数据库。在关闭实例阶段,,alert显示

引用

Fri May 14 01:08:49 2010
System State dumped to trace file /u01/app/Oracle/oracle/product/10.2.0/db_2/admin/HIS3/udump/his3_ora_634882.trc
Fri May 14 01:08:49 2010
Errors in file /u01/app/oracle/oracle/product/10.2.0 _2/admin/HIS3/udump/his3_ora_634882.trc:
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []

错误很明确了,LibraryCacheNotEmptyOnClose内存在实例关闭时,没有释放。估计是bug引起的,并不会引起数据库的不一致。经查metalink,偶然验证了我的判断。以下是matalink的说明:

引用

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
Symptoms
o  ORA-600 [LibraryCacheNotEmptyOnClose] is reported in the alert.log on shutdown.
The trace file shows following call stack trace and will also include a System State:

kglshu kqlnfy kscnfy ksmshu
opistp_real opistp opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real main libc_start_main

o Using the mechanism described in Note 301171.1 to pin objects in the Shared Pool
might cause the error.  The problem disappears when the pinning of objects is stopped by
deactivating the associated triggers.

Cause
This is due to unpublished Bug 4483084 'ORA-600 [LIBRARYCACHENOTEMPTYONCLOSE]'

This is a bug in that an ORA-600 error is reported when it is found that something is still going on during shutdown. It does not indicate any damage or a problem in the system.

Solution

This problem is fixed in 11.1.0.6.
Due to the nature of the fix, it is not possible to backport to earlier releases.

The error can be safely ignored as it does not indicate a problem with the database.

linux

最佳 Windows 性能的顶级免费优化软件
最佳 Windows 性能的顶级免费优化软件

每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号