tns-03505:failed to resolve name--Careless Error!

Source: Internet
Author: User

April busy changing jobs, has not written a blog.

New company, database server is using Hpunix, last night with VI modify Tnsnames.ora add a local service name configuration, the type is as follows:

XXX =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.100.131) (PORT = 1521))
)
(Connect_data =
(SERVER = dedicated)
(service_name = XXX)
)
)

After the configuration, use the command Wq, save the exit, and then use the tnsping XXX test, there is an error:

tns-03505:failed to resolve name

Check a good time, the above Tnsnames.ora added content is correct, inexplicable. Had to find a solution on the Internet, only to know is tns| Name more than a space, re-open Tnsnames.ora with VI, and then delete the space before xxx, with tnsping xxx, solve the problem.

A small problem, toss me half a day, hehe.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.