Oracle 10g ORA-12154: TNS: could not resolve the connect identifier specified

我先裝了oracle9,再安裝了pl/sql dev，這時我輸入使用者名稱、口令可以串連伺服器。

隨後我再安裝了ODAC 11.2 Release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio，我再使用pl/sql dev聯結時，報錯

Oracle 10g ORA-12154: TNS: could not resolve the connect identifier specified

查看Path系統內容變數時發現

E:\app\Administrator\product\11.2.0\client_1;E:\app\Administrator\product\11.2.0\client_1\bin;F:\oracle\ora90\bin;

client變數在前，更改成

F:\oracle\ora90\bin;E:\app\Administrator\product\11.2.0\client_1;E:\app\Administrator\product\11.2.0\client_1\bin;

就OK