pl/sql developer 串連伺服器上的資料庫

標籤：des   style   blog   color   os   io   檔案   資料   

 

1， 在本地安裝的Oracle中找到目錄 oracle\product\11.2.0\dbhome_1\network\admin， 它下面一般有兩個檔案可以進行編輯tnsnames.ora   listener.ora ，一般只要配置tnsnames.ora即可. 配置內容如下面的方式.

# tnsnames.ora Network Configuration File: D:\app\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORADEV764 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.181.76.4)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = oradev)    )  )ORCL_190 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.206.190)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

2，開啟PL/SQL Developer軟體，在登入頁面的下拉框中就可以選擇我們配置的 ORADEV764  ORCL_190 了.