Strange RAC behaviour 2006-01-13 - By Anand Rao
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 <johan.eriksson@(protected)> 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 (See ORA-12545.ora-code.com): 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
>
>
>
Hi,<br><br>check your tnsnames.ora on the client pc as well as the server side
for both instances. <br><br>have you defined service_names in spfile or init
.ora? this value should exactly match service_name in tnsnames.ora.
<br><br>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.<br><br>are you using local
_listener and remote_listener parameters? if you do, ensure they are all
resolvable using
tnsnames.ora.<br><br>i am assuming that you are not using FAN, Connection pools
, etc...<br><br>cheers<br>anand<br><br><div><span class="gmail_quote">On 13/01
/06, <b class="gmail_sendername">johan Eriksson</b> <<a href="mailto:johan
.eriksson@(protected)">
johan.eriksson@(protected)</a>> wrote:</span><blockquote class="gmail_quote
" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
padding-left: 1ex;">Hi all<br><br>I have a problem with our RAC env. which I
cant figure out.
<br><br>Oracle is 10r2 and the OS is RHEL 3 and we have 2 nodes in the RAC.<br>
<br>If i from machine 1 connects to rac1, rac2 it works and if I connect to<br
>rac I am switched between the nodes as expected.<br>The same is for machine 2.
<br><br>But if I connects from my pc (oracle 10r2 here also) and try to connect
<br>to rac I alway gets into rac2, but 40% of the times I get the message:<br
>ORA-12545 (See ORA-12545.ora-code.com): Connect failed because target host or object does not exist
<br><br>which I intertpret as it tries to log me onto rac1 but fails to do so.
<br><br>Am I right in my assumption and where to start solve the problem?<br><br
>/johan<br>--<br><a href="http://www.freelists.org/webpage/oracle-l">
http://www.freelists.org/webpage/oracle-l</a><br><br><br></blockquote></div><br>
|
|
