怎么解決EXPDP導出時報錯ORA-12154問題

這篇文章主要講解了“怎么解決EXPDP導出時報錯ORA-12154問題”，文中的講解內容簡單清晰，易于學習與理解，下面請大家跟著小編的思路慢慢深入，一起來研究和學習“怎么解決EXPDP導出時報錯ORA-12154問題”吧！

一、問題描述
    做數據遷移時報錯ORA-12154

1. [oracle@qianzhi ~]$ expdp zrd/zrd@qianz directory=DATA_PUMP_DIR dumpfile=20180314TJJbak.dmp logfile=20180314TJJbak.log schemas=TJJ
   

2. 
   

3. Export: Release 11.2.0.4.0 - Production on Wed Mar 14 10:28:55 2018
   

4. 
   

5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
   

6. 
   

7. UDE-12154: operation generated ORACLE error 12154
   

8. ORA-12154: TNS:could not resolve the connect identifier specified        

9. --字符串沒錯，tns文件也沒問題

二、檢查語句后發現是沒寫IP地址
三、解決方案
    將數據泵導出語句寫完整

1. [oracle@qianzhi admin]$ expdp zrd/zrd@172.16.69.30/qianz directory=DATA_PUMP_DIR dumpfile=20180314TJJbak.dmp logfile=20180314TJJbak.log schemas=TJJ;
   

2. 
   

3. Export: Release 11.2.0.4.0 - Production on Wed Mar 14 10:32:39 2018
   

4. 
   

5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
   

6. 
   

7. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   

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

9. FLASHBACK automatically enabled to preserve database integrity.
   

10. Starting "ZRD"."SYS_EXPORT_SCHEMA_01": zrd

感謝各位的閱讀，以上就是“怎么解決EXPDP導出時報錯ORA-12154問題”的內容了，經過本文的學習后，相信大家對怎么解決EXPDP導出時報錯ORA-12154問題這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是億速云，小編將為大家推送更多相關知識點的文章，歡迎關注！