My Oracle Support Banner

12.1.0.2 DataPump Import (IMPDP) Hangs Or Returns ORA-12154 / ORA-12170 During Compilation Phase on Windows (Doc ID 2387396.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Generic Windows
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

A hang scenario is seen when loading the functions during the execution of a DataPump import on Windows:

Import: Release 12.1.0.2.0 - Production on Tue Jun 20 09:49:42 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Startup took 0 seconds
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@pmoj directory=expdp DUMPFILE=fulldb.dmp logfile=fulldbimp_metrics.log full=y metrics=yes EXCLUDE=TABLE:"IN ('PRC_ATTACH_DOCUMENTS','PRC_POLICE_ATTACHS','IO_LETTER_TXN_ATTRIBS','CR_ATTACHMENT')"
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39083: Object type TABLESPACE:"UNDOTBS1" failed to create with error:
.................
Completed 3760 TABLE objects in 251 seconds
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "MOJ"."PRC_EVENTS_HISTORY" 13.00 GB 28954371 rows in 180 seconds
. . imported "MOJ"."PRC_PARTIES" 9.434 GB 32191058 rows in 190 seconds
. . imported "MOJ"."PRC_EVENTS" 6.083 GB 15152701 rows in 81 seconds
. . imported "MOJ"."PRC_PARTIES_HISTORY" 4.628 GB 14600223 rows in 95 seconds
.............
Completed 1193 OBJECT_GRANT objects in 3 seconds
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION  <------no progress is seen here

and the job status output shows:

Worker 1 Status:
Instance ID: 1
Instance name: mojc
Host name: SRVADTDB12C01
Process Name: DW00
State: EXECUTING
Object Schema: MOJ
Object Name: GET_AUTHZ_DETAIL
Object Type: DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Completed Objects: 80


- Generating a hanganalyze trace file for the hang issue, it is found that the DataPump Worker process (DW00) is waiting for "single-task message":

 

Changes

 

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!


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