Oracle- PL/SQL DEV的遠程配置

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

首先裝好Oracle企業版或者用戶端精簡版。之後要修改你的的tnsnames.ora檔案，來增加資料庫。

我的ORACLE執行個體是ORACLE1，放在D:\oracle\ 目錄下。我的IP地址是 192.168.1.102

 

修改如下：添加：DEMO =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST =  192.168.1.102)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ORACLE1)    )  ) 這樣就把一個遠端資料庫添加到原生用戶端中了。然後開啟PL/SQL DEV 軟體。在工具->喜好設定中修改：Oracle主目錄名：D:\oracle\OCI庫：D:\oracle\ora92\bin\oci.dll 這樣設定之後，就可以通過PL/SQL DEV來訪問遠端Oracle資料庫了。  附上最原始的tnsnames.ora檔案

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLE1 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = VKP1W8IQZW4QTSX)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = Oracle1)    )  )INST1_HTTP =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = VKP1W8IQZW4QTSX)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = SHARED)      (SERVICE_NAME = MODOSE)      (PRESENTATION = http://HRService)    )  )EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))    )    (CONNECT_DATA =      (SID = PLSExtProc)      (PRESENTATION = RO)    )  )