LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
LinkBack Search this Thread
Old 02-11-2014, 07:11 PM   #1
xenner
Member
 
Registered: Jul 2009
Location: Brisbane
Distribution: RHEL 6.5
Posts: 39

Rep: Reputation: 0
Oracle on RHEL 6.4 without RAC


Good day helpful forum users!

I am tasked with coming up with a solution to an Oracle migration from physical hardware to VMWare.

I have to come up with a number of different methods for the configuration on RedHat for HA.

My question to you is... Has anyone done this migration before? I am after your experience, any documentation you've read, any assistance at all.

I'm hoping to avoid the price overhead of having Oracle RAC for HA, so I was hoping to use RedHat clustering with a Quorum disk of sorts. I'm assuming we use GFS with this, but I'm wondering if anyone has done this before? And is there any performance hits you've noticed? Currently, the Oracle DBAs have four physical machines running 'packages' which are redundant across the four nodes... I'm hoping to add some HA over the top, but in VMWare, as we all know that DBA's are concerned with lots of things... If I can give them a 'feature' they don't currently have, that would be awesome.

Please, ask questions of me, send me your advice, or anything that might point me in the direction of white papers etc... I have googled this, and there's not a lot that I could find, it all leads back to using RAC etc.

Thank you!!

Xen.
 
Old 02-11-2014, 08:58 PM   #2
anomie
Senior Member
 
Registered: Nov 2004
Location: Texas
Distribution: RHEL, Scientific Linux, Debian, Fedora, FreeBSD
Posts: 3,925
Blog Entries: 5

Rep: Reputation: Disabled
xenner, I appreciate an adventurous spirit, but I don't think this is a good idea (in the sense that Oracle is all but certain to refuse to support it).

If your goal is HA (Oracle RAC does more than just HA, as you may know), you may wish to explore the "Data Guard" extension, for use with a standby server.
 
1 members found this post helpful.
Old 02-11-2014, 09:38 PM   #3
John VV
Guru
 
Registered: Aug 2005
Posts: 12,061

Rep: Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573Reputation: 1573
Also if Oracles 12g DB is a must use
it would be wise to run it on Oracles clone of RHEL ( Oracle Enterprise Linux 6 )

it is explicitly optimized and configured to run the Oracle db

and runs that db the fastest
 
1 members found this post helpful.
Old 02-12-2014, 12:22 AM   #4
xenner
Member
 
Registered: Jul 2009
Location: Brisbane
Distribution: RHEL 6.5
Posts: 39

Original Poster
Rep: Reputation: 0
Hi guys,

Thank you for your response. It's very much appreciated.

I will look into Oracle's clone of RHEL, and see what I can discover.

I'm certain I've worked at a company that had all native RHEL clustering with a quorum disk, and Oracle supported it... It was, however, all physical, no VM's involved. Perhaps that's the catch?

We are looking for an alternative to RAC, which is what spawned this question. I will also look into "Data Guard".

Thank you both for your assistance.... Any further information would be helpful also. I'll see if I can contact the old employer and they might be able to shed light on what they actually had in place... I will paste their response here.

Thank you.
 
Old 02-12-2014, 08:37 AM   #5
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 13,766

Rep: Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346
Quote:
Originally Posted by xenner View Post
Hi guys,
Thank you for your response. It's very much appreciated. I will look into Oracle's clone of RHEL, and see what I can discover.

I'm certain I've worked at a company that had all native RHEL clustering with a quorum disk, and Oracle supported it... It was, however, all physical, no VM's involved. Perhaps that's the catch?

We are looking for an alternative to RAC, which is what spawned this question. I will also look into "Data Guard".

Thank you both for your assistance.... Any further information would be helpful also. I'll see if I can contact the old employer and they might be able to shed light on what they actually had in place... I will paste their response here.
We did use Oracle in a VM environment at a place where I worked a few years back...the difference between 'physical' and 'virtual' servers these days is trivial. However, if you are in a corporate environment, and are using both RHEL and Oracle, you need to pay for support from BOTH of them, and take this question to your sales/tech reps at both vendors. Trying to cobble together something for an HA database solution for a company seems like a recipe for disaster.

Check out the Oracle guides:
http://docs.oracle.com/cd/E11882_01/...e.htm#CHDGGBFI

You can use ASM without RAC, but you can also probably use DRDB from Linux as well, or use BCV snapshotting on your SAN (if it supports that feature). Personally, if I was the administrator, I'd not play around...use RAC and enjoy the benefits. As said, it's more than just HA.
 
1 members found this post helpful.
Old 02-13-2014, 12:03 AM   #6
xenner
Member
 
Registered: Jul 2009
Location: Brisbane
Distribution: RHEL 6.5
Posts: 39

Original Poster
Rep: Reputation: 0
Hi,

I was referring to support with the "Physicals vs virtual" comment.

I have brought Red Hat to the table and asked the question. Once they give me a response, I'll send that to Oracle and see what they say. Then, I'll post the response on here.

But yes, I would prefer to use RAC, but it all depends on funding. If there's a cheaper method that is supported, the business would prefer to use that. But the catch word is "supported".

Thank you for your assistance! It's awesome and appreciated.

**Insert smiley faces of appreciation here**
 
Old 02-13-2014, 09:25 AM   #7
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 13,766

Rep: Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346Reputation: 2346
Quote:
Originally Posted by xenner View Post
Hi,
I was referring to support with the "Physicals vs virtual" comment.

I have brought Red Hat to the table and asked the question. Once they give me a response, I'll send that to Oracle and see what they say. Then, I'll post the response on here.

But yes, I would prefer to use RAC, but it all depends on funding. If there's a cheaper method that is supported, the business would prefer to use that. But the catch word is "supported".
Well, DRDB may work, but all that'll really buy you is the ability to use heartbeat to fail over to another DB server, in the event the primary dies. You'll still have a short period of downtime, and if that server starts to strain under the load, you'll have to build another, faster box. RAC avoids all those issues.

The 'business' would ALWAYS want to have a $5 solution which involves the admin sleeping under their desk to keep things going, rather than spending $50 on something that works reliably. Honestly, if funding is that much of an issue for them, they need to use CentOS and MySQL (which are FREE), and learn to live with any downtime. But if their business is important and they want to go 24/7, then they need to pony up the $$$ to do it. Trying to lowball things like this is never a good idea. My typical question would be "Ok, you'll save $XXX by doing this, but how much are you going to lose when your system is down for YYY time?".
 
1 members found this post helpful.
Old 02-13-2014, 11:48 AM   #8
grim76
Member
 
Registered: Jun 2007
Distribution: Debian, SLES, Ubuntu
Posts: 254

Rep: Reputation: 40
Oracle's stance used to be that if you were virtualizing Oracle DB you were fully supported if you were on their virtualization platform. In the event that you decided to move to VMware or something else. They would support you to the OS that Oracle was installed on and go no further.
 
1 members found this post helpful.
  


Reply

Tags
clustering, gfs, oracle rac, red hat, vmware


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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Anyone doing Oracle RAC on Linux? MensaWater Linux - Server 1 04-15-2010 01:31 PM
Oracle 9i RAC Install on Linux AS gordib259 Linux - Software 2 06-01-2007 10:02 AM
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
Install Oracle Rac on RHEL 4 on a Dell machine masand Linux - Enterprise 0 01-16-2006 01:00 AM


All times are GMT -5. The time now is 02:35 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration