?
Solved

Is "Single Node RAC" supported on Amazon EC2?

Posted on 2014-04-29
7
Medium Priority
?
419 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
[X]
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
  • 3
  • 2
7 Comments
 
LVL 77

Accepted Solution

by:
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:
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 77

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 77

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*
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
A look into Log Analysis and Effective Critical Alerting.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

762 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