Oracle supported features on Amazon RDS

July 1, 2011  |  cloud, dba, security

What are the differences between Oracle Relational Database Service (Amazon RDS) and Oracle Database software? This question is heard very often from people that want to go for a trial on Oracle for Amazon RDS. For instance, most of them ask if Enterprise Manager is available on Oracle RDS. And I’ll answer that…

To provide a very stable and secure service, Amazon RDS doesn’t allow shell access to database instances, and forbids access to some system procedures and tables that need advanced privileges. Amazon RDS provides wrapper procedures for several DBA tasks that require those privileges.

Despite some features aren’t available on Oracle engine for Amazon RDS, most of them are. The following features are the ones that are available:

  • Automatic Memory Management
  • Automatic Undo Management
  • Advanced Compression
  • Advanced Queuing
  • Comprehensive support for Microsoft .NET, OLE DB, and ODBC
  • Distributed Queries/Transactions
  • Flashback Table, Query and Transaction Query
  • Fine-Grained Auditing
  • Import/Export and sqlldr Support
  • Materialized Views
  • Partitioning
  • Star Query Optimization
  • Summary Management – Materialized View Query Rewrite
  • Text
  • Virtual Private Database

And the following features, aren’t supported:

  • Automated Storage Management
  • Data Guard / Active Data Guard
  • Data Pump
  • Oracle Enterprise Manager
  • Real Application Clusters (RAC)
  • Streams

 

Beside these features limitations, there are some restricted DBA priviledges. Oracle uses role-based security. A role is a group of privileges that can be granted or revoked. The DBA role allows users, granted with this role, all administrative privileges on an Oracle database. The following privileges are not available for the DBA role whe running Oracle on Amazon RDS:

  • Alter database
  • Alter system
  • Create any directory
  • Drop any directory
  • Grant any object privilege
  • Grant any privilege
  • Grant any role
  • Restricted session

You should think that Amazon RDS with Oracle Engine is a service, imagine no server or OS running, and by making this kind of abstraction, you’ll understand the unavailability of the features and priviledges I wrote about. So Enterprise Manager is not available for Oracle on Amazon RDS!

Peace, Joao


3 Comments


  1. Jaco Do you have any idea wether Amazon do support Apex And also Jasper ???

Leave a Reply