|
|
ORA-12545: Connect failed because target host or object does
not exist tips
Oracle Error Tips by Donald Burleson
|
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.
Please advise on how I can get this to work?
Answer: Use
oerr to look up the ORA-12545 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.
I would start to debug a ORA-12545 error with these steps:
- making sure that your listener is running (lsnrctl stat)
- verifying connectivity via the DNS (e.g. /etc/hosts)
- make sure to check your tnsnames.ora parms.
Also see MOSC notes (http://support.oracle.com) on the ORA-12545 error:
-
Note 284909.1 - Intermittent ORA-12545 When
Trying To Connect To RAC Database
-
Note 364855.1 - RAC Connection Redirected To
Wrong Host/IP ORA-12545
-
Note 291175.1 - Clients Failing to Connect Due to
Intermittent ORA-12545 in RAC Environment
-
Note 333159.1 - ORA-12545 Frequent Client
Connection Failure - 10g Standard RAC