oracle11g ORA-12154: TNS:could not resolve the connect identifier specified解決辦法

來源:互聯網
上載者:User

XP系統下面安裝了oracle11g 資料庫以及PLSQL Developer7.0的資料庫用戶端

當我串連到遠程伺服器上面的oracle9資料庫時,先是出現“could not load E:\app\Administrator\product\11.2.0\client_1\oci.dll”等一系列問題,

E:\app正是我oracle11g的安裝目錄,根據提示我查看了E:\app\Administrator\product\11.2.0目錄下不存在client_1目錄,

於是我又安裝了一個10.0oracle用戶端,再從該用戶端的安裝路徑找到一個client_1目錄將其拷貝到E:\app\Administrator\product\11.2.0目錄下面,

本以為一切OK了,沒想到出現了新的錯誤提示“could not resolve the connect identifier specified”,於是我添加環境變數後問題解決解決。

TNS_ADMIN ->> E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN



相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.