Administering your RDS for Oracle DB instance - Amazon Relational Database Service

Administering your RDS for Oracle DB instance

Following are the common management tasks that you perform with an RDS for Oracle DB instance. Some tasks are the same for all RDS DB instances. Other tasks are specific to RDS for Oracle.

The following tasks are common to all RDS databases, but Oracle Database has special considerations. For example, you connect to an Oracle database using the Oracle clients SQL*Plus and SQL Developer.

Following, you can find a description for Amazon RDS–specific implementations of common DBA tasks for RDS Oracle. To deliver a managed service experience, Amazon RDS doesn't provide shell access to DB instances. Also, RDS restricts access to certain system procedures and tables that require advanced privileges. In many of the tasks, you run the rdsadmin package, which is an Amazon RDS–specific tool that enables you to administer your database.

The following are common DBA tasks for DB instances running Oracle:

  • Diagnostic tasks

    Listing incidents

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.list_adrci_incidents

    Oracle method: ADRCI command show incident

    Listing problems

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.list_adrci_problem

    Oracle method: ADRCI command show problem

    Creating incident packages

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.create_adrci_package

    Oracle method: ADRCI command ips create package

    Showing trace files

    Amazon RDS method: rdsadmin.rdsadmin_adrci_util.show_adrci_tracefile

    Oracle method: ADRCI command show tracefile

You can also use Amazon RDS procedures for Amazon S3 integration with Oracle and for running OEM Management Agent database tasks. For more information, see Amazon S3 integration and Performing database tasks with the Management Agent.