RE: Amazon RDS Oracle
Date: Mon, 26 Mar 2012 13:57:35 -0400
Message-ID: <SNT130-ds6350EF706BE6D84293CF3A6450_at_phx.gbl>
Thanks for the reply. I forgot to ask about oracle support. Does it exist with this model?
-----Original Message-----
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
To: ganstadba_at_hotmail.com
Cc: oracle-l_at_freelists.org
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
done
> 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.
Hi Michael,
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:
You CAN:
. Create users
. Create tablespaces
. Create tables, indexes, and all other usual objects
You CAN'T
. 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,
IMP_FULL_DATABASE, EXP_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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 26 2012 - 12:57:35 CDT