Re: Strange RAC behaviour
check your tnsnames.ora on the client pc as well as the server side for both instances.
have you defined service_names in spfile or init.ora? this value should exactly match service_name in tnsnames.ora.
what about the port id's? ensure that you have got them right on all sides. i feel there is a mismatch in the tnsnames.ora on one side. also, check if your sqlnet.ora is consistent on both sides.
are you using local_listener and remote_listener parameters? if you do, ensure they are all resolvable using
i am assuming that you are not using FAN, Connection pools, etc...
On 13/01/06, johan Eriksson <
I have a problem with our RAC env. which I cant figure out.
Oracle is 10r2 and the OS is RHEL 3 and we have 2 nodes in the RAC.
If i from machine 1 connects to rac1, rac2 it works and if I connect to
rac I am switched between the nodes as expected.
The same is for machine 2.
But if I connects from my pc (oracle 10r2 here also) and try to connect
to rac I alway gets into rac2, but 40% of the times I get the message:
ORA-12545: Connect failed because target host or object does not exist
which I intertpret as it tries to log me onto rac1 but fails to do so.
Am I right in my assumption and where to start solve the problem?