Home
Trouble shooting
 

Cry about...
Oracle Troubleshooting

ORA-12545: Connect failed because target host or object does not exist

Symptom:

When trying to connect to Oracle the following error is generated:

ORA-12545: Connect failed because target host or object does not exist

Cause:

Oracle suggest that this error indicates that the address specified (in the alias definition) is not valid.

Possible Remedies:

  • Oracle suggest 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.