QAID # 13912 Published
Question / Problem:
The following error occurs on some workstations:
ORA-12545 ERROR. CONNECT FAILED BECAUSE TARGET HOST OR OBJECT DOES NOT EXIST.
What could be the cause?
Answer / Solution:
This is an Oracle error usually encountered in Validation or Export when referencing an Oracle Home that is not listed in TNSNAMES.
It could simply be an incomplete Oracle client installation. Please consult the Oracle DBA to complete or fix the client installation.
When trying to connect to Oracle the following error is generated:
ORA-12545: Connect failed because target host or object does not exist
Oracle suggests that this error indicates that the address specified (in the alias definition) is not valid.
- Oracle suggests ensuring that the ADDRESS parameters (in the TNSNAMES.ORA file) 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.
- It could be a network connectivity problem. Try pinging the host. This error has been observed on a laptop when the database was local, TCP/IP protocol used, but the network card had been removed.