PL/SQL如何远程连接ORACLE

时间:2021-11-08 22:57:56

如何在没有装ORACLE的电脑上用PLSQL远程连接ORACLE

下载instantclient,我的是WIN7,下载的是instantclient-basiclite-nt-12.1.0.1.0.zip

解压到一个固定的目录如C:\instantclient_plsql

在解压的目录里创建文件network\admin\tnsnames.ora

PL/SQL如何远程连接ORACLE

编辑文件内容,注意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

PL/SQL如何远程连接ORACLE

重新启动PLSQL,可以远程连接了