Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed oracle database 11g enterprise edition to my laptop. When I was installing oracle, at the beginning I selected Desktop Class (not server class) option.

Now I am trying to make remote connection to my Oracle database from another PC but I cannot connect to Oracle and get this error message:

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

even though all Oracle services have been already started.

May the reason be why I installed Oracle as desktop class instead of server class?

share|improve this question

migrated from Feb 7 '14 at 22:26

This question came from our site for professional and enthusiast programmers.

Can you paste the TNS description. Seems, you connect to the database from your laptop itself.ORA-12545 probably mean, the host (ip specified in ur connection details) is invalid. – OracleUser Feb 7 '14 at 17:02
did you try tnsping? – OldProgrammer Feb 7 '14 at 19:19
Are you trying to connect to an existing database, or are you assuming the installer created one for you? – Phil Feb 8 '14 at 8:31
Have you checked the firewall is off? – Peter Aug 20 '14 at 8:53

Start with the basics.

  • Make sure you have a network connection that is listening on a public IP.

  • Then make sure it is reachable. Unless you like totally outdated windows versions your computer has a firewall that will kill all incoming traffic unless told not to.

It also helps to read. As per your tnsnames.ora....


Ah, so - the other computer tries to reach a database on localhost, which is himself, not your laptop? Now that will not work... per definition. I suggest changing the tnsnames.ora file to something - sensible.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.