Import Fails Due To ORA-39029 and ORA-7445 [PH2SF_SCAN_FIELDS]
(Doc ID 2721090.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and laterInformation 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 |