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

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: