469,271 Members | 1,322 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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

HI!,

Using SQL+, when i try to connect to a server giving RAC_srv as service name. It get connected, However sometimes it throws me following error.

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

But when I try to re-connect it get successfullt connected.
My tns entries are fine and I am able to connect to the both of RAC nodes.

Has anynody faced this type of problem? Does anybody had any solution for it.

Thanks,
Sep 7 '07 #1
6 42100
amitpatel66
2,367 Expert 2GB
HI!,

Using SQL+, when i try to connect to a server giving RAC_srv as service name. It get connected, However sometimes it throws me following error.

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

But when I try to re-connect it get successfullt connected.
My tns entries are fine and I am able to connect to the both of RAC nodes.

Has anynody faced this type of problem? Does anybody had any solution for it.

Thanks,
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.
Sep 7 '07 #2
debasisdas
8,127 Expert 4TB
it also might happen that the oracle service or the listener sevice in the service got hanged or the server was rebooted while u were connected.
Sep 7 '07 #3
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.

TNSNAMES.ora is been perfectly entered and tnsping works fine. I tried it in both ways: entered IP address and Host name.

It dosen't give me any problem in connecting to the Db. However, when I make frequent connections it fetches me that error. As I said when I re-connect, it goes boom boom . I have seen my connection connecting to both instances simaltenously
Sep 7 '07 #4
it also might happen that the oracle service or the listener sevice in the service got hanged or the server was rebooted while u were connected.
Rebooted??? No way, they are in front on me. And as i said .... When I re-connect it get successfully connected with the specified node and I hope rebooting requires at least some amount of time to make all services up and specially in the case of RAC to make it available.

Well regarding Oracle Service or Listener service, hang issue. I am not sure about, i think this cannot be the issue. Can you please tell me the way to check Listener or Oracle Service status, to get assured that this might not be the cause.

Thanks
Sep 11 '07 #5
debasisdas
8,127 Expert 4TB
Try to use TSNPING servicename

While the error message appears.

Also check for network connectivity with the server.
Sep 11 '07 #6
laconicamit,

Did you find a resolution to this issue? I am seeing a similar situation and am having trouble pinpointing a resolution.

Thanks
Sep 30 '11 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
reply views Thread by basmgokul | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.