Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Is "Single Node RAC" supported on Amazon EC2?

Posted on 2014-04-29
7
383 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

789 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