HPE 9000 and HPE e3000 Servers
cancel
Showing results for 
Search instead for 
Did you mean: 

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

 
Fedon Kadifeli
Super Advisor

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

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?
4 REPLIES 4
Jean-Luc Oudart
Honored Contributor

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

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
fiat lux
Alexander M. Ermes
Honored Contributor

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

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Fedon Kadifeli
Super Advisor

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

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
Honored Contributor

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

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"