- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ORA-00600
Operating System - HP-UX
1754018
Members
7812
Online
108811
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2003 07:53 AM
тАО11-15-2003 07:53 AM
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"
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 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2003 08:16 AM
тАО11-15-2003 08:16 AM
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.
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2003 10:35 AM
тАО11-15-2003 10:35 AM
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
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP