Category Archive: Datapump

Aug 31

ORA-31617: unable to open dump file “/export/data.dmp” for write

Categories:

This morning a user came to me because they were getting what appeared to be a Permission error

FLASHBACK automatically enabled to preserve database integrity.
Starting "myschema"."SYS_EXPORT_SCHEMA_06":
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 252.1 GB
ORA-31693: Table data object "myschema"."mytable" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/nfs/unix/export/myschema01.dmp" for write
ORA-19505: failed to identify file "/nfs/unix/export/myschema01.dmp"
ORA-17503: ksfdopn:4 Failed to open file /nfs/unix/export/msychema01
ORA-17500: ODM err:File does not exist

FLASHBACK automatically enabled to preserve database integrity.

Starting "myschema"."SYS_EXPORT_SCHEMA_06":

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 252.1 GB

ORA-31693: Table data object "myschema"."mytable" failed to load/unload and is being skipped due to error:

ORA-31617: unable to open dump file "/nfs/unix/export/myschema01.dmp" for write

ORA-19505: failed to identify file "/nfs/unix/export/myschema01.dmp"

ORA-17503: ksfdopn:4 Failed to open file /nfs/unix/export/msychema01

ORA-17500: ODM err:File does not exist

I checked the directory listed, /nfs/unix/export. It is mounted on both nodes of the cluster. Checked file permissions, using touch I created a file as the oracle user, and deleted it, no permissions issues there. It …

Tags: Exadata, expdp, mount, nfs, symlink

Leave comment

Aug 31

ORA-02396: exceeded maximum idle time, please connect again

Categories:

Databases, Datapump, Oracle

by Aaron

I was doing a schema import last night, over a database link. Lack of sleep had set in and I was getting the following error

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX 
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [INDEX:"SCHEMA_OWNER"."TABLE2"] 
ORA-02396: exceeded maximum idle time, please connect again 

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 
ORA-06512: at "SYS.KUPW$WORKER", line 11259 

----- PL/SQL Call Stack ----- 
object line object 
handle number name 
0x2156ad620 27116 package body SYS.KUPW$WORKER 
0x2156ad620 11286 package body SYS.KUPW$WORKER 
0x2156ad620 13515 package body SYS.KUPW$WORKER 
0x2156ad620 3173 package body SYS.KUPW$WORKER 
0x2156ad620 12035 package body SYS.KUPW$WORKER 
0x2156ad620 2081 package body SYS.KUPW$WORKER 
0x20d5f9bb0 2 anonymous block 

KUPP$PROC.CHANGE_USER 
KUPP$PROC.CHANGE_USER 
NONE connected to AAR00287 
DBMS_LOB.TRIM 
DBMS_LOB.TRIM 
DBMS_LOB.TRIM 
DBMS_LOB.TRIM 
DBMS_METADATA.FETCH_XML_CLOB 
DBMS_METADATA.FETCH_XML_CLOB 
In procedure DETERMINE_FATAL_ERROR with ORA-02396: exceeded maximum idle time, please connect again

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [INDEX:"SCHEMA_OWNER"."TABLE2"]

ORA-02396: exceeded maximum idle time, please connect again

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 11259

----- PL/SQL Call Stack -----

object line object

handle number name

0x2156ad620 27116 package body SYS.KUPW$WORKER

0x2156ad620 11286 package body SYS.KUPW$WORKER

0x2156ad620 13515 package body SYS.KUPW$WORKER

0x2156ad620 3173 package body SYS.KUPW$WORKER

0x2156ad620 12035 package body SYS.KUPW$WORKER

0x2156ad620 2081 package body SYS.KUPW$WORKER

0x20d5f9bb0 2 anonymous block

KUPP$PROC.CHANGE_USER

NONE connected to AAR00287

DBMS_LOB.TRIM

DBMS_METADATA.FETCH_XML_CLOB

In procedure DETERMINE_FATAL_ERROR with ORA-02396: exceeded maximum idle time, please connect again

Now if you aren’t tired this should be a pretty obvious fix, the idle_time value on the remote server was set to 60 and was disconnecting me during the index …

Tags: database link, impdp, ORA-02396, ORA-39126

Leave comment

Jun 17

Mind your spaces

Categories:

Databases, Datapump, Oracle, Trouble Shooting

by Aaron

I am trying to export a database, everything except for a single table. I need to send a copy of the database to the vendor, but they don’t need a table that takes up %90 of the space in the database due to it storing a massive number of BLOBs and CLOBs This should be …

This post has no tag

Leave comment

Bald DBA

All the DBA, None of the hair

Category Archive: Datapump

ORA-31617: unable to open dump file “/export/data.dmp” for write

ORA-02396: exceeded maximum idle time, please connect again

Mind your spaces

Recent Posts

Recent Comments

Archives

Categories

Meta

Copyright