Re: Alias VIPS to SCAN

At first sight I think it will work, but probably you will get some delay when the scan is down as your client will retry the connection (failing over to oldserver2-vip).
But keep in mind that you need an 11.2 client / libarary to be able to work with scan (and failover correctly), so it could be that you need to upgrade the application anyway.

Despite it will probably work, I would advice to change the configuration and use the scan directly as these quick fixes like aliases have a bad habit of coming back to bite you in the butt.

Kind regards,

-- 
Freek D'Hooge
Exitas NV
Senior Oracle DBA
email: freek.dhooge_at_exitas.be
tel +32(03) 443 12 38
http://www.exitas.be 

On wo, 2014-04-30 at 15:40 +1000, Stojan Veselinovski wrote:


> Hi All,

> 

> 

> 

> We are in the process of looking at migrating some older legacy RAC

> systems to a new 12C GI on Solaris T4.  One of the challenges we are

> facing is getting any level of application change including connect

> strings.

> 

> 

> A proposal we are looking at is to alias the old vips to point to the

> new SCAN. The thinking is all should work ok behind the scenes without

> much change.  Haven't really got my head across what happens with

> failover and load balancing or even if its doable.  It'll look

> somethign like this

> 

> 

> oldserver1-vip   oldserver2-vip

>        |                      | 

> 

>         |                    |

>          |                  |

>         12C-RAC-SCAN

>           

> 

> 

> Any thoughts?

>   

> 

> -- 

> 

> Stojan

> 

> www.stojanveselinovski.com/blog

> 

> www.stojanveselinovski.com



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