Re: Weird SCAN Issue

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Fri, 2 Nov 2012 08:41:28 +0800
Message-ID: <CAEq4C0fawy1b7nXmv2xGkhGa-R4sSP0G39O052PgQcpcC5sfqw_at_mail.gmail.com>

Hi,
check etc/hosts settings in both the nodes to start with. then look at the dns settings and route. have seen this when the listener returns back a hostname and the app server is not aware of this hostname.

best regards

sriram kumar

On Fri, Nov 2, 2012 at 6:55 AM, 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 - 01:41:28 CET