雅安论坛

标题: expdp导出时报错，ORA-12154 TNS: 无法解析指定的连接标识符 [打印本页]

作者: 匿名 时间: 2021-10-10 21:57
标题: 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=dumpdir dumpfile=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

复制代码

欢迎光临雅安论坛 (https://www.yaanbbs.net/)