How can I add Oracle Enterprise Manager Database Control or Database Express to an Amazon RDS for Oracle DB instance?

Short description

Use the Oracle Enterprise Manager (OEM) Option Group to configure OEM Database Control or Database Express based on the following versions of Amazon RDS Oracle:

• Oracle Enterprise Manager Database Express for Oracle 19c, Oracle 18c, and Oracle 12c
• Oracle Enterprise Manager 11g Database Control for Oracle 11g

For more information, see Oracle Enterprise Manager Database Express.

Resolution

To use the OEM Option Group to configure OEM Database Control or Database Express, complete the following steps:

1. Open the Amazon RDS console in the same AWS Region as your DB instance.
2. Choose Databases from the navigation pane, and then choose your DB instance.
3. Choose Option groups from the navigation pane. Then, create an option group, if you don't already have an option group that's associated to your DB instance.
4. Confirm that the option group uses the Oracle EE or Standard engine. Then, choose one of the supported major DB engine versions, such as 12.1.
5. After you create the option group, select the new option group, and then choose Add option.
6. From the Add option page, choose OEM from the Option name dropdown list.
7. Choose the DB engine version, such as 12.1.0.2, from the Version dropdown list.
8. Confirm that your Amazon Virtual Private Cloud (Amazon VPC) is configured to allow inbound access to the OEM port.
9. From the Security Groups list, select the Amazon VPC or DB security groups to activate.
   Note: You might see that the DB security group is different from the Amazon VPC or Amazon Elastic Compute Cloud (Amazon EC2) security group. This difference is because a DB instance on an EC2 Classic instance might use a DB security group. However, DB instances on an Amazon VPC use the Amazon VPC/Amazon EC2 security group.
10. Select Apply Immediately, and then choose Add Option.
    Note: When you add the OEM option for an Oracle 11g DB instance, there's no outage, and there's no need to restart your DB instance. But when you add the OEM option for an Oracle 19c, Oracle 18c, or Oracle 12c DB instance, a brief outage occurs while your DB instance is automatically restarted.
11. Associate this option group with the DB instance when you modify your DB instance.
12. After you activate the OEM option, you can use either Database Control or Database Express from your web browser. The URL of the OEM option includes the Amazon RDS endpoint and OEM port. For example, use https://mydb.f9rbfa893tft.us-east-1.rds.amazonaws.com:5500/em for Oracle 19c, Oracle 18c, or Oracle 12c DB instances or https://mydb.f9rbfa893tft.us-east-1.rds.amazonaws.com:1158/em for Oracle 11g.
13. After the page loads, enter the master username and master password for your DB instance.

Now you can manage your Oracle databases.

Related information

Amazon RDS for Oracle