Menu
Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Oracle Enterprise Manager Database Express

Amazon RDS supports Oracle Enterprise Manager (OEM) Database Express through the use of the OEM option. Amazon RDS supports the following versions of OEM database:

  • Oracle Enterprise Manager Database Express 12c

  • Oracle Enterprise Manager 11g Database Control

OEM Database Express and Database Control are similar tools that have a web-based interface for Oracle database administration. For more information about these tools, see Accessing Enterprise Manager Database Express 12c and Accessing Enterprise Manager 11g Database Control in the Oracle documentation.

The following are some limitations to using OEM Database:

  • OEM Database is not supported on the following DB instance classes: db.t2.micro, db.t2.small, db.t1.micro, db.m1.small.

    For more information about DB instance classes, see DB Instance Class Support for Oracle.

  • OEM 11g Database Control is not compatible with the following time zones: America/Argentina/Buenos_Aires, America/Matamoros, America/Monterrey, America/Toronto, Asia/Ashgabat, Asia/Dhaka, Asia/Kathmandu, Asia/Kolkata, Asia/Ulaanbaatar, Atlantic/Cape_Verde, Australia/Eucla, Pacific/Kiritimati.

    For more information about time zone support, see Oracle Time Zone.

OEM Database Option Settings

Amazon RDS supports the following settings for the OEM option.

Option Setting Valid Values Description

Port

An integer value

The port on the DB instance that listens for OEM Database. The default for OEM Database Express 12c is 5500. The default for OEM 11g Database Control is 1158.

Security Groups

A security group that has access to Port.

Adding the OEM Database Option

The general process for adding the OEM option to a DB instance is the following:

  1. Create a new option group, or copy or modify an existing option group.

  2. Add the option to the option group.

  3. Associate the option group with the DB instance.

After you add the OEM option, you don't need to restart your DB instance. As soon as the option group is active, the OEM Database is active.

To add the OEM option to a DB instance

  1. Determine the option group you want to use. You can create a new option group or use an existing option group. If you want to use an existing option group, skip to the next step. Otherwise, create a custom DB option group with the following settings:

    1. For Engine choose the oracle edition for your DB instance.

    2. For Major Engine Version choose 11.2 or 12.1 for your DB instance.

    For more information, see Creating an Option Group.

  2. Add the OEM option to the option group, and configure the option settings. For more information about adding options, see Adding an Option to an Option Group. For more information about each setting, see OEM Database Option Settings.

  3. Apply the option group to a new or existing DB instance:

Using OEM Database

After you enable the OEM option, you can begin using the OEM Database tool from your web browser.

You can access either OEM Database Control or OEM Database Express from your web browser. For example, if the endpoint for your Amazon RDS DB instance is mydb.f9rbfa893tft.us-east-1.rds.amazonaws.com, and your OEM port is 1158, then the URL to access the OEM Database Control the following.

Copy
https://mydb.f9rbfa893tft.us-east-1.rds.amazonaws.com:1158/em

When you access either tool from you web browser, a login window appears that prompts you for a user name and password. Type the master user name and master password for your DB instance. You are now ready to manage your Oracle databases.

Modifying OEM Database Settings

After you enable OEM Database, you can modify the Security Groups setting for the option.

You can't modify the OEM port number after you have associated the option group with a a DB instance. To change the OEM port number for a DB instance, do the following:

  1. Create a new option group.

  2. Add the OEM option with the new port number to the new option group.

  3. Remove the existing option group from the DB instance.

  4. Add the new option group to the DB instance.

For more information about how to modify option settings, see Modifying an Option Setting. For more information about each setting, see OEM Database Option Settings.

Removing the OEM Database Option

You can remove the OEM option from a DB instance. After you remove the OEM option, you don't need to restart your DB instance.

To remove the OEM option from a DB instance, do one of the following:

  • Remove the OEM option from the option group it belongs to. This change affects all DB instances that use the option group. For more information, see Removing an Option from an Option Group

  • Modify the DB instance and specify a different option group that doesn't include the OEM option. This change affects a single DB instance. You can specify the default (empty) option group, or a different custom option group. For more information, see Modifying a DB Instance Running the Oracle Database Engine.

Related Topics