Frequent ORA-600 [17059] from Grid Control (Doc ID 416727.1)

Last updated on MARCH 23, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2
Linux x86
Microsoft Windows (32-bit)
***Checked for relevance on 23-Mar-2010***

Symptoms

ORA-600 [17059] reported frequently from Enterprise Manager on the statement:

INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE,
ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL)
VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6,1,32), :B5 ,
SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,128), SUBSTR(:B2 ,1,128),
SUBSTR(:B1 ,1,256))

This starts after Grid Control has been running for some time, but once the error starts it is reported constantly.  A restart will clear the problem only temporarily.

Changes

The repository database for Enterprise Manager is running on a fresh install of 10.2.0.3 Oracle 32bit on Linux or Windows platforms, or an earlier release with the fix for <<Bug 4752541>> 'Intermittent PLS-306 / ORA-1722 / ORA-1858 under load' installed. This includes patch bundle 6 on top of 10.2.0.2.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms