首页 > Linux操作系统 > Linux操作系统 > ORA-600(17113)错误
又是一个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/ ,如需转载,请注明出处,否则将追究法律责任。