Oracle数据库导入dump数据文件报错
ORA-12545:因目标主机或对象不存在,连接失败的解决办法
错误信息如下:
[oracle@db dpdump]$ impdp system/123456@cams DIRECTORY=dpdata1 dumpfile=deskData202011131309.dmp logfile=deskData202011131309.log schemas=sdata,db2odesk
Import: Release 11.2.0.3.0 - Production on Fri May 29 14:07:32 2015
Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved.
UDI-12154: operation generated ORACLE error 12545
ORA-12545:Connect failed because target host or object does not exist
解决方案:
在使用数据泵导入命令时,在@后面加入数据库的服务器IP信息。如下:
impdp system/123456@127.0.0.1/cams DIRECTORY=dpdata1 dumpfile=deskData202011131309.dmp logfile=deskData202011131309.log schemas=sdata,db2odesk