# tnsnames.ora Network Configuration File: D:\Program2\oracle2\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORCL_255.255.255.255 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 255.255.255.255)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 255.255.255.255)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)在用oralce 10g 客户端 连接服务器的时候 出现得错误 无法解析连接描述符中指定的SID
是不是 配置有问题么》?
# Generated by Oracle configuration tools.ORCL_255.255.255.255 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 255.255.255.255)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 255.255.255.255)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)在用oralce 10g 客户端 连接服务器的时候 出现得错误 无法解析连接描述符中指定的SID
是不是 配置有问题么》?
那就把文字全部删除,启动Net Configuration Assistant去创建一个网络服务名。
就可以了
好奇怪,像你说的, 我吧那个网络名 和 SID 的 写成一样就搞掂了, thx all
C:\Windows\system32>tnsping MYORACLETNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 10-5月 -2012 09:29:38Copyright (c) 1997, 2005, Oracle. All rights reserved.已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = thinkpad)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATE
D) (SERVICE_NAME = myoracle)))
OK (60 毫秒)C:\Windows\system32>tnsping MYORACLE_255.255.255.255TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 10-5月 -2012 09:30:42Copyright (c) 1997, 2005, Oracle. All rights reserved.已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = thinkpad)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATE
D) (SERVICE_NAME = myoracle)))
OK (40 毫秒)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = thinkpad)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myoracle)
)
)MYORACLE_255.255.255.255 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = thinkpad)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myoracle)
)
)