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

[laconicamit]

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,

[amitpatel66]

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.

[debasisdas]

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.

[laconicamit]

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

[laconicamit]

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

[debasisdas]

Try to use TSNPING servicename

While the error message appears.

Also check for network connectivity with the server.

[jcsnowden821]

laconicamit,

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

Thanks