"ORA-00600: internal error code" Physical memory problem?

[Fedon Kadifeli]

We are getting the following Oracle errors in our V-class machine:

ORA-00600: internal error code, arguments: [17112], [105030200], [], [], [], [], [], []

Information from Oracle Metalink mentions (among other things) about memory corruption. So, in order to see if we are having any physical memory errors, I ran the following command:

# echo 'selclass qualifier memory;info;wait;infolog' | cstm

At the end of the output I see:

...
Memory Error Log Summary

The memory error log is empty.

Page Deallocation Table (PDT)

PDT Entries Used: 0
PDT Entries Free: 100
PDT Total Size: 100

Which suggests there is no physical memory problem on the system. Is my assumption correct?

[Jean-Luc Oudart]

Hi

ORA-00600 is quite generic, you probably have other error codes/messages before or after in the alert log file
cf Metalink Note:146580.1 "What is an ORA-600 Internal Error?"

see also this thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=854793

Regards
Jean-Luc

[Alexander M. Ermes]

Hi there.
What Oarcle version are we talking about ?
Did you install all necessary patches from HP mentioned in the Install and Upgrade docs from Oracle ? Pls check this and post the result. We are running Oracle 8.0.5, 8.1.7 and 9.2.0.6 on a V2500.
Did you report the errors to Oracle ( open a TAR ) ?
Rgds
Alexander M. Ermes

[Fedon Kadifeli]

Thank you for your replies.

My primary question was this:

By using the mentioned cstm command and inspecting the output, can I be sure that there is no physical memory problem on the system?

About the Oracle questions:

We are using Oracle 8.1.7 on HP-UX 11.00 (V2600 system) and all necessary and many more patches are installed. This Oracle installation is quite old, but closely administered (because it is our main production database!). Also HP-UX is periodically patched with the HP recommended patches.

The Oracle error messages in the alert log are like this:

Wed Oct 5 02:27:48 2005
Errors in file /disk3/app/oracle/admin/DBABP/udump/ora_15380_dbabp.trc:
ORA-00600: internal error code, arguments: [17112], [105030200], [], [], [], [], [], []


And the associated trace file starts with the following lines:

Dump file /disk3/app/oracle/admin/DBABP/udump/ora_15380_dbabp.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
ORACLE_HOME = /disk3/app/oracle/product/8.1.7
System name: HP-UX
Node name: dbpsrv
Release: B.11.00
Version: U
Machine: 9000/800
Instance name: DBABP
Redo thread mounted by this instance: 1
Oracle process number: 166
Unix process pid: 15380, image: oracle@dbpsrv (TNS V1-V3)

*** SESSION ID:(240.20537) 2005-10-05 02:27:34.358
********** Internal heap ERROR 17112 addr=0xc00000010642a238 *********
***** Dump of memory around addr 0x642a238:
0642A030 00000000 00000018 [........]
0642A040 01900000 00000000 00000005 00000002 [................]
0642A050 00000000 00000000 00000000 00000000 [................]
...

This file is 10485814 bytes long, so I am not going to post the whole contents of the file.

[Alexander M. Ermes]

Hi there.
Output from your command on my system :

-- Information --
Support Tools Manager


Version A.28.00

Product Number B4708AA

(C) Copyright Hewlett Packard Co. 1995-2001
All Rights Reserved

Use of this program is subject to the licensing restrictions described
in "Help-->On Version". HP shall not be liable for any damages resulting
from misuse or unauthorized use of this program.

cstm>selclass qualifier memory;info;wait;infolog
-- Updating Map --
Updating Map...
-- Converting a (4484) byte raw log file to text. --
Preparing the Information Tool Log for MEMORY on path 8 File ...

.... hpnss-01 : 10.131.241.219 ....

-- Information Tool Log for MEMORY on path 8 --

Log creation time: Thu Oct 6 07:17:08 2005

Hardware path: 8


Basic Memory Description

Module Type: MEMORY
Total Physical Memory : N/A
Total Configured Memory : 12288 MB
Page Size: 4096 Bytes

Memory interleaving is supported on this machine and is ON.

Memory Board Inventory

Note: The first letter in all DIMM slots start with a "Q" (i.e. Q0B0).

MC
Slot Configured and Slot label for each DIMM (MB)
---- ------------------------------------------------------------------
0B0 2B0 1B4 3B4 0B1 2B1 1B5 3B5 0B2 2B2 1B6 3B6 0B3 2B3 1B7 3B7
--------------- --------------- --------------- ---------------

MB0L 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
MB1L 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
MB2R 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
MB3R 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
MB4L 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
MB5L 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
MB6R 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
MB7R 128 128 128 0 128 128 128 0 128 128 128 0 128 128 128 0
------------------------------------------------------------------------
System Total (MB): 12288

Memory Error Log Summary

Error
Board Error Address Error Type Page Count
------------ ------------------ ---------- --------- -----
MB3R/Q0B3 0x30002000291e0920 Single-Bit N/A 1
MB3R/Q0B3 0x3000040074ee6e40 Single-Bit N/A 1

System start: Wed Jul 27 17:49:01 2005.
Last error check: Thu Oct 6 07:01:53 2005.
Logging interval: 3600 seconds.
2 address(es) with errors logged by memory logging daemon.

The Logtool Utility provides full details about the memory error log.

Page Deallocation Table (PDT)

PDT Entries Used: 0
PDT Entries Free: 100
PDT Total Size: 100
-- Information Tool Log for MEMORY on path 8 --
View - To View the file.
Print - To Print the file.
SaveAs - To Save the file.
----------------------------------------

The Page deallocation table contains addresses in the memory, which do not work anymore.
Compare it with your result.
My system is ok.
Rgds
Alexander M. Ermes