ORACLE SOS

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 7185|回复: 1

ora-600导致SMON异常终止,实例重启

[复制链接]

5

主题

16

帖子

74

积分

注册会员

Rank: 2

积分
74
发表于 2015-2-10 09:21:58 | 显示全部楼层 |阅读模式
主要的错误:
ORA-00600: internal error code, arguments: [kglGetMutex]
ORA-00600: internal error code, arguments: [kglpnlt]
附件为alert日志及trace信息。

平台:Linux
数据库版本:11.2.0.3.0 单实例

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

95

主题

266

帖子

1719

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1719
发表于 2015-2-10 09:28:38 | 显示全部楼层
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
SYMPTOMS
As per alert.log, below errors reported in their environment:

    ORA-00600: internal error code, arguments: [kglGetMutex], [], [], [], [], [], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [kglpnlt], [], [], [], [], [], [], [], [], [], [], []
    ORA-07445: exception encountered: core dump [kglhdgn()+282] [SIGSEGV] [ADDR:0x0] [PC:0x93908AA] [SI_KERNEL(general_protection)] []
    ORA-07445: exception encountered: core dump [kglGetMutex()+80] [SIGBUS] [ADDR:0xF67D5310] [PC:0x9392516] [Non-existent physical address] []

Call stack from ORA-00600 trace file is reported as:

    skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
       <- ssexhd <- sighandler <- kglGetMutex <- kglScanHandles4Unke <- ktmmon
        <- ep <- ktmSmonMain <- ksbrdp <- opirip <- opidrv
         <- sou2o <- opimai_real <- ssthrdmain <- main <- libc_start_main
          <- start
Note: Here the call stack is similar for ORA-00600 [kglGetMutex] and ORA-07445 [kglGetMutex()+80].

During our analysis, we refereed the Doc ID 13550185.8 and found that CURSOR_SHARING=EXACT along with SYS_Bnnn binds in SQL statements.

This was confirmed from incident trace file and by executing below SQL statement in customer environment-

    SQL> select count(*) from v$sql_bind_capture where name like ':SYS%';
CAUSE
This issue is matching with Bug 17059810, which was closed as duplicate of Bug 13550185 .
This was confirmed through a new Bug 20348053
SOLUTION
The suggestion from development is to follow the below action plan:

1.    Download and apply patch 13550185 available for your platform on top of 11.2.0.3.
2.    It should resolve the issue but you can monitor and keep the following set:
   
        SQL > alter system set max_dump_file_size=unlimited;
        SQL> alter system set events '7445 trace name errorstack level 3;name library_cache level 90';
      
If the issue is seen again then provide:

a.    Full alert log and the tracefile/incident file for the latest crash.
b.    Opatch output from:

          opatch lsinventory -detail

And create a SR along with these details, so that Oracle support can file a new Bug.

Note: To disable the 7445 event:

    SQL> alter system set events '7445 trace name errorstack off;name library_cache off';



Q Q:107644445
Tel:13429648788
Email:dba@xifenfei.com
个人Blog(惜分飞)
提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|ORACLE SOS 技术论坛

GMT+8, 2024-12-5 10:15 , Processed in 0.020494 second(s), 22 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表