- 论坛徽章:
- 0
|
看你前面C:\>tnsping eucon
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-5月 -
2011 11:42:52
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = myoracle.datadomain)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = test
3)))
OK (120 毫秒)
C:\>
然后现在的tns是:
客户端tnsname.ora中有:
eucon =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.252)(PORT=1521))
)
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=test3)
)
)
tnsping eucon一下,看看是用的哪个tns,是不是在windows上装了很多oracle?环境变量设置问题?导致没用到你现在想要的这个tns? |
|