Export of Public Synonyms in Oracle9i 9.2.0.5 or 9.2.0.6 Fails with ORA-600 [KSMASG1], [4032], [4032], [] (Doc ID 279529.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.5 to 9.2.0.6 [Release 9.2]
Oracle Database - Personal Edition - Version 9.2.0.5 to 9.2.0.6 [Release 9.2]
Oracle Database - Standard Edition - Version 9.2.0.5 to 9.2.0.6 [Release 9.2]
Information in this document applies to any platform.
***Checked for relevance on 18-MAY-2012***

Symptoms

An ORA-600 internal error is produced during the export of public synonyms of a full database export:

...
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [KSMASG1], [4032], [4032], [], [], [], []
EXP-00000: Export terminated unsuccessfully

The trace file of the ORA-600 [KSMASG1] internal error shows:

   HEAP DUMP heap name="sga heap" ...
   HEAP DUMP heap name="joxs heap init" ...

And for the cursor:

   Current Instatiation Object:
   cursor name:
SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM2) SYNNAM2, DBMS_JAVA.LONGNAME(SYNTAB)
SYNTAB, TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO
FROM SYS.EXU9PTS ORDER BY SYNTIME

Changes

You recently applied the 9.2.0.5 or 9.2.0.6 patchset on the Oracle9i Release 2 (9.2.0.x) database.

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