\u53c8\u662f\u4e00\u4e2aPL\/DEVELOPER\u7684bug\u3002
\n\u5ba2\u6237\u6570\u636e\u5e93\u662f9.2.0.8\uff0c\u544a\u8b66\u65e5\u5fd7\u4e2d\u51fa\u73b0\u5927\u91cf\u4e0b\u9762\u7684\u9519\u8bef\u4fe1\u606f\uff1a<\/p>\n
Thu Dec 1 08:37:52 2011\r\nErrors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_1995124.trc:\r\nORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []\r\nThu Dec 1 08:37:52 2011\r\nTrace dumping is performing id=[cdmp_20111201083752]\r\nThu Dec 1 08:38:21 2011\r\nErrors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_1995124.trc:\r\nORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []\r\nThu Dec 1 08:39:47 2011\r\nErrors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_2982400.trc:\r\nORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []\r\nThu Dec 1 08:41:32 2011\r\nErrors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_1995124.trc:\r\nORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []\r\nThu Dec 1 08:42:13 2011\r\nErrors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_1995124.trc:\r\nORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []\r\nThu Dec 1 08:43:37 2011\r\nErrors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_1995124.trc:\r\nORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []<\/pre>\n\u5728\u8be6\u7ec6TRACE\u6587\u4ef6\/oracle9\/app\/admin\/db\/udump\/db1_ora_1995124.trc\u4e2d\uff0c\u53ef\u4ee5\u770b\u5230\u8fd9\u662f\u4e00\u4e2aDEVELOPER\u5de5\u5177\u53d1\u8d77\u7684\u4f1a\u8bdd\uff1a<\/p>\n
O\/S info: user: Administrator, term: PC2011100510, ospid: 2676:2564, machine: WORKGROUP\\PC2011100510\r\n program: plsqldev.exe\r\n application name: PL\/SQL Developer, hash value=1190136663\r\n action name: Main session, hash value=1773317990<\/pre>\n\u800c\u5bfc\u81f4\u9519\u8bef\u7684SQL\u8bed\u53e5\u4e3a\uff1a<\/p>\n
declare\r\n t_owner varchar2(30);\r\n t_name varchar2(30);\r\n procedure check_mview is\r\n dummy integer;\r\n begin\r\n if :object_type = 'TABLE' then\r\n select 1 into dummy\r\n from sys.all_objects\r\n where owner = :object_owner\r\n and object_name = :object_name\r\n and object_type = 'MATERIALIZED VIEW'\r\n and rownum = 1;\r\n :object_type := 'MATERIALIZED VIEW';\r\n end if;\r\n exception\r\n when others then null;\r\n end;\r\nbegin\r\n :sub_object := null;\r\n if :deep != 0 then\r\n begin\r\n if :part2 is null then\r\n select constraint_type, owner, constraint_name\r\n into :object_type, :object_owner, :object_name\r\n from sys.all_constraints c\r\n where c.constraint_name = :part1 and c.owner = user\r\n and rownum = 1;\r\n else\r\n select constraint_type, owner, constraint_name, :part3\r\n into :object_type, :object_owner, :object_name, :sub_object\r\n from sys.all_constraints c\r\n where c.constraint_name = :part2 and c.owner = :part1\r\n and rownum = 1;\r\n end if;\r\n if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if;\r\n if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if;\r\n if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if;\r\n if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if; \r\n return;\r\n exception\r\n when no_data_found then null;\r\n end;\r\n end if;\r\n :sub_object := :part2;\r\n if (:part2 is null) or (:part1 != user) then\r\n begin\r\n select object_type, user, :part1\r\n into :object_type, :object_owner, :object_name\r\n from sys.all_objects\r\n where owner = user\r\n and object_name = :part1\r\n and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')\r\n and rownum = 1;\r\n if :object_type = 'SYNONYM' then\r\n select s.table_owner, s.table_name\r\n into t_owner, t_name\r\n from sys.all_synonyms s\r\n where s.synonym_name = :part1\r\n and s.owner = user\r\n and rownum = 1;\r\n select o.object_type, o.owner, o.object_name\r\n into :object_type, :object_owner, :object_name\r\n from sys.all_objects o \r\n where o.owner = t_owner\r\n and o.object_name = t_name\r\n and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')\r\n and rownum = 1;\r\n end if;\r\n :sub_object := :part2;\r\n if :part3 is not null then\r\n :sub_object := :sub_object || '.' || :part3;\r\n end if;\r\n check_mview;\r\n return;\r\n exception\r\n when no_data_found then null;\r\n end;\r\n end if;\r\n begin\r\n select s.table_owner, s.table_name\r\n into t_owner, t_name\r\n from sys.all_synonyms s\r\n where s.synonym_name = :part1\r\n and s.owner = 'PUBLIC'\r\n and rownum = 1;\r\n select o.object_type, o.owner, o.object_name\r\n into :object_type, :object_owner, :object_name\r\n from sys.all_objects o \r\n where o.owner = t_owner\r\n and o.object_name = t_name\r\n and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')\r\n and rownum = 1;\r\n check_mview;\r\n return;\r\n exception\r\n when no_data_found then null;\r\n end;\r\n :sub_object := :part3;\r\n begin\r\n select o.object_type, o.owner, o.object_name\r\n into :object_type, :object_owner, :object_name\r\n from sys.all_objects o\r\n where o.owner = :part1\r\n and o.object_name = :part2\r\n and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM')\r\n and rownum = 1;\r\n check_mview;\r\n return;\r\n exception\r\n when no_data_found then null;\r\n end;\r\n begin\r\n if :part2 is null and :part3 is null\r\n then\r\n select 'USER', null, :part1\r\n into :object_type, :object_owner, :object_name\r\n from sys.all_users u\r\n where u.username = :part1\r\n and rownum = 1;\r\n return;\r\n end if;\r\n exception\r\n when no_data_found then null;\r\n end;\r\n begin\r\n if :part2 is null and :part3 is null and :deep != 0\r\n then\r\n select 'ROLE', null, :part1\r\n into :object_type, :object_owner, :object_name\r\n from sys.session_roles r\r\n where r.role = :part1\r\n and rownum = 1;\r\n return;\r\n end if;\r\n exception\r\n when no_data_found then null;\r\n end;\r\n :object_owner := null;\r\n :object_type := null;\r\n :object_name := null;\r\n :sub_object := null;\r\nend;<\/pre>\n\u8fd9\u663e\u7136\u662fDEVELOPER\u5728\u83b7\u53d6\u6570\u636e\u5b57\u5178\u6e90\u6570\u636e\u65f6\u6267\u884c\u7684SQL\uff0c\u5173\u4e8e\u8fd9\u4e2a\u9519\u8bef\u7684\u63cf\u8ff0\u53ef\u4ee5\u53c2\u8003\u6587\u6863\uff1aORA-00600: internal error code, arguments: [17113] using pl\/sql developer [ID 396326.1]\u3002
\nOracle\u9488\u5bf9\u8fd9\u4e2a\u95ee\u9898\u7684\u89e3\u51b3\u65b9\u6848\u53ea\u6709\u4e00\u53e5\uff0c\u628apl\/sql developer\u5347\u7ea7\u5230\u6700\u65b0\u7248\u672c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u53c8\u662f\u4e00\u4e2aPL\/DEVELOPER\u7684bug\u3002 \u5ba2\u6237\u6570\u636e\u5e93\u662f9.2.0.8\uff0c\u544a\u8b66\u65e5\u5fd7\u4e2d\u51fa\u73b0\u5927\u91cf\u4e0b\u9762\u7684\u9519\u8bef\u4fe1\u606f\uff1a 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 … Continue reading