在两个不同的服务器上有两个不同的数据库,一个是oracle10,一个是oracle7的,两个都是cs程序,而且服务名都为orcl,现在在同一机子上安装了两个客户端,但只能上一个程序。求解决方法。
我在TNSNAMES.ORA配置过两个的路径,如在安装了7的客户端后,配置为:
orcl.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.200)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.200)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Test.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.24)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.24)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
环境变量设置都指向了这里,但就是只能上7的,不能上10的。
我在TNSNAMES.ORA配置过两个的路径,如在安装了7的客户端后,配置为:
orcl.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.200)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.200)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Test.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.24)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.24)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
环境变量设置都指向了这里,但就是只能上7的,不能上10的。
tnsping orcl.world
的结果,确认使用你配置的tnsnames.ora文件进行解析
17:00:35Copyright (c) Oracle Corporation 1995. All rights reserved.Attempting to contact (ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=192.168.
0.200)(Port=1521))
确定(10 毫秒)C:\Documents and Settings\Administrator>tnsping test.worldTNS Ping Utility for 32-bit Windows: Version 2.3.4.0.0 - Production on 31-MAR-09
17:00:37Copyright (c) Oracle Corporation 1995. All rights reserved.Attempting to contact (ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=192.168.
0.24)(Port=1521))
确定(10 毫秒)是不是这个啊?我初学,不太懂。