Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error message ORA-12545 during remote connect

I am getting the error ORA-12545: "Connect failed because target host or object does not exist" while connecting remotely to the Oracle 8i 1.7 database. Since I have shifted the database to a new server machine, the clients are unable to connect to it. But the database is working fine locally.

Can you please help me out, as I am getting the error Ora-12545: "Connect failed because target host or object does not exist" while connecting remotely to the Oracle 8i 1.7 database.

Since I have shifted the database to a new server machine, the clients are unable to connect to it. But the database is working fine locally.

Steps taken so far:

  1. I have made sure that listener service is up and running.
  2. I have made sure that the settings for SID, port and Address are the same in my tnsames.ora and server listener and tnsnames.
  3. I restarted the listener service.

Very interestingly, after doing the third step clients happen to connect but after opening a few sessions, or when the database server is rebooted or even if the services window of the server is closed and opened a number of times, the same error message again comes back.

Does it have something to do with the Dedicated/Shared mode setting of the server?

This error message indicates that a hostname cannot be resolved to an IP address. If you are using a multi-threaded server, this problem does occur on occasion and it has to do with connection redirects between the listener and the client.

One way to resolve this is to use the server's IP address in the listener.ora rather than hostname. A better way is to add the server's IP address, hostname and fully qualified domain name to the name resolution method that the network is using. If this is not possible, add this information instead to the client machine's hosts file.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close