Solved

Is "Single Node RAC" supported on Amazon EC2?

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

#Citrix #XenApp #Citrix Scout #Citrix Insight Services #Microsoft VMMAP #Microsoft ADEXPLORE #Microsoft RAMMAP #Microsoft TCPVIEW #Microsoft AUTORUNS #Microsoft PROCESS EXPLORER #Microsoft PROCESS MONITOR
When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

770 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