Oracle Multimedia - Amazon Relational Database Service
PrerequisitesBest practicesAdding the optionRemoving the Option
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).

Oracle Multimedia

Amazon RDS supports Oracle Multimedia through the use of the MULTIMEDIA option. You can use Oracle Multimedia to store, manage, and retrieve images, audio, video, and other heterogeneous media data. For more information, see Oracle Multimedia in the Oracle documentation.

Important

If you use Oracle Multimedia, Amazon RDS automatically updates your DB instance to the latest Oracle PSU if there are security vulnerabilities with a Common Vulnerability Scoring System (CVSS) score of 9+ or other announced security vulnerabilities.

Amazon RDS supports Oracle Multimedia for all editions of the following versions:

  • Oracle Database 12c Release 2 (12.2)

  • Oracle Database 12c Release 1 (12.1), version 12.1.0.2.v13 or higher

Note

Oracle desupported Oracle Multimedia in Oracle Database 19c. So, Oracle Multimedia isn't supported for Oracle Database 19c DB instances. For more information, see Desupport of Oracle Multimedia in the Oracle documentation.

Prerequisites for Oracle Multimedia

The following are prerequisites for using Oracle Multimedia:

  • Your DB instance must be of sufficient class. Oracle Multimedia is not supported for the db.t3.micro or db.t3.small DB instance classes. For more information, see RDS for Oracle instance classes.

  • Your DB instance must have Auto Minor Version Upgrade enabled. This option enables your DB instance to receive minor DB engine version upgrades automatically when they become available and is required for any options that install the Oracle Java Virtual Machine (JVM). Amazon RDS uses this option to update your DB instance to the latest Oracle Patch Set Update (PSU) or Release Update (RU). For more information, see Modifying an Amazon RDS DB instance.

Best practices for Oracle Multimedia

The following are best practices for using Oracle Multimedia:

Adding the Oracle Multimedia option

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

  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.

If Oracle Java Virtual Machine (JVM) is not installed on the DB instance, there is a brief outage while the MULTIMEDIA option is added. There is no outage if Oracle Java Virtual Machine (JVM) is already installed on the DB instance. After you add the option, you don't need to restart your DB instance. As soon as the option group is active, Oracle Multimedia is available.

Note

During this outage, password verification functions are disabled briefly. You can also expect to see events related to password verification functions during the outage. Password verification functions are enabled again before the Oracle DB instance is available.

To add the MULTIMEDIA option to a DB instance

  1. Determine the option group that 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 edition for your Oracle DB instance.

    2. For Major engine version, choose the version of your DB instance.

    For more information, see Creating an option group.

  2. Add the MULTIMEDIA option to the option group. For more information about adding options, see Adding an option to an option group.

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

Removing the Oracle Multimedia option

After you drop all objects that use data types provided by the MULTIMEDIA option, you can remove the option from a DB instance. If Oracle Java Virtual Machine (JVM) is not installed on the DB instance, there is a brief outage while the MULTIMEDIA option is removed. There is no outage if Oracle Java Virtual Machine (JVM) is already installed on the DB instance. After you remove the MULTIMEDIA option, you don't need to restart your DB instance.

To drop the MULTIMEDIA option

  1. Back up your data.

    Warning

    If the instance uses data types that were enabled as part of the option, and if you remove the MULTIMEDIA option, you can lose data. For more information, see Backing up, restoring, and exporting data.

  2. Check whether any existing objects reference data types or features of the MULTIMEDIA option.

  3. Drop any objects that reference data types or features of the MULTIMEDIA option.

  4. Do one of the following:

    • Remove the MULTIMEDIA 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 MULTIMEDIA 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 an Amazon RDS DB instance.