IP Configuration for Oracle RAC Installation

Joy Stick · 11-09-2017, 11:31 PM

Dear Linux Experts,

I am Configuring Oracle RAC Installation on top of Vmware Workstation.

i am using 3 Vmware workstation.

PHP Code:



Host Machine : Windows 10

Vmware Machine 1 :  rac1

Vmware Machine 2 :  rac2

Vmware Machine 3 :  storage  ==> Shared Storage setup using OPEN FILER

>> Host Machine details

PHP Code:



C:\Users\Sham>IPCONFIG

 
Windows IP Configuration

 
 
Ethernet adapter Ethernet:

 
   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

 
Ethernet adapter VirtualBox Host-Only Network:

 
   Connection-specific DNS Suffix  . :

   Link-local IPv6 Address . . . . . : fe80::8147:f9b1:7521:b776%2

   IPv4 Address. . . . . . . . . . . : 192.168.56.1

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . :

 
Wireless LAN adapter Local Area Connection* 2:

 
   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

 
Ethernet adapter Ethernet 2:

 
   Connection-specific DNS Suffix  . :

   Link-local IPv6 Address . . . . . : fe80::88b5:6ad2:6929:51e4%19

   IPv4 Address. . . . . . . . . . . : 192.168.212.1

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . :

 
Ethernet adapter Ethernet 3:

 
   Connection-specific DNS Suffix  . :

   Link-local IPv6 Address . . . . . : fe80::4a0:a009:181e:2270%4

   IPv4 Address. . . . . . . . . . . : 192.168.43.2

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . :

 
Wireless LAN adapter Wi-Fi:

 
   Connection-specific DNS Suffix  . :

   IPv6 Address. . . . . . . . . . . : 2405:204:610e:e94c:cccf:bd09:7285:8869

   Temporary IPv6 Address. . . . . . : 2405:204:610e:e94c:d56d:38aa:1046:9e61

   Link-local IPv6 Address . . . . . : fe80::cccf:bd09:7285:8869%3

   IPv4 Address. . . . . . . . . . . : 192.168.43.81

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . : fe80::590e:cddb:1fba:32a2%3

                                       192.168.43.1

>> IP ADDRESS ENTRIES FOR BOTH NODES (NODE-1 & NODE-2 )

PHP Code:



# vi /etc/hosts  

  

PUBLIC IP  

###########  

  

192.168.43.60   rac1  

192.168.43.61   rac2   

  

PRIVATE IP  

##########  

  

192.168.10.1   rac1-priv  

192.168.10.2   rac2-priv  

  

VIRTUAL IP  

###########  

  

192.168.43.70   rac1-vip  

192.168.43.71   rac2-vip  

  

SCAN IP  

#######  

  

192.168.43.90   rac-scan  

192.168.43.91   rac-scan  

192.168.43.92   rac-scan

>> Screenshot

Questions and Problems ?

I am using USB 4G Internet connectivity on HOST machine.
But i am NOT getting Internet inside virtual Machine

1) How do i get Internet connectivity inside Virtual Machine ?
2) Is there any possibility to get Internet connectivity using Static IP on Linux machine ?
3) Shall i go for HOST-ONLY OPTION for eth0 and eth1 always ? - Please see the attached screenshot

@ FYI

PHP Code:



eth0 is for public IP

eth1 is for private IP

Thanks ..

TB0ne · 11-10-2017, 07:15 AM

Quote:

Originally Posted by Joy Stick

Dear Linux Experts,
I am Configuring Oracle RAC Installation on top of Vmware Workstation. i am using 3Vmware workstation.

PHP Code:



Host Machine : Windows 10
Vmware Machine 1 :  rac1
Vmware Machine 2 :  rac2
Vmware Machine 3 :  storage  ==> Shared Storage setup using OPEN FILER

>> Host Machine details

PHP Code:



C:\Users\Sham>IPCONFIG
Windows IP Configuration
Ethernet adapter Ethernet:

Ethernet adapter VirtualBox Host-Only Network:
   IPv4 Address. . . . . . . . . . . : 192.168.56.1

Ethernet adapter Ethernet 2:
   IPv4 Address. . . . . . . . . . . : 192.168.212.1

Ethernet adapter Ethernet 3:
   IPv4 Address. . . . . . . . . . . : 192.168.43.2

Wireless LAN adapter Wi-Fi:
   IPv4 Address. . . . . . . . . . . : 192.168.43.81

IP ADDRESS ENTRIES FOR BOTH NODES (NODE-1 & NODE-2 )

PHP Code:



# vi /etc/hosts  
 
PUBLIC IP  
###########  
192.168.43.60   rac1  
192.168.43.61   rac2   
  
PRIVATE IP  
##########  
192.168.10.1   rac1-priv  
192.168.10.2   rac2-priv  
  
VIRTUAL IP  
###########  
192.168.43.70   rac1-vip  
192.168.43.71   rac2-vip  
  
SCAN IP  
#######  
192.168.43.90   rac-scan  
192.168.43.91   rac-scan  
192.168.43.92   rac-scan

I am using USB 4G Internet connectivity on HOST machine. But i am NOT getting Internet inside virtual Machine

1) How do i get Internet connectivity inside Virtual Machine ?
2) Is there any possibility to get Internet connectivity using Static IP on Linux machine ?
3) Shall i go for HOST-ONLY OPTION for eth0 and eth1 always ? - Please see the attached screenshot

@ FYI eth0 is for public IP eth1 is for private IP

Going in order:

You enable bridging and define a route
Yes
That depends on what you need your machines to do

