给你个例子:
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.1.177) ---这是oracle8 机子上的IP
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.1.177)---这是oracle8 机子上的IP
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)---这是要连接oracle8 的实例名
)
)
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.1.177) ---这是oracle8 机子上的IP
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.1.177)---这是oracle8 机子上的IP
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)---这是要连接oracle8 的实例名
)
)
在7的SQLPLUS里 CONNECT SYSTEM/MANAGER@TEST 就可以连上了
其中ip地址采用oracle8的,测试成功后,
在客户端的sqlplus下,system/manager@your_host_8;