Solved

Is "Single Node RAC" supported on Amazon EC2?

Posted on 2014-04-29
7
362 Views
Last Modified: 2014-12-06
Hi Everyone,

I'm evaluating new ideas to host our infrastructure, and I wanted to know if anyone has tried Oracle "Single Node" RAC on Amazon EC2?  I'm aware that multi-node RAC is NOT supported, but I can't find any reason why single-node wouldn't work.

Does anyone have experience in this, and can possibly point me towards a white paper?

Thanks.
Greg.
0
Comment
Question by:Greg Clough
  • 3
  • 2
7 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40032606
I've been trying to find something definitive for you on this when I saw it come in last night.

Sorry but I haven't been able to locate a specific paper other than what you have likely found:
http://www.oracle.com/technetwork/topics/cloud/faq-098970.html#RAC

If EC2 cannot support clustering the I would say even RAC One Node is out since it still requires a 'cluster' even if it is a cluster of one node.
0
 
LVL 6

Author Comment

by:Greg Clough
ID: 40033035
True... and it seems like you're finding the vacuum that I am.  Single-node RAC, whilst technically running a cluster doesn't require the Cluster Interconnect, nor a Shared Disk Array... and from what I know these are the roadblocks to running RAC (supported) on AWS.  There are folks doing it by creating an NFS server to hold their database and using the standard public network interface as their Interconnect, but I don't even want to start down that scary and unsupported track.

I'll have to press AWS more to provide an answer as even though it's not optimal, a single-node RAC config would allow rolling patches and Instance restarts with no downtime... although any Unix server maintenance would still require failover to a standby.  A small win, but any downtime saved is worthwhile.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40033074
Since we are spit-balling here, have you considered the new 12c Container databases?

If you only have one Plugable database (Singletenant) you don't require the Multitenant license.

This might get you the rolling upgrade flexability that you are after without RAC.

Of course if 12c is supported with EC2.
0
 
LVL 6

Author Comment

by:Greg Clough
ID: 40038288
12c... interesting idea.  I'm not sure I want to commit to a new version just yet, as I (like most) don't want to be the first to encounter and document the bugs on behalf of Oracle Corp.  I've already done my fair share over the years!  :-)

At present it's not supported in RDS, but I can't see any reason it couldn't run in EC2 on RedHat.

I'm meeting up with an AWS tech soon, so hopefully I'll get some answers then and I can enlighten everyone.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 40038305
>>the first to encounter and document the bugs on behalf of Oracle Corp

Been there as well!!!

I always try to wait for at least the first patchset before I even begin to think about the leap.

I've been playing with 12c on and off since it was released.  I'm only now starting to seriously look at it for a possible migration in the near future.

So far for what I'm doing (A LOT of XML and Oracle Text), it seems pretty stable.

*knocks on wood*
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now