plsql连接远程oracle home怎么设置

Answer 1

1下载instantclient，我的是WIN7，下载的是instantclient-basiclite-nt-12.1.0.1.0.zip
2解压到一个固定的目录如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)
)
)
3设置PLSQL，菜单为Tools\Prefrence
4
重新启动PLSQL，可以远程连接了