SCAN IPs in RAC environment that uses hosts file

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

SCAN IPs in RAC environment that uses hosts file

Postby gtz91 » Sun Jan 13, 2013 12:06 pm

Hi Tim,

I followed your 11gr2 RAC on OEL5 using Virtualbox (http://www.oracle-base.com/articles/11g ... ualbox.php) article. Is it correct that after the installation, only 1 SCAN ip will be enabled (hence, only 1 SCAN Listener will be active too)? Is this because we are using hosts file instead of DNS?

Thanks.

Regards,
Ging
gtz91
Member
 
Posts: 5
Joined: Sun Jan 13, 2013 11:49 am
Location: Manila, Philippines

Re: SCAN IPs in RAC environment that uses hosts file

Postby Tim... » Sun Jan 13, 2013 1:04 pm

Hi.

If you are installing 11.2.0.1 and using the hosts file, then only 1 SCAN listener will be started.

If you are using 11.2.0.3, you need to use DNS. If you use DNS, then you will have as many SCAN listeners as addresses the DNS resolves to. If the DNS resolved to 3 round-robin addresses, then you will have 3 scan listeners.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: SCAN IPs in RAC environment that uses hosts file

Postby gtz91 » Sun Jan 13, 2013 1:07 pm

Yes, it is 11.2.0.1.

Thanks for the quick reply! :)
gtz91
Member
 
Posts: 5
Joined: Sun Jan 13, 2013 11:49 am
Location: Manila, Philippines

Re: SCAN IPs in RAC environment that uses hosts file

Postby Tim... » Sun Jan 13, 2013 1:47 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: No registered users and 1 guest

cron