Resolution of the ORA-12545: connection failed because the target host or object does not exist

Source: Internet
Author: User

1. error message: ORA-12545: connection failed because the target host or object does not exist

2. Problem description: After oracle is installed on the desktop, an attempt is made to connect to the local examdb database through the OEMC independent startup. The result fails and an error message is displayed.

3. Cause: in fact, this is because the Oracle installation directory e:/Oracle/ora90/Network/admin/tnsnames. the host name parameter in the ora file is not set to the correct local computer name. As a result, Oracle cannot find the local computer and an error occurs. The host parameters in my computer right-click on the desktop and the tnsnames. ora file are garbled:

 

Therefore, after the host parameter is changed to the same name as the local computer name, the Oracle program can successfully find the local computer as the target host, and then use OEMC to access the local database examdb through independent startup.

4. Tips: when installing the operating system in the future, you must give the system a local computer name without special symbols in English, do not use special characters such as Chinese characters and quotation marks. Otherwise, you may encounter problems when running professional programs such as oracle.

5. English description:

ORA-12545 connect failed because target host or object does not exist cause the address specified is not valid, or the program being connected to does not exist.

Action: Ensure the address parameters have been entered correctly; the most likely incorrect parameter is the node name. ensure that the executable for the server exists (perhaps "oracle" is missing .) if the protocol is TCP/IP, edit the tnsnames. ora file to change the host name to a numeric IP address and try again.

6. Related Articles:

(1) http://topic.csdn.net/t/20020201/09/512530.html

(2) http://www.blogjava.net/badboyryan/archive/2006/08/19/64556.html

(3) http://www.blogjava.net/absolutedo/archive/2009/02/09/253856.html

 

In comparison, there is no problem when accessing the local database independently started from Oracle on the laptop 2003 system, because tnsnames. the host parameter in the ora file is consistent with the name of my local computer, so the Oracle program can find my host accurately, as shown below:

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.