cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-00600

yasser1966
Occasional Visitor

ORA-00600

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"
2 REPLIES
James A. Donovan
Honored Contributor

Re: ORA-00600

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.
Remember, wherever you go, there you are...
Steven E. Protter
Exalted Contributor

Re: ORA-00600

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

Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com