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 JANUARY 30, 2022
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]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |