PL/SQL Developer

远程连接Oracle数据库

1、????配置服务器tnsnames.ora文件，如果本机上没有安装oracle，可以从安装了oracle的机上拷贝一个(tnsnames.ora文件)放在指定目录下，因为我已安装oracle，所以直接配置该文件。

# tnsnames.ora Network Configuration File: D:\Oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

??????

LISTENER_ORCL =

??(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

?

ORACLR_CONNECTION_DATA =

??(DESCRIPTION =

????(ADDRESS_LIST =

??????(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

????)

????(CONNECT_DATA =

??????(SID = CLRExtProc)

??????(PRESENTATION = RO)

????)

??)

?

ORCL =

??(DESCRIPTION =

????(ADDRESS = (PROTOCOL = TCP)(HOST =?192.168.25.224)(PORT = 1521))

????(CONNECT_DATA =

??????(SERVER = DEDICATED)

??????(SERVICE_NAME =?orcl)

????)

??)

orcl为远程Oracle数据库的实例名，IP地址和端口也要配置正确。