oracle連結的配置–product\11.2.0\client_1\network\admin\tnsnames.ora

 

oracle用戶端安裝路徑\product\11.2.0\client_1\network\admin\tnsnames.ora其內容如下：# tnsnames.ora Network Configuration File: E:\Oracle11g-client2-manager\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.DEV =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = DEV)    )  )CESHISTU =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )MYORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )以這個為例：CESHISTU =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )這裡CESHISTU是服務名，我乾脆叫它串連的別名，因為特很容易和資料庫執行個體名混淆。這個名字可以隨便起，它最終在pl/sql的第三個下拉框資料庫顯示，而真正確定串連哪個資料庫的是SERVICE_NAME = orcl。這個orcl才是資料庫執行個體名。它的串連地址是：(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.71)(PORT = 1521))。這些東西當然有相關的管理用戶端去設定，否則每個人都要學習這個檔案的配置，那就太不人性化了。你可以在配置和移植工具裡的Net Manager裡配置這些內容，其實質就是在這個檔案寫這些東西，所以你明白原理以後，配置會更快，更準確。