oracle默认登陆账号密码是多少ORA-19505: failed to identify file "/oradata1/dump/CASCTRL07.DMP EXPDP问题

ORA-19505: failed to identify file "/oradata1/dump/CASCTRL07.DMP EXPDP问题

 

expdp 出错

 

$ impdp system/manager directory=DMP content=METADATA_ONLY dumpfile=CASCTRL01.DMP, CASCTRL02.DMP, CASCTRL03.DMP, CASCTRL04.DMP, CASCTRL05.DMP, CASCTRL06.DMP, CASCTRL07.DMP, CASCTRL08.DMP full=Y logfile=METADATA_ONLY_20130627.log job_name=my_job02  parallel=8

 

Import: Release 10.2.0.5.0 – 64bit Production on Thursday, 27 June, 2013 11:16:32

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-31694: master table "SYSTEM"."MY_JOB02" failed to load/unload

ORA-31640: unable to open dump file "/oradata1/dump/CASCTRL07.DMP" for read

ORA-19505: failed toracle账号o identify file "/oradata1/dump/CASCTRL07.DMP"

ORA-27046: file size is not a multiple of logical block size

Additional information: 1

Additional information: 1514345468

Additional information: 4096

 

原因: 文件出错,重新ftp一次就可以了。

 

总结: ora-19505都是因为文件出错,无法读取造成的,有因为二进制文件被编辑的,如spfile损坏;有文件ftp丢帧的问题,如上面的case;

 

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。