PL/SQL如何遠端連線ORACLE

標籤：

如何在沒有裝ORACLE的電腦上用PLSQL遠端連線ORACLE

下載instantclient，我的是WIN7，下載的是instantclient-basiclite-nt-12.1.0.1.0.zip

解壓到一個固定的目錄如C:\instantclient_plsql

在解壓的目錄裡建立檔案network\admin\tnsnames.ora

編輯檔案內容，注意IP和PROT要用遠程ORACLE的

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.

ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.176.110)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))    )    (CONNECT_DATA =      (SID = PLSExtProc)      (PRESENTATION = RO)    )  )

設定PLSQL，菜單為Tools\Prefrence

重新啟動PLSQL，可以遠端連線了

PL/SQL如何遠端連線ORACLE