My Oracle Support Banner

Import Fails Due To ORA-39029 and ORA-7445 [PH2SF_SCAN_FIELDS] (Doc ID 2721090.1)

Last updated on NOVEMBER 04, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.8.0.0.0 version, Data Pump Import fails with below errors.

The following error will be seen in Import log.

ERROR
-----------------------
Failing sql is:

ALTER PROCEDURE "xxxxxx"."xxxxxxxx" COMPILE PLSQL_OPTIMIZE_LEVEL= 1 PLSQL_CODE_TYPE= INTERPRETED PLSQL_DEBUG= FALSE PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2020-03-09 11:02:14'
ORA-39083: Object type ALTER_PROCEDURE:"xxxxxx"."xxxxxx" failed to create with error:

ORA-01775: looping chain of synonyms

ORA-39029: worker 2 with process name "DW00" prematurely terminated

Job "SYS"."SYS_IMPORT_FULL_01" stopped due to fatal error at Sat Oct 17 18:26:21 2020 elapsed 0 00:37:04

Below errors are seen in the Alert log

Error:
--------
ORA-07445: exception encountered: core dump [ph2sf_scan_fields()+612] [SIGSEGV] [ADDR:0x8] [PC:0x539BA64] [Address not mapped to object] []

Changes

 Upgraded the database to 19.8

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.