You have been working with/asking about Oracle for going on two years now (January of 2016):
https://www.linuxquestions.org/quest...322/page2.html
https://www.linuxquestions.org/quest...ng-4175617009/
https://www.linuxquestions.org/quest...se-4175613124/
https://www.linuxquestions.org/quest...0/#post5719061
https://www.linuxquestions.org/quest...2A-4175612667/
https://www.linuxquestions.org/quest...ux-4175611133/
https://www.linuxquestions.org/quest...eq-4175610987/
https://www.linuxquestions.org/quest...-x-4175594517/

You've set this up before and have said that you're an Oracle DBA....this shouldn't be a problem. If you have problems understanding routing on VMWare with Oracle, then you need to contact the VMWare support you're paying for and/or at least tell us what version of VMWare you're using. There is ample documentation concerning VMWare setup on their website.

Or are you using Virtualbox, which is **NOT** VMware??? If so...again...there is ample documentation on their website concerning network set up.

Joy Stick · 11-10-2017, 11:38 AM

Hi TBone,

You given m good support earlier.
Now a days i think you are Targeting me.

Please do NOT mind it !

I am coming to my requirement.
I have USB Internet connectivity(4G) supported.

You are saying using Private IP, we can get Internet connectivity inside Virtual Machine.

If possible please help how do i achieve this ?

PHP Code:



[root@rac1 ~]# hostname

rac1.oel5.com

 
[root@rac1 ~]# hostname -i

192.168.43.60

 
[root@rac1 ~]# ifconfig

eth0      Link encap:Ethernet  HWaddr 00:0C:29:63:39:35  

          inet addr:192.168.43.60  Bcast:192.168.43.255  Mask:255.255.255.0

          inet6 addr: fe80::20c:29ff:fe63:3935/64 Scope:Link

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:15657 errors:0 dropped:0 overruns:0 frame:0

          TX packets:17306 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000 

          RX bytes:3337625 (3.1 MiB)  TX bytes:2988441 (2.8 MiB)

          Interrupt:67 Base address:0x2024 

 
 
eth1      Link encap:Ethernet  HWaddr 00:0C:29:63:39:3F  

          inet addr:192.168.10.1  Bcast:192.168.10.255  Mask:255.255.255.0

          inet6 addr: fe80::20c:29ff:fe63:393f/64 Scope:Link

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:5876 errors:36114 dropped:0 overruns:0 frame:0

          TX packets:757 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000 

          RX bytes:536806 (524.2 KiB)  TX bytes:112074 (109.4 KiB)

          Interrupt:67 Base address:0x20a4 

 
 
eth2      Link encap:Ethernet  HWaddr 00:0C:29:63:39:49  

          inet addr:192.168.159.130  Bcast:192.168.159.255  Mask:255.255.255.0

          inet6 addr: fe80::20c:29ff:fe63:3949/64 Scope:Link

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:508 errors:0 dropped:0 overruns:0 frame:0

          TX packets:386 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000 

          RX bytes:56030 (54.7 KiB)  TX bytes:72136 (70.4 KiB)

          Interrupt:75 Base address:0x24a4 

 
 
lo        Link encap:Local Loopback  

          inet addr:127.0.0.1  Mask:255.0.0.0

          inet6 addr: ::1/128 Scope:Host

          UP LOOPBACK RUNNING  MTU:16436  Metric:1

          RX packets:3067 errors:0 dropped:0 overruns:0 frame:0

          TX packets:3067 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:0 

          RX bytes:3755046 (3.5 MiB)  TX bytes:3755046 (3.5 MiB)

 
 
[root@rac1 ~]# ping google.com

PING google.com.localdomain (216.58.196.78) 56(84) bytes of data.

64 bytes from 216.58.196.78: icmp_seq=1 ttl=128 time=65.0 ms

64 bytes from 216.58.196.78: icmp_seq=4 ttl=128 time=845 ms

64 bytes from 216.58.196.78: icmp_seq=5 ttl=128 time=106 ms

64 bytes from 216.58.196.78: icmp_seq=6 ttl=128 time=104 ms

 
 
--- google.com.localdomain ping statistics ---

6 packets transmitted, 4 received, 33% packet loss, time 5098ms

rtt min/avg/max/mdev = 65.096/280.357/845.813/326.878 ms

I am using eth2 for Internet Connectivity but the problem is NOT able to connect my Virtual Machine through Putty.

Please help me !

AwesomeMachine · 11-11-2017, 08:29 PM

It looks like you're using Virtualbox, not VMware. The easiest way to get networking working in a VM, as already mentioned, is to use bridged type. And, it looks like your netmask should be 255.255.0.0.

TB0ne · 11-14-2017, 06:40 AM

Quote:

Originally Posted by Joy Stick

Hi TBone,
You given m good support earlier. Now a days i think you are Targeting me. Please do NOT mind it !

No idea what you're saying here, but I do know that at some point, you need to start applying what you're told. You've posted a bunch of threads like this, don't answer follow-up questions, post your results, and seem to keep duplicating threads too. Setting up a 3 node RAC is different than a 2 node HOW, exactly?? Aside from just adding one other node?

You were asked if you were using VirtualBox or VMWare, as you said...you have not answered.

Quote:

I am coming to my requirement. I have USB Internet connectivity(4G) supported. You are saying using Private IP, we can get Internet connectivity inside Virtual Machine.If possible please help how do i achieve this ?

By going back and reading what you were told before, and DOING IT. Again, you need to enable bridging.

Quote:

I am using eth2 for Internet Connectivity but the problem is NOT able to connect my Virtual Machine through Putty. Please help me !

Again, you have not enabled bridging, as you were told.