2015.06.25

今天在做匯入的時候報錯，這個匯入已經做了很多次沒報錯，今天做的時候居然報錯
背景：從單例項expdp匯出使用者方案，impdp匯入到雙節點RAC
impdp directory=dmp dumpfile=20150625.dmp SCHEMAS=szxn parallel=3 job_name=my_job_in

ORA-19505: failed to identify file "/home/oracle/dmp/SZXN20150625.DMP"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . imported "SZXN"."TB_LB_APPENDIX"                     68.98 MB  272084 rows
. . imported "SZXN"."TB_LM_PAYPLAN"                      30.40 MB  287677 rows
ORA-31693: Table data object "SZXN"."TB_LM_CLEARTABLE" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/oracle/dmp/SZXN20150625.DMP" for read
ORA-19505: failed to identify file "/home/oracle/dmp/SZXN20150625.DMP"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . imported "SZXN"."TB_LB_APPENDIX_BAK"                 30.44 MB  120410 rows
ORA-31693: Table data object "SZXN"."TB_LB_APPLYLOG" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/oracle/dmp/SZXN20150625.DMP" for read
ORA-19505: failed to identify file "/home/oracle/dmp/SZXN20150625.DMP"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
.
.
.
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"SZXN"."PROC_SURVEYDETAIL" created with compilation warnings
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."MY_JOB_IN" WHERE  process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-19505: failed to identify file "/home/oracle/dmp/SZXN20150625.DMP"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

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

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xc46dfbf8     21979  package body SYS.KUPW$WORKER
0xc46dfbf8      9742  package body SYS.KUPW$WORKER
0xc46dfbf8      4287  package body SYS.KUPW$WORKER
0xc46dfbf8     10450  package body SYS.KUPW$WORKER
0xc46dfbf8      1824  package body SYS.KUPW$WORKER
0x14a853a98         2  anonymous block

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/JOB
Job "SYS"."MY_JOB_IN" completed with 70 error(s) at Thu Jun 25 18:29:39 2015 elapsed 0 00:03:44

[oracle@mctrac1 dmp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 25 18:33:21 2015

Copyright (c) 1982, 2013, Oracle.  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

解決過程：
1、開始以為是識別不了dmp包，匯出的時命令語句裡面是小寫
於是重新用純數字做包名匯出，結果還是報這樣的錯誤，
2、以為是dmp包許可權問你，
於是給了755 許可權

解決辦法：
去掉並行 parallel=3

原因：可能是平臺不一樣，匯出的時候也是沒有並行。

ORA-19505: failed to identify file "/home/oracle/dmp/20150625.DMP"

相關文章