Working with option groups in RDS Custom for Oracle - Amazon Relational Database Service
Overview of option groups in RDS Custom for Oracle
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Working with option groups in RDS Custom for Oracle

RDS Custom uses option groups to enable and configure additional features. An option group specifies features, called options, that are available for an RDS Custom for Oracle DB instance. Options can have settings that specify how the option works. When you associate an RDS Custom for Oracle DB instance with an option group, the specified options and option settings are enabled for this instance. For general information about option groups in Amazon RDS, see Working with option groups.

Topics

Overview of option groups in RDS Custom for Oracle

To enable options for your Oracle database, add them to an option group, and then associate the option group with your DB instance. For more information, see Working with option groups.

Summary of RDS Custom for Oracle options

RDS Custom for Oracle supports the following options for a DB instance.

Option Option ID Description

Oracle time zone

Timezone

The time zone used by your RDS Custom for Oracle DB instance.

Basic steps for adding an option to an RDS Custom for Oracle DB instance

The general procedure for adding an option to your RDS Custom for Oracle 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 your DB instance when you create or modify it.

Creating an option group for in RDS Custom for Oracle

You can create a new option group that derives its settings from the default option group. You then add one or more options to the new option group. Or, if you already have an existing option group, you can copy that option group with all of its options to a new option group. To learn how to copy an option group, see Copying an option group.

The default option groups for RDS Custom for Oracle are the following:

  • default:custom-oracle-ee

  • default:custom-oracle-se2

  • default:custom-oracle-ee-cdb

  • default:custom-oracle-se2-cdb

When you create an option group, the settings are derived from the default option group. After you have added the TIME_ZONE option, you can then associate the option group with your DB instance.

One way of creating an option group is by using the Amazon Web Services Management Console.

To create a new option group by using the console

  1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the navigation pane, choose Option groups.

  3. Choose Create group.

  4. In the Create option group window, do the following:

    1. For Name, type a name for the option group that is unique within your Amazon account. The name can contain only letters, digits, and hyphens.

    2. For Description, type a brief description of the option group. The description is used for display purposes.

    3. For Engine, choose any of the following RDS Custom for Oracle DB engines:

      • custom-oracle-ee

      • custom-oracle-se2

      • custom-oracle-ee-cdb

      • custom-oracle-se2-cdb

    4. For Major engine version, choose a major engine version supported by RDS Custom for Oracle. For more information, see Supported Regions and DB engines for RDS Custom for Oracle.

  5. To continue, choose Create. To cancel the operation instead, choose Cancel.

To create an option group, use the Amazon CLI create-option-group command with the following required parameters.

  • --option-group-name

  • --engine-name

  • --major-engine-version

  • --option-group-description

Example

The following example creates an option group named testoptiongroup, which is associated with the Oracle Enterprise Edition DB engine. The description is enclosed in quotation marks.

For Linux, macOS, or Unix:

aws rds create-option-group \
    --option-group-name testoptiongroup \
    --engine-name custom-oracle-ee-cdb \
    --major-engine-version 19 \
    --option-group-description "Test option group for a Custom Oracle CDB"

For Windows:

aws rds create-option-group ^
    --option-group-name testoptiongroup ^
    --engine-name custom-oracle-ee-cdb ^
    --major-engine-version 19 ^
    --option-group-description "Test option group for a Custom Oracle CDB"

To create an option group, call the Amazon RDS API CreateOptionGroup operation.

Associating an option group with an RDS Custom for Oracle DB instance

You can associate your option group with a new or existing DB instance: