LinuxQuestions.org - IP Configuration for Oracle RAC

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - IP Configuration for Oracle RAC (https://www.linuxquestions.org/questions/linux-newbie-8/ip-configuration-for-oracle-rac-4175618004/)

IP Configuration for Oracle RAC

Dear Experts ,

I am managing Single Instance Oracle Database
I have Installed Oracle RAC Database.

To install RAC, We need to configure Public,Private and Virtual IPs for both nodes. I am NOT using DNS setup.

IS it mandatory or highly recommended to configure different classes for Public and Private IP ?

>> IS this perfectly OK or Any changes are required ?

PHP Code:




# cat /etc/hosts 
 
# Do not remove the following line, or various programs 
# that require network functionality will fail. 
127.0.0.1       localhost.localdomain localhost 
#::1            localhost6.localdomain6 localhost6 
  
# PUBLIC 
192.168.212.60   rac1.oel5.com   rac1 
192.168.212.61   rac2.oel5.com   rac2 
  
# PRIVATE 
192.168.10.1   rac1-priv 
192.168.10.2   rac2-priv 
  
# VIRTUAL 
192.168.212.70 rac1-vip.oel5.com  rac1-vip 
192.168.212.71 rac2-vip.oel5.com  rac2-vip 
  
# SCAN 
192.168.212.90   rac-scan 
192.168.212.91   rac-scan 
192.168.212.92   rac-scan

Thanks.

Especially Question for Public and Private IPs setting for Oracle RAC Database ?

Quote:

Originally Posted by Joy Stick (Post 5783033)

Dear Experts ,
I am managing Single Instance Oracle Database I have Installed Oracle RAC Database. To install RAC, We need to configure Public,Private and Virtual IPs for both nodes. I am NOT using DNS setup. IS it mandatory or highly recommended to configure different classes for Public and Private IP ? IS this perfectly OK or Any changes are required ?

PHP Code:




# cat /etc/hosts 
 
# Do not remove the following line, or various programs 
# that require network functionality will fail. 
127.0.0.1       localhost.localdomain localhost 
#::1            localhost6.localdomain6 localhost6 
  
# PUBLIC 
192.168.212.60   rac1.oel5.com   rac1 
192.168.212.61   rac2.oel5.com   rac2 
  
# PRIVATE 
192.168.10.1   rac1-priv 
192.168.10.2   rac2-priv 
  
# VIRTUAL 
192.168.212.70 rac1-vip.oel5.com  rac1-vip 
192.168.212.71 rac2-vip.oel5.com  rac2-vip 
  
# SCAN 
192.168.212.90   rac-scan 
192.168.212.91   rac-scan 
192.168.212.92   rac-scan

Especially Question for Public and Private IPs setting for Oracle RAC Database ?

This sounds VERY familiar:
https://www.linuxquestions.org/quest...on-4175617321/

Again, as an Oracle DBA, you should be very familiar with how to configure/set up Oracle RAC. As you've also been told before, Oracle RAC is not a free product, and since you're using it (as an Oracle DBA), you are paying for it..have you contacted support, or read the Oracle documentation on their best-practices?
http://www.oracle.com/technetwork/ar...si-088677.html
https://docs.oracle.com/cd/B28359_01...c.htm#TDPRC003

When we set it up here we had the PUBLIC (individual node physical IPs), the VIPs and the SCAN IPs all in the same network (VLAN). Only the Private (interconnect IPs) were in a separate network.

The VIPs and SCAN IPs are virtual IPs that can float from one node to another so it is best to have them in the same VLAN as the nodes' main IPs. In a two node setup you would typically have one VIP on each node then 2 scan IPs on one node and the 3rd scan IP on the other node. In a failover the VIP and SCAN IPs on the node that went down will come up on the node that is still up so you'd end up with both VIPs and all 3 SCAN IPs on a single node and until you did fail back.

Hi

But my question is,

1) If i assign all IPs from same network,then any problem ?
2) Why do we need to specify different network for Private IP ?

>> On both nodes i assigned same network , but same time RAC configuration done - NO Problem.

PHP Code:




$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost

# PUBLIC
192.168.233.42   rac1  rac1.oracle.com
192.168.233.43   rac2  rac2.oracle.com

# PRIVATE
192.168.233.72       rac1-priv
192.168.233.73       rac2-priv

# VIRTUAL
192.168.233.52       rac1-vip
192.168.233.53       rac2-vip

# SCAN
192.168.233.101     rac-scan
192.168.233.101     rac-scan
192.168.233.103     rac-scan

PHP Code:




$ srvctl config database -d ORCL
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/11.2.0/db_home
Oracle user: oracle
Spfile: +DATA/orcl/spfileorcl.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: DATA,RECO
Services: 
Database is administrator managed

THANKS

Quote:

Originally Posted by Joy Stick (Post 5783346)

Hi
But my question is,

1) If i assign all IPs from same network,then any problem ?
2) Why do we need to specify different network for Private IP ?

On both nodes i assigned same network , but same time RAC configuration done - NO Problem.

Our questions are:

You say you're an Oracle DBA, so why do you not know how to configure Oracle?
Why have you not checked the best-practices/installation instructions for Oracle RAC, FROM ORACLE, to see what you should do/avoid?
You say "RAC Configuration done - NO problem"...if there is no problem, why post?

The answers to your questions are in the Oracle documentation which you were handed before.

Quote:

Originally Posted by Joy Stick (Post 5783346)

Hi
1) If i assign all IPs from same network,then any problem ?
2) Why do we need to specify different network for Private IP ?

The private IPs are used for traffic between the RAC/GRID nodes only. As TB0ne points out the Oracle documentation has detail about this. Briefly the reason you want your Private IPs on a separate network is because it reduces the chance of issues due to other traffic on the same network. The documentation as I recall specifically suggests that you do this interconnect through a switch because direct connection is actually too fast.

Also just to note on the scan IPs - I'm not sure you can do those without DNS. The idea of scan IPs is that you tell any application that needs to reach the database the scan name and on doing lookup they will see the 3 IPs (in a 2 node setup) you assigned to scan and use any one of those. This is why the IPs failover when a node goes down.

From other servers do NOT point to your database via the VIP or Public (or Private which shouldn't be possible). Only point to it via the scan name. This insures things pointing to the database continue to work in failover.

Setting up RAC/GRID is non-trivial so you really do need to review the documentation before you start.