Full Export Hangs or Fails with ORA-600 [545] on PUBLIC SYNONYMS (Doc ID 457989.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

On database server start a FULL export using a TNS alias, like "exp user/pass@tns_alias"

1. If using database version 9.2.*, then export hangs on PUBLIC SYNONYMS:

Export: Release 9.2.0.4.0 - Production on Tue Nov 25 09:59:46 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms

2. If using using database version 10.2.*, then export raises ORA-600 [545] on PUBLIC SYNONYMS:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: table data (rows) will not be exported
Note: grants on tables/views/sequences/roles will not be exported
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [545], [0x700000010024AC0], [0], [12], [], [], [], []
EXP-00000: Export terminated unsuccessfully

The trace file for ORA-600 [545] contains:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [545], [0x700000010024AC0], [0], [12], [], [], [], []

If exp is started without the TNS alias, like "exp user/pass", then export works fine.

Changes

A listener with version different than the database version is used, e.g. listener ver. 9.2.0.3 and database version 9.2.0.4 or listener version 10.2.0.2 and database version 10.2.0.3.


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