ORA-12454: connect failed because target host or object
does not exist tips

Oracle Error Tips by Stephanie F

The Oracle docs note this on the ora-12454 error:

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.

On
Oracle DBA Forums, a user posts about having problems connecting on local
workstation options to a new database. Below are the specifics of the question,
as well as the original conflicts with ORA-12545:

Question

I have Oracle 9i installed on my local
Windows XP workstation that will be used for local development only.
Now I am trying to create a database and using OEM Database Configuration
Assistant.I put in FirstDB for the Global Database Name and put in
FirstDB for the SID.

I completed the wizard and set up my
tnsnames.ora file with the SID and hostname. Then I tried to
connect using OEM with the Sys login and it says:ORA-12545:Connect
failed because target host or object does not exist.

Should I put in
localhost or 127.0.0.1 for my Global Database Name?

I
assume I connect as Sys or System and the password I created right after
creating the database.

Note:This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.

Verify
experience!Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.

Errata? Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just e-mail:
and include the URL for the page.