原文地址:http://blog.csdn.net/zhpsam109/article/details/727289
用VI修改tnsnames.ora增加一个本地服务名配置,类型如下:
XXX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XXX)
)
)
配置好后,使用命令wq,保存退出,然后用tnsping XXX测试,出现错误:
TNS-03505: Failed to resolve name
检查了好一次,上面tnsnames.ora中添加的内容正确无误,费解!只好上网查找解决办法,才知道是TNS|NAME前多了一个空格,重新用VI打开tnsnames.ora,然后删除XXX前面的空格,用tnsping XXX,问题解决!
一个小问题,折腾了我半天,呵呵!