Re: Strange RAC behaviour

Hi,

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 tnsnames.ora.

i am assuming that you are not using FAN, Connection pools, etc...

cheers
anand

On 13/01/06, johan Eriksson wrote:
>
> Hi all
>
> 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?
>
> /johan
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Received on Fri Jan 13 2006 - 11:35:53 CST