The original address: http://blog.csdn.net/zhpsam109/article/details/727289
Modify TNsnames. ora with VI to add a local service name configuration with the following types:
 
(DESCRIPTION = = XXX

(ADDRESS_LIST =
(ADDRESS = (TCP) PROTOCOL = (HOST = 192.168.100.131) (1521) PORT =))

(CONNECT_DATA =

(= DEDICATED SERVER) (SERVICE_NAME = XXX)
)
)
 
After the configuration, use the command WQ, save and exit, and then test with TNSPing XXX, error occurs:
 
TNS-03505: Failed to resolve name
 
After a good check, the content added in tnsnames.ora above is correct and hard to understand! had to search the Internet to find a solution, just know is TNS|NAME before a space, re-open tnsnames.ora with VI, and then delete XXX in front of the space, with tnsping XXX, the problem is solved!
A small problem, toss me for a long time, ha ha!