ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(17113)错误

ORA-600(17113)错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-01-27 21:49:15 0 删除 编辑

又是一个PL/DEVELOPER的bug。

 

 

客户数据库是9.2.0.8,告警日志中出现大量下面的错误信息:

Thu Dec 1 08:37:52 2011
Errors in file /oracle9/app/admin/db/udump/db1_ora_1995124.trc:
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
Thu Dec 1 08:37:52 2011
Trace dumping is performing id=[cdmp_20111201083752]
Thu Dec 1 08:38:21 2011
Errors in file /oracle9/app/admin/db/udump/db1_ora_1995124.trc:
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
Thu Dec 1 08:39:47 2011
Errors in file /oracle9/app/admin/db/udump/db1_ora_2982400.trc:
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
Thu Dec 1 08:41:32 2011
Errors in file /oracle9/app/admin/db/udump/db1_ora_1995124.trc:
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
Thu Dec 1 08:42:13 2011
Errors in file /oracle9/app/admin/db/udump/db1_ora_1995124.trc:
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
Thu Dec 1 08:43:37 2011
Errors in file /oracle9/app/admin/db/udump/db1_ora_1995124.trc:
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []

在详细TRACE文件/oracle9/app/admin/db/udump/db1_ora_1995124.trc中,可以看到这是一个DEVELOPER工具发起的会话:

   O/S info: user: Administrator, term: PC2011100510, ospid: 2676:2564, machine: WORKGROUP\PC2011100510
              program: plsqldev.exe
    application name: PL/SQL Developer, hash value=1190136663
    action name: Main session, hash value=1773317990

而导致错误的SQL语句为:

declare
  t_owner varchar2(30);
  t_name  varchar2(30);
  procedure check_mview is
    dummy integer;
  begin
    if :object_type = 'TABLE' then
      select 1 into dummy
      from sys.all_objects
      where wner = :object_owner
      and object_name = :object_name
      and object_type = 'MATERIALIZED VIEW'
      and rownum = 1;
      :object_type := 'MATERIALIZED VIEW';
    end if;
  exception
    when others then null;
  end;
begin
  :sub_object := null;
  if :deep != 0 then
    begin
      if :part2 is null then
        select constraint_type, owner, constraint_name
          into :object_type, :object_owner, :object_name
          from sys.all_constraints c
         where c.constraint_name = :part1 and c.owner = user
           and rownum = 1;
      else
        select constraint_type, owner, constraint_name, :part3
          into :object_type, :object_owner, :object_name, :sub_object
          from sys.all_constraints c
         where c.constraint_name = :part2 and c.owner = :part1
           and rownum = 1;
      end if;
      if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if;
      if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if;
      if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if;
      if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if;       
      return;
    exception
      when no_data_found then null;
    end;
  end if;
  :sub_object := :part2;
  if (:part2 is null) or (:part1 != user) then
    begin
      select object_type, user, :part1
      into :object_type, :object_owner, :object_name
      from sys.all_objects
      where wner = user
      and object_name = :part1
      and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
      and rownum = 1;
      if :object_type = 'SYNONYM' then
        select s.table_owner, s.table_name
          into t_owner, t_name
          from sys.all_synonyms s
         where s.synonym_name = :part1
           and s.owner = user
           and rownum = 1;
        select o.object_type, o.owner, o.object_name
          into :object_type, :object_owner, :object_name
          from sys.all_objects o
         where o.owner = t_owner
           and o.object_name = t_name
           and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
           and rownum = 1;
      end if;
      :sub_object := :part2;
      if :part3 is not null then
        :sub_object := :sub_object || '.' || :part3;
      end if;
      check_mview;
      return;
    exception
      when no_data_found then null;
    end;
  end if;
  begin
    select s.table_owner, s.table_name
      into t_owner, t_name
      from sys.all_synonyms s
     where s.synonym_name = :part1
       and s.owner = 'PUBLIC'
       and rownum = 1;
    select o.object_type, o.owner, o.object_name
      into :object_type, :object_owner, :object_name
      from sys.all_objects o
     where o.owner = t_owner
       and o.object_name = t_name
       and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
       and rownum = 1;
    check_mview;
    return;
  exception
    when no_data_found then null;
  end;
  :sub_object := :part3;
  begin
    select o.object_type, o.owner, o.object_name
      into :object_type, :object_owner, :object_name
      from sys.all_objects o
     where o.owner = :part1
       and o.object_name = :part2
       and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')
       and rownum = 1;
    check_mview;
    return;
  exception
    when no_data_found then null;
  end;
  begin
    if :part2 is null and :part3 is null
    then
      select 'USER', null, :part1
      into :object_type, :object_owner, :object_name
      from sys.all_users u
      where u.username = :part1
      and rownum = 1;
      return;
    end if;
  exception
    when no_data_found then null;
  end;
  begin
    if :part2 is null and :part3 is null and :deep != 0
    then
      select 'ROLE', null, :part1
      into :object_type, :object_owner, :object_name
      from sys.session_roles r
      where r.role = :part1
      and rownum = 1;
      return;
    end if;
  exception
    when no_data_found then null;
  end;
  :object_owner := null;
  :object_type := null;
  :object_name := null;
  :sub_object := null;
end;

这显然是DEVELOPER在获取数据字典源数据时执行的SQL,关于这个错误的描述可以参考文档:ORA-00600: internal error code, arguments: [17113] using pl/sql developer [ID 396326.1]。

Oracle针对这个问题的解决方案只有一句,把pl/sql developer升级到最新版本。

 

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

上一篇: ORA-600(504)错误
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1964
  • 访问量
    11085797