RE: Amazon RDS Oracle
Date: Mon, 26 Mar 2012 13:57:35 -0400
Thanks for the reply. I forgot to ask about oracle support. Does it exist with this model?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeremiah Wilton
Sent: Monday, March 26, 2012 1:48 PM
Subject: Re: Amazon RDS Oracle
On Mar 26, 2012, at 10:13 AM, Michael McMullen wrote:
> Anyone using this for production db's? We're thinking of using it for a
> small db and we might also use the mulit a-z deployment. Is everything
> through a console? You never get access to the image via ssh? I'm also > wondering if you can still use datapump to export data.
We have customers using Amazon RDS for Oracle.
You can't log into the underlying host via SSH like with an EC2 instance. Connections are only via SQL*Net. You can do almost everything you would usually be able to do from within SQL*Plus or any other OCI-based tool (like Data Pump). I did a little playing around with RDS for Oracle when Amazon announced it, and notable exceptions to "normal operation" are described here: http://bit.ly/jzsE4G. In a nutshell:
. Create users
. Create tablespaces
. Create tables, indexes, and all other usual objects
. Grant alter system or database
. Grant restricted session
. Grant create or drop any directory
. Grant any privilege
. DATAPUMP_EXP_FULL_DATABASE, DATAPUMP_IMP_FULL_DATABASE,
. DDL on any object owned by SYS
. Alter user, revoke or any DDL on SYS, SYSTEM or RDSADMIN (a
special user installed by Amazon)
. Drop tablespace RDSADMIN
. Create public synonyms for objects belonging to SYS, SYSTEM or
RDSADMIN It looks like you already understand about RDS maintenance windows, since you are considering a multi A-Z deployment. The main thing is to go over any features Amazon RDS doesn't support and make sure you don't need them. If you find that RDS provides too little control, you can always use EC2, although that doesn't allow a the license-provided option for Oracle like RDS.