pl/sql远程访问oracle数据库的问题

pl/sql远程访问oracle数据库的问题

安装oracle9i 客户端软件。安装完成后有tnsnames.ora 有这么一个文件打开本文件文件内容如下：

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)

ORACLEBCV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.81.100.136)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = scbus)
)
)
REPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 9.83.70.14)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = report)
)
)

在上面添加远程服务器的配置内容。如下所示：

ZTXG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.27)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ztxg)
)
)
ZTPB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.114)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ztpb)
)
)

配置服务器名，服务器的IP，服务器 ，服务器的名字。

保存后既在pl/sql的界面中出现

Database 的远程服务器上数据库的提示：

就可以对远程的数据库进行操作了。

所用的pl/sql 和oracle客户端必须正确的安装。而且版本也必须适合。