Saturday, February 27, 2016

ORA-31640: unable to open dump file for read and ORA-19505: failed to identify file and ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory

Error:


Import: Release 11.2.0.4.0 - Production on Fri Feb 26 14:19:32 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_05" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_05":  system/******** directory=IMP_DMP logfile=IMP_log.log dumpfile=expdp.dmp_%U remap_schema=SCOTT:USER parallel=32 exclude=GRANT,STATISTICs table_exists_action=replace
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "USER"."EMP" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/u01/IMP/expdp.dmp_10" for read
ORA-19505: failed to identify file "/u01/IMP/expdp.dmp_10"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Solution:
Simply remove parallel clause from impdp command. Or you can add cluster=N Or Keep Import files in shared location.

1 comment:

  1. ORA-39001: valor de argumento no vßlido
    ORA-39000: especificaci¾n de archivo de volcado err¾nea
    ORA-31640: no se ha podido abrir el archivo de volcado "C:\app\JURIDICA2\virtual
    \admin\orcl\dpdump\expdat.dmp" para lectura
    ORA-27041: no se ha podido abrir el archivo
    OSD-04002: no se ha podido abrir el archivo
    O/S-Error: (OS 2) El sistema no puede encontrar el archivo especificado.

    POR FAVOR AYUDENME CON ESTO. ESTOY TRATANDO DE IMPORTAR UN DMP CON IMPDP

    ReplyDelete