LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-20-2017, 11:59 AM   #1
Joy Stick
Member
 
Registered: Dec 2015
Distribution: RHEL 4.7
Posts: 127

Rep: Reputation: 0
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 ?
 
Old 11-20-2017, 12:40 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,935

Rep: Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021
Quote:
Originally Posted by Joy Stick View Post
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
 
1 members found this post helpful.
Old 11-20-2017, 01:30 PM   #3
MensaWater
LQ Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 7,831
Blog Entries: 15

Rep: Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668
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.
 
1 members found this post helpful.
Old 11-21-2017, 06:32 AM   #4
Joy Stick
Member
 
Registered: Dec 2015
Distribution: RHEL 4.7
Posts: 127

Original Poster
Rep: Reputation: 0
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 optionsopen
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
 
Old 11-21-2017, 07:16 AM   #5
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,935

Rep: Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021Reputation: 7021
Quote:
Originally Posted by Joy Stick View Post
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.
 
1 members found this post helpful.
Old 11-21-2017, 09:03 AM   #6
MensaWater
LQ Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 7,831
Blog Entries: 15

Rep: Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668
Quote:
Originally Posted by Joy Stick View Post
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.
 
1 members found this post helpful.
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
IP Configuration for Oracle RAC Installation Joy Stick Linux - Newbie 4 11-14-2017 06:40 AM
Oracle on RHEL 6.4 without RAC xenner Linux - Server 7 02-13-2014 11:48 AM
[SOLVED] Anyone doing Oracle RAC on Linux? MensaWater Linux - Server 1 04-15-2010 01:31 PM
RHAS 3.0 i64, Oracle 10g, Oracle RAC, and ASM xmdms Linux - Enterprise 10 01-05-2007 11:07 PM
Oracle Rac I0g waqar Solaris / OpenSolaris 1 03-16-2006 11:08 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:07 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration