Anonymous 发表于 2021-10-10 21:57:49

expdp导出时报错，ORA-12154 TNS: 无法解析指定的连接标识符

expdp user/pwd@orcl schemas=orcl DIRECTORY=dpdata DUMPFILE=orcl.dmp

expdp导出时报错，ORA-12154 TNS: 无法解析指定的连接标识符

解决办法：
在导出语句上加ip地址
expdp user/pwd@127.0.0.1/orcl schemas=orcl DIRECTORY=dpdata DUMPFILE=orcl.dmp

D:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp.exe cxsj_dian/cxsj666@192.168.1.200:1521/cxsj directory=dumpdirdumpfile=CXSJ%date:~0,4%%date:~5,2%%date:~8,2%.dmp schemas= (cxsj_dian) logfile=cxsj%date:~0,4%%date:~5,2%%date:~8,2%.log



pause



页: [1]
查看完整版本: expdp导出时报错，ORA-12154 TNS: 无法解析指定的连接标识符