RE: Weird SCAN Issue
- From: "Tyfanie Wineriter" <tyfaniew@xxxxxxxxxxx>
- To: <postora@xxxxxxxxx>
- Date: Fri, 2 Nov 2012 09:33:36 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sriram Kumar
Sent: Thursday, November 01, 2012 5:41 PM
To: postora@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxx: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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
