Re: Weird SCAN Issue

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Fri, 2 Nov 2012 14:04:59 +0100
Message-ID: <CALH8A90zmSbzbk-_oZRgVtJXbSvQtj2GaSB8Eu+SU1TqaPw2HA_at_mail.gmail.com>

Steven,
can you please tell us the 'local_listener' configuration of all of your instances?
If there is a hostname defined, can you please check if you can do a 'nslookup' for exactly that hostname on all of your appNodeX servers?

also the content of /etc/resolv.conf of all your appNodeX servers might help.

thank you,
 Martin

On Thu, Nov 1, 2012 at 11:55 PM, Steven Andrew <postora_at_gmail.com> wrote:

> All,
> Anyone seen this behavior before. We are on 11.2.0.3 EE 2 Node RAC, RH 5.8
>
> We have 2 app nodes (node1 and node2) where we are testing connectivity to
> newly setup 2 Node RAC cluster.
>
> From appNode1, if i connect either via SCAN FQDN via sqlplus
> user/pass_at_SCAN.FQDN:port/service , it throws ORA-12545: Connect failed
> because target host or object does not exist. However, if try the same from
> appNode2, it works!
>
> I tried even with all 3 SCAN ip from appNode1, no luck.
>
> If i connect to dbnode1-vip (local listener) instead of SCAN from appNode1,
> it connects just fine.
>
> What is that am i missing here.
>
> SCAN/listener logs don't give much to troubleshoot this.
>
> Note: I have made sure the services are listening on the said SCAN and also
> the local listeners.
>
> Thanks,
> Steven
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 02 2012 - 14:04:59 CET