plsql连接远程oracle并导出,用PLSQL远程连接Oracle数据库

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地址和端口也要配置正确。

2、配置完成后，Oracle客户端应该可以连接到远程Oracle 数据库上。