ORA-00600

[yasser1966]

Hi there.
i have this problem appear with me in oracle 9i and HP-ux 11


ARC0: Completed archiving log 2 thread 1 sequence 1052
Sat Nov 15 21:10:42 2003
Errors in file /u01/app/oracle/product/9.0.1/admin/HMISLIB/udump/ora_7809_hmislib.trc:
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
Sat Nov 15 21:17:17 2003
Errors in file /u01/app/oracle/product/9.0.1/admin/HMISLIB/udump/ora_8048_hmislib.trc:
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
Sat Nov 15 21:19:00 2003
Undo Segment 18 Onlined
Sat Nov 15 21:26:37 2003
Created Undo Segment _SYSSMU19$
Undo Segment 19 Onlined
Sat Nov 15 21:27:09 2003
Created Undo Segment _SYSSMU20$
Undo Segment 20 Onlined
Sat Nov 15 21:27:40 2003
Created Undo Segment _SYSSMU21$
Undo Segment 21 Onlined
Sat Nov 15 21:29:05 2003
Thread 1 advanced to log sequence 1054
Sat Nov 15 21:29:05 2003
Current log# 4 seq# 1054 mem# 0: /u02/oradata/HMISLIB/redo/redo04a.log
Current log# 4 seq# 1054 mem# 1: /u03/oradata/HMISLIB/redo/redo04b.log
Sat Nov 15 21:29:05 2003
ARC0: Beginning to archive log 3 thread 1 sequence 1053
Sat Nov 15 21:29:21 2003
ARC0: Completed archiving log 3 thread 1 sequence 1053



*** SESSION ID:(66.809) 2003-11-15 21:10:41.711
*** 2003-11-15 21:10:41.711
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []
Current SQL statement for this session:
select
L.sid session_id,
Substr(S.Username, :"SYS_B_00", :"SYS_B_01") as DBUser,
decode(L.type, :"SYS_B_02",:"SYS_B_03", :"SYS_B_04",:"SYS_B_05",
:"SYS_B_06",:"SYS_B_07", :"SYS_B_08",:"SYS_B_09",
:"SYS_B_10",:"SYS_B_11", :"SYS_B_12",:"SYS_B_13",
:"SYS_B_14",:"SYS_B_15", :"SYS_B_16",:"SYS_B_17",
:"SYS_B_18",:"SYS_B_19", :"SYS_B_20",:"SYS_B_21",
:"SYS_B_22",:"SYS_B_23", :"SYS_B_24",:"SYS_B_25",
:"SYS_B_26",:"SYS_B_27", :"SYS_B_28",:"SYS_B_29",
:"SYS_B_30",:"SYS_B_31", :"SYS_B_32",:"SYS_B_33",
:"SYS_B_34",:"SYS_B_35", :"SYS_B_36",:"SYS_B_37",
:"SYS_B_38",:"SYS_B_39", L.type) lock_type,
decode(L.lmode, :"SYS_B_40", :"SYS_B_41", :"SYS_B_42", :"SYS_B_43",
:"SYS_B_44", :"SYS_B_45", :"SYS_B_46", :"SYS_B_47",
:"SYS_B_48", :"SYS_B_49", :"SYS_B_50", :"SYS_B_51",
:"SYS_B_52", :"SYS_B_53", to_char(L.lmode)) mode_held,
decode(L.request, :"SYS_B_54", :"SYS_B_55", :"SYS_B_56", :"SYS_B_57",
:"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61",
:"SYS_B_62", :"SYS_B_63", :"SYS_B_64", :"SYS_B_65",
:"SYS_B_66", :"SYS_B_67", to_char(L.request)) mode_requested,
to_char(L.id1) lock_id1,
decode(L.block, :"SYS_B_68", :"SYS_B_69", :"SYS_B_70", :"SYS_B_71",
:"SYS_B_72", :"SYS_B_73", to_char(L.block)) blocking_others,
to_char(L.id2) lock_id2, sysdate - (l.ctime / :"SYS_B_74") ctime,
S.User#,
S.status,
S.schemaname,
S.osuser,
S.machine,
S.Program, S.Terminal,
S.type,
S.logon_time,
S.Serial#,
S.paddr,
decode(S.sql_hash_value, :"SYS_B_75", S.prev_hash_value, S.sql_hash_value) SQL_HASH_VALUE
from V$lock L, V$session S
where S.Sid = L.SID
And S.type <> :"SYS_B_76"
Order by :"SYS_B_77"

[James A. Donovan]

This appears to be a known Oracle bug.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=2306106.8

You should open a TAR with Oracle. According to the Metalink article, the issue should be resolved in version 9.2.0.2 or higher.

[Steven E. Protter]

ORA-0600 is a generic "I don't know what happened but it was bad" from Oracle. Its a next to useless return code.

We had similar issues to you and solved it by ripping out and reinstalling the product. If its a new install consider that step. If not, its technet.oracle.com and metalink.oracle.com search time.

SEP