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
address specified is not valid, or the program being
connected to does not exist.
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
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:
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
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:
failed because target host or object does not exist.
Should I put in
localhost or 127.0.0.1 for my Global Database Name?
assume I connect as Sys or System and the password I created right after
creating the database.
Please advise on how I can get this to work?
The replier advised two actions to begin resolving
ORA-12545, starting by:
- making sure that your listener is running (lsnrcrl stat)
- testing connectivity with
ping, and then tnsping.
- verifying connectivity via the DNS (e.g. /etc/hosts)
- make sure to check your tnsnames.ora parms.
Also important in resolving ORA-12545 if using
VIP's is to "start by verifying connectivity via the DNS (e.g. /etc/hosts), and
make sure to check your tnsnames.ora parms."
Here is a helpful link to offer more
troubleshooting connectivity errors.