Common DBA tasks for Oracle DB instances - Amazon Relational Database Service

Common DBA tasks for Oracle DB instances

Following, you can find a description for Amazon RDS–specific implementations of some common DBA tasks for RDS DB instances running the Oracle database engine. To deliver a managed service experience, Amazon RDS doesn't provide shell access to DB instances, and restricts access to certain system procedures and tables that require advanced privileges.

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.