RE: Weird SCAN Issue
Date: Fri, 2 Nov 2012 09:33:36 -0700
Message-ID: <044801cdb917$cedfc410$6c9f4c30$_at_uoregon.edu>
The last time I had this happen to me, I had the local_listener messed up - I had it pointing to the -vip instead of the SCAN address.
What is your Local_Listener & Remote_listener?
~ Tyfanie Wineriter ~
Database Administrator
University of Oregon
1212 University of Oregon
Eugene, OR 97402-1212
(541) 346-1366
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Sriram Kumar
Sent: Thursday, November 01, 2012 5:41 PM
To: postora_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Weird SCAN Issue
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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 02 2012 - 17:33:36 CET