Home > Database > Mysql Tutorial > ORA-00600 的一次故障排除实战

ORA-00600 的一次故障排除实战

WBOY
Release: 2016-06-07 17:19:19
Original
1015 people have browsed it

环境描述:LINUX 虚拟机 redhat5.5+oracle10.2.0.1 单实例库故障描述:startup 启库时出现ORA-00600报错如下,并且无法启动ORA-0

环境描述:LINUX 虚拟机  RedHat5.5+Oracle10.2.0.1 单实例库
 
故障描述:startup 启库时出现ORA-00600报错如下,并且无法启动
 
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
Sat Mar 10 21:18:00 2012
USER: terminating instance due to error 600
Instance terminated by USER, pid = 10599
Sat Mar 10 22:28:57 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization

网上资料:
Oracle的meatlink上文档Doc ID: Note:5486074.8的描述:当Oracle无法确定主机名或者网络地址的时候,会出现这个错误信息。
Oracle在10.2.0.4和11.1.0.6中解决了这个bug。Oracle的metalink上指出在10.2.0.4以前的都可能导致这个错误的产生。
不过测试发现Oracle9i并不会由于修改hostname而导致错误的产生。
故障分析:
       数据库无法群定主机名或网卡地址的时候导致:应该是本人之前手动修改HOSTNAME  并且由于局域网络改变,虚拟机以太网卡没有获取到IP地址所导致,触发数据库版本BUG
 
解决步骤:

(1)首先重启了网络服务,使得网卡绑定了IP地址,,startup可以启动数据库了,但是alert日志中仍然间断报错ORA-00600(每几秒一次) 截图如下:
(2)手动修改HOSTS文件使得本人手动使用HOSTNAME修改的主机名与IP地址相对应:再查看alert日志问题得到解决。

[root@dba ~]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1               dba.com               dba::1             localhost6.localdomain6 localhost6

问题总结:

Oracle在10.2.0.4和11.1.0.6中解决了这个bug。Oracle的metalink上指出在10.2.0.4以前的都可能导致这个错误的产生。

linux

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template