首先要保证网络畅通,然后在Windows OS的机器上配置 TNSNAME.ORA 文件U_TNSNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = linux下oracle9的服务名)
)
)然后就可以通过UserID/Password@U_TNSNAME访问linux下oracle9。
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = linux下oracle9的服务名)
)
)然后就可以通过UserID/Password@U_TNSNAME访问linux下oracle9。
然后通过Net Configuaration工具添加服务(服务名,Linux Oracle所在的IP,SID,端口等等)
然后在PLSQL工具选择服务名
输入User/Passwd就行了