PL/SQL 連線設定TNSNAMES.ORA路徑
1.C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\TNSNAMES.ORA 設定2.開始>搜尋，環境變數
2.1系統變數:
變數名稱:TNS_ADMIN
變數直:C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
3.打開PLSQL下拉選Database就會有新增YOURNAMEDB選項
YOURNAMEDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1x.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = YOURNAMEDB)
)
)