Is "Single Node RAC" supported on Amazon EC2?

Posted on 2014-04-29
Medium Priority
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?

Question by:Greg Clough
  • 3
  • 2
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 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:

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.

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.
LVL 78

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.

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.
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 2000 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*

Featured Post

We Need Your Input!

WatchGuard is currently running a beta program for our new macOS Host Sensor for our Threat Detection and Response service. We're looking for more macOS users to help provide insight and feedback to help us make the product even better. Please sign up for our beta program today!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Virtualization software lets you run different versions of Windows, Ubuntu Linux and other versions of Linux all at the same time, rather than running each one directly from your computer's hard drive.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

619 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