Preparing to create a CEV - Amazon Relational Database Service

Preparing to create a CEV

To create a CEV, access the installation files and patches that are stored in your Amazon S3 bucket for any of the following releases:

  • Oracle Database 19c

  • Oracle Database 18c

  • Oracle Database 12c Release 2 (12.2)

  • Oracle Database 12c Release 1 (12.1)

For example, you can use the April 2021 RU/RUR for Oracle Database 19c, or any valid combination of installation files and patches.

Downloading your database installation files and patches from Oracle Software Delivery Cloud

The Oracle Database installation files and patches are hosted on Oracle Software Delivery Cloud.

To download the database installation files for Oracle Database 19c

  1. Go to https://edelivery.oracle.com/ and sign in.

  2. In the box, enter Oracle Database Enterprise Edition and choose Search.

  3. Choose DLP: Oracle Database Enterprise Edition 19.3.0.0.0 ( Oracle Database Enterprise Edition ).

  4. Choose Continue.

  5. Clear the Download Queue check box.

  6. Choose Oracle Database 19.3.0.0.0 - Long Term Release.

  7. Choose Linux x86-64 in Platform/Languages.

  8. Choose Continue, and then sign the waiver.

  9. Choose V982063-01.zip, choose Download, and then save the file.

    Note

    The SHA-256 hash is BA8329C757133DA313ED3B6D7F86C5AC42CD9970A28BF2E6233F3235233AA8D8.

  10. Click the links in the following table to download the Oracle patches. All URLs are for updates.oracle.com or support.oracle.com.

    File Description
    p6880880_190000_Linux-x86-64.zip OPatch for this version of Oracle
    p32126828_190000_Linux-x86-64.zip Patch 32126828 - COMBO OF OJVM RU COMPONENT 19.10.0.0.210119 + DB RU 19.10.0.0.210119
    p29213893_1910000DBRU_Generic.zip Patch 29213893: DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER TABLE
    p29782284_1910000DBRU_Generic.zip Patch 29782284: ORA-06508: "MDSYS.MDPRVT_IDX" WHILE UPGRADING DATABASE TO 18.3
    p28730253_190000_Linux-x86-64.zip Patch 28730253: SUPPORT NEW ERA REIWA FOR JAPANESE IMPERIAL CALENDAR
    p29374604_1910000DBRU_Linux-x86-64.zip Patch 29374604: Golden Gate Integrated Extract not starting 18c/19c Standard Edition
    p28852325_190000_Linux-x86-64.zip DST files - RDBMS - DSTV33 UPDATE - TZDATA2018G - Patch 28852325
    p29997937_190000_Linux-x86-64.zip DST files - RDBMS - DSTV34 UPDATE - TZDATA2019B - Patch 29997937
    p31335037_190000_Linux-x86-64.zip DST files - RDBMS - DSTV35 UPDATE - TZDATA2020A - Patch 31335037
    p31335142_190000_Generic.zip DST files - DSTV35 UPDATE - TZDATA2020A - NEED OJVM FIX - Patch 31335142

To download the database installation files for Oracle Database 18c

  1. Go to https://edelivery.oracle.com/ and sign in.

  2. In the box, enter Oracle Database Enterprise Edition and choose Search.

  3. Choose DLP: Oracle Database 12c Enterprise Edition 18.0.0.0.0 ( Oracle Database Enterprise Edition ).

  4. Choose Continue.

  5. Clear the Download Queue check box.

  6. Choose Oracle Database 18.0.0.0.0.

  7. Choose Linux x86-64 in Platform/Languages.

  8. Choose Continue, and then sign the waiver.

  9. Choose V978967-01.zip, choose Download, and then save the file.

    Note

    The SHA-256 hash is C96A4FD768787AF98272008833FE10B172691CF84E42816B138C12D4DE63AB96.

  10. Click the links in the following table to download the Oracle patches. All URLs are for updates.oracle.com or support.oracle.com.

    File Description
    p6880880_180000_Linux-x86-64.zip OPatch 12.2.0.1.30 for DB 18.0.0.0.0 (Apr 2022)
    p32126855_180000_Linux-x86-64.zip COMBO OF OJVM RU COMPONENT 18.13.0.0.210119 + DB RU 18.13.0.0.210119
    p28730253_180000_Linux-x86-64.zip SUPPORT NEW ERA REIWA FOR JAPANESE IMPERIAL CALENDAR
    p27539475_1813000DBRU_Linux-x86-64.zip ORA-3816 - MISSING MESSAGE INFORMATION FOR 3816 ERROR
    p29213893_180000_Generic.zip DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE
    p29374604_1813000DBRU_Linux-x86-64.zip IE not starting against 18c Oracle RDBMS Standard Edition
    p29782284_180000_Generic.zip ORA-06508: "MDSYS.MDPRVT_IDX" WHILE UPGRADING DATABASE TO 18.3
    p28125601_180000_Linux-x86-64.zip RDBMS - PROACTIVE DSTV32 UPDATE - TZDATA2018E
    p28852325_180000_Linux-x86-64.zip RDBMS - DSTV33 UPDATE - TZDATA2018G
    p29997937_180000_Linux-x86-64.zip RDBMS - DSTV34 UPDATE - TZDATA2019B
    p31335037_180000_Linux-x86-64.zip RDBMS - DSTV35 UPDATE - TZDATA2020A
    p31335142_180000_Generic.zip DSTV35 UPDATE - TZDATA2020A - NEED OJVM FIX

To download the database installation files for Oracle Database 12c Release 2 (12.2)

  1. Go to https://edelivery.oracle.com/ and sign in.

  2. In the box, enter Oracle Database Enterprise Edition and choose Search.

  3. Choose DLP: Oracle Database 12c Enterprise Edition 12.2.0.1.0 ( Oracle Database Enterprise Edition ).

  4. Choose Continue.

  5. Clear the Download Queue check box.

  6. Choose Oracle Database 12.2.0.1.0.

  7. Choose Linux x86-64 in Platform/Languages.

  8. Choose Continue, and then sign the waiver.

  9. Choose V839960-01.zip, choose Download, and then save the file.

    Note

    The SHA-256 hash is 96ED97D21F15C1AC0CCE3749DA6C3DAC7059BB60672D76B008103FC754D22DDE.

  10. Click the links in the following table to download the Oracle patches. All URLs are for updates.oracle.com or support.oracle.com.

    File Description
    p6880880_122010_Linux-x86-64.zip OPatch 12.2.0.1.30 for DB 12.2.0.1.0 (Apr 2022)
    p33261817_122010_Linux-x86-64.zip DATABASE OCT 2021 RELEASE UPDATE 12.2.0.1.211019
    p33192662_122010_Linux-x86-64.zip OJVM RELEASE UPDATE 12.2.0.1.211019
    p29213893_122010_Generic.zip DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE
    p28730253_122010_Linux-x86-64.zip SUPPORT NEW ERA REIWA FOR JAPANESE IMPERIAL CALENDAR
    p26352615_12201211019DBOCT2021RU_Linux-x86-64.zip SPILLOVER AUDIT FILES CANNOT BE FOUND ORA-46372
    p23614158_122010_Linux-x86-64.zip DSTV27 UPDATE JUNE 2016 - TZDATA2016F
    p24701840_122010_Linux-x86-64.zip RDBMS - DSTV28 UPDATE OCT 2016 - TZDATA2016G
    p25173124_122010_Linux-x86-64.zip RDBMS - DSTV29 UPDATE - TZDATA2016J
    p25881255_122010_Linux-x86-64.zip RDBMS - PROACTIVE DSTV30 UPDATE - TZDATA2017B
    p27015449_122010_Linux-x86-64.zip RDBMS - PROACTIVE DSTV31 UPDATE - TZDATA2017C
    p28125601_122010_Linux-x86-64.zip RDBMS - PROACTIVE DSTV32 UPDATE - TZDATA2018E
    p28852325_122010_Linux-x86-64.zip RDBMS - DSTV33 UPDATE - TZDATA2018G
    p29997937_122010_Linux-x86-64.zip RDBMS - DSTV34 UPDATE - TZDATA2019B
    p31335037_122010_Linux-x86-64.zip RDBMS - DSTV35 UPDATE - TZDATA2020A
    p32327201_122010_Linux-x86-64.zip RDBMS - DSTV36 UPDATE - TZDATA2020E
    p32327208_122010_Generic.zip DSTV36 UPDATE - TZDATA2020E - NEED OJVM FIX

To download the database installation files for Oracle Database 12c Release 1 (12.1)

  1. Go to https://edelivery.oracle.com/ and sign in.

  2. In the box, enter Oracle Database Enterprise Edition and choose Search.

  3. Choose DLP: Oracle Database 12c Enterprise Edition 12.1.0.2.0 ( Oracle Database Enterprise Edition ).

  4. Choose Continue.

  5. Clear the Download Queue check box.

  6. Choose Oracle Database 12.1.0.2.0.

  7. Choose Linux x86-64 in Platform/Languages.

  8. Choose Continue, and then sign the waiver.

  9. Choose V46095-01_1of2.zip and V46095-01_2of2.zip, choose Download, and then save the files.

    Note

    The SHA-256 hash for V46095-01_1of2.zip is 31FDC2AF41687B4E547A3A18F796424D8C1AF36406D2160F65B0AF6A9CD47355.

    The SHA-256 hash for V46095-01_2of2.zip is 03DA14F5E875304B28F0F3BB02AF0EC33227885B99C9865DF70749D1E220ACCD.

  10. Click the links in the following table to download the Oracle patches. All URLs are for updates.oracle.com or support.oracle.com.

    File Description
    p6880880_121010_Linux-x86-64.zip OPatch 12.2.0.1.29 for DB 12.1.0.1.0 (Feb 2022)
    p32768233_121020_Linux-x86-64.zip DATABASE PATCH SET UPDATE 12.1.0.2.210720
    p32876425_121020_Linux-x86-64.zip OJVM PATCH SET UPDATE 12.1.0.2.210720
    p18759211_121020_Linux-x86-64.zip DST 22: HALF YEARLY DST PATCHES, JUN 2014
    p19396455_121020_Linux-x86-64.zip DST-23: DST UPDATE SEPTEMBER 2014 - TZDATA2014F
    p20875898_121020_Linux-x86-64.zip DST-24: DST UPDATE APRIL 2015 - TZDATA2015D
    p22037014_121020_Linux-x86-64.zip DST-25: DST UPDATE OCTOBER 2015 - TZDATA2015G
    p22873635_121020_Linux-x86-64.zip DST-26: DST UPDATE APRIL 2016 - TZDATA2016D
    p23614158_121020_Linux-x86-64.zip DSTV27 UPDATE JUNE 2016 - TZDATA2016F
    p24701840_121020_Linux-x86-64.zip RDBMS - DSTV28 UPDATE OCT 2016 - TZDATA2016G
    p25881255_121020_Linux-x86-64.zip RDBMS - PROACTIVE DSTV30 UPDATE - TZDATA2017B
    p27015449_121020_Linux-x86-64.zip RDBMS - PROACTIVE DSTV31 UPDATE - TZDATA2017C
    p28125601_121020_Linux-x86-64.zip DSTv32 for RDBMS (TZDATA2018E)
    p28852325_121020_Linux-x86-64.zip DSTv33 for RDBMS (TZDATA2018G)
    p29997937_121020_Linux-x86-64.zip DSTv34 for RDBMS (TZDATA2019G)
    p31335037_121020_Linux-x86-64.zip RDBMS - DSTV35 UPDATE - TZDATA2020A
    p32327201_121020_Linux-x86-64.zip RDBMS - DSTV36 UPDATE - TZDATA2020E
    p32327208_121020_Generic.zip DSTV36 UPDATE - TZDATA2020E - NEED OJVM FIX
    p17969866_12102210119_Linux-x86-64.zip Oracle GoldenGate – 46719 ENH REPLICATION SUPPORT FOR INSERTS / FULL UPDATES WITH LARGE VALUES
    p20394750_12102210119_Linux-x86-64.zip Oracle GoldenGate – APPLY CDR RESOLUTION FAILING FOR LOBS, XML, LONG, AND OBJECTS
    p24835919_121020_Linux-x86-64.zip Oracle GoldenGate – IR EXECUTING DEPENDENT TRANSACTIONS OUT OF ORDER WITH PARALLELISM GREATER THAN
    p23262847_12102201020_Linux-x86-64.zip Oracle GoldenGate - MALFORMED REDO CAUSED OGG REPLICATION ABEND
    p21171382_12102201020_Generic.zip ADD CONTROL FOR AUTOMATIC CREATION OF STATS EXTENSIONS
    p21091901_12102210720_Linux-x86-64.zip ONLINE MOVE OF HASH OR REF PARTITION CAN LEAVE LOCAL INDEXES INCONSISTENT
    p33013352_12102210720_Linux-x86-64.zip JSON Bundle Patch
    p25031502_12102210720_Linux-x86-64.zip MV QUERY REWRITE WORKLOAD HIT ORA 600 [KGL-HEAP-SIZE-EXCEEDED]
    p23711335_12102191015_Generic.zip CDB_UPG PDCDB CDB UPGRADE AS WHOLE TAKES 1 MORE HOUR THAN PREVIOUS LABELS IN MAY
    p19504946_121020_Linux-x86-64.zip FLASH CACHE DOESN'T WORK IN OEL7

Uploading your installation files to Amazon S3

Upload your Oracle installation and patch files to Amazon S3 using the AWS CLI. The S3 bucket that contains your installation files must be in the same AWS Region as your CEV.

Choose either of the following options:

  • Use aws s3 cp to upload a single .zip file.

    Upload each installation .zip file separately. Don't combine the .zip files into a single .zip file.

  • Use aws s3 sync to upload a directory.

List your installation files using either the AWS Management Console or the AWS CLI.

Examples in this section use the following placeholders:

  • install-or-patch-file.zip – Oracle installation media file. For example, p32126828_190000_Linux-x86-64.zip is a patch.

  • my-custom-installation-files – Your Amazon S3 bucket designated for your uploaded installation files.

  • 123456789012/cev1 – An optional prefix in your Amazon S3 bucket.

  • source-bucket – An Amazon S3 bucket where you can optionally stage files.

The following example uploads install-or-patch-file.zip to the 123456789012/cev1 folder in the RDS Custom Amazon S3 bucket. Run a separate aws s3 command for each .zip that you want to upload.

For Linux, macOS, or Unix:

aws s3 cp install-or-patch-file.zip \ s3://my-custom-installation-files/123456789012/cev1/

For Windows:

aws s3 cp install-or-patch-file.zip ^ s3://my-custom-installation-files/123456789012/cev1/

Verify that your S3 bucket is in the AWS Region where you plan to run the create-custom-db-engine-version command.

aws s3api get-bucket-location --bucket my-custom-installation-files

List the files in your RDS Custom Amazon S3 bucket as follows.

aws s3 ls \ s3://my-custom-installation-files/123456789012/cev1/

The following example uploads the files in your local cev1 folder to the 123456789012/cev1 folder in your Amazon S3 bucket.

For Linux, macOS, or Unix:

aws s3 sync cev1 \ s3://my-custom-installation-files/123456789012/cev1/

For Windows:

aws s3 sync cev1 ^ s3://my-custom-installation-files/123456789012/cev1/

The following example uploads all files in source-bucket to the 123456789012/cev1 folder in your Amazon S3 bucket.

For Linux, macOS, or Unix:

aws s3 sync s3://source-bucket/ \ s3://my-custom-installation-files/123456789012/cev1/

For Windows:

aws s3 sync s3://source-bucket/ ^ s3://my-custom-installation-files/123456789012/cev1/

Sharing your installation media in S3 across AWS accounts

For the purposes of this section, the Amazon S3 bucket that contains your uploaded Oracle installation files is your media bucket. Your organization might use multiple AWS accounts in an AWS Region. If so, you might want to use one AWS account to populate your media bucket and a different AWS account to create CEVs. If you don't intend to share your media bucket, skip to the next section.

This section assumes the following:

  • You can access the account that created your media bucket and a different account in which you intend to create CEVs.

  • You intend to create CEVs in only one AWS Region. If you intend to use multiple Regions, create a media bucket in each Region.

  • You're using the CLI. If you're using the Amazon S3 console, adapt the following steps.

To configure your media bucket for sharing across AWS accounts

  1. Log in to the AWS account that contains the S3 bucket into which you uploaded your installation media.

  2. Start with either a blank JSON policy template or an existing policy that you can adapt.

    The following command retrieves an existing policy and saves it as my-policy.json. In this example, the S3 bucket containing your installation files is named oracle-media-bucket.

    aws s3api get-bucket-policy \ --bucket oracle-media-bucket \ --query Policy \ --output text > my-policy.json
  3. Edit the media bucket permissions as follows:

    • In the Resource element of your template, specify the S3 bucket into which you uploaded your Oracle Database installation files.

    • In the Principal element, specify the ARNs for all AWS accounts that you intend to use to create CEVs. You can add the root, a user, or a role to the S3 bucket allow list. For more information, see IAM identifiers in the AWS Identity and Access Management User Guide.

    { "Version": "2008-10-17", "Statement": [ { "Sid": "GrantAccountsAccess", "Effect": "Allow", "Principal": { "AWS": [ "arn:aws:iam::account-1:root", "arn:aws:iam::account-2:user/user-name-with-path", "arn:aws:iam::account-3:role/role-name-with-path", ... ] }, "Action": [ "s3:GetObject", "s3:GetObjectAcl", "s3:GetObjectTagging", "s3:ListBucket", "s3:GetBucketLocation" ], "Resource": [ "arn:aws:s3:::oracle-media-bucket", "arn:aws:s3:::oracle-media-bucket/*" ] } ] }
  4. Attach the policy to your media bucket.

    In the following example, oracle-media-bucket is the name of the S3 bucket that contains your installation files, and my-policy.json is the name of your JSON file.

    aws s3api put-bucket-policy \ --bucket oracle-media-bucket \ --policy file://my-policy.json
  5. Log in to an AWS account in which you intend to create CEVs.

  6. Verify that this account can access the media bucket in the AWS account that created it.

    aws s3 ls --query "Buckets[].Name"

    For more information, see aws s3 ls in the AWS CLI Command Reference.

  7. Create a CEV by following the steps in Creating a CEV.

Preparing the CEV manifest

A CEV manifest is a JSON document that includes the following:

  • (Required) The list of installation .zip files that you uploaded to Amazon S3. RDS Custom applies the patches in the order in which they're listed in the manifest.

  • (Optional) Installation parameters that set nondefault values for the Oracle base, Oracle home, and the ID and name of the UNIX/Linux user and group. Be aware that you can’t modify the installation parameters for an existing CEV or an existing DB instance. You also can’t upgrade from one CEV to another CEV when the installation parameters have different settings.

For sample CEV manifests, see CEV manifest examples.

JSON fields in the CEV manifest

The following table describes the JSON fields in the manifest.

JSON fields in the CEV manifest
JSON field Description

MediaImportTemplateVersion

Version of the CEV manifest. The date is in the format YYYY-MM-DD.

databaseInstallationFileNames

Ordered list of installation files for the database.

opatchFileNames

Ordered list of OPatch installers used for the Oracle DB engine. Only one value is valid. Values for opatchFileNames must start with p6880880_.

psuRuPatchFileNames

The PSU and RU patches for this database.

Important

If you include psuRuPatchFileNames, opatchFileNames is required. Values for opatchFileNames must start with p6880880_.

OtherPatchFileNames

The patches that aren't in the list of PSU and RU patches. RDS Custom applies these patches after applying the PSU and RU patches.

Important

If you include OtherPatchFileNames, opatchFileNames is required. Values for opatchFileNames must start with p6880880_.

installationParameters

Nondefault settings for the Oracle base, Oracle home, and the ID and name of the UNIX/Linux user and group. You can set the following parameters:

oracleBase

The directory under which your Oracle binaries are installed. It is the mount point of the binary volume that stores your files. The Oracle base directory can include multiple Oracle homes. For example, if /home/oracle/oracle.19.0.0.0.ru-2020-04.rur-2020-04.r1.EE.1 is one of your Oracle home directories, then /home/oracle is the Oracle base directory. A user-specified Oracle base directory is not a symbolic link.

If you don't specify the Oracle base, the default directory is /rdsdbbin.

oracleHome

The directory in which your Oracle database binaries are installed. For example, if you specify /home/oracle/ as your Oracle base, then you might specify /home/oracle/oracle.19.0.0.0.ru-2020-04.rur-2020-04.r1.EE.1/ as your Oracle home. A user-specified Oracle home directory is not a symbolic link. The Oracle home value is referenced by the $ORACLE_HOME environment variable.

If you don't specify the Oracle home, the default naming format is /rdsdbbin/oracle.major-engine-version.custom.r1.engine-edition.1.

unixUname

The name of the UNIX user that owns the Oracle software. RDS Custom assumes this user when running local database commands. If you specify both unixUid and unixUname, RDS Custom creates the user if it doesn't exist, and then assigns the UID to the user if it's not the same as the initial UID.

The default user name is rdsdb.

unixUid

The ID (UID) of the UNIX user that owns the Oracle software. If you specify both unixUid and unixUname, RDS Custom creates the user if it doesn't exist, and then assigns the UID to the user if it's not the same as the initial UID.

The default UID is 61001. This is the UID of the user rdsdb.

unixGroupName

The name of the UNIX group. The UNIX user that owns the Oracle software belongs to this group.

The default group name is rdsdb.

unixGroupId

The ID of the UNIX group to which the UNIX user belongs.

The default group ID is 1000. This is the ID of the group rdsdb.

Each Oracle Database release has a different list of supported installation files. When you create your CEV manifest, make sure to specify only files that are supported by RDS Custom for Oracle. Otherwise, CEV creation fails with an error.

The following table shows valid values for Oracle Database 12c Release 1 (12.1).

Valid values for Oracle Database 12c Release 1 (12.1)
JSON field Valid values for 12.1

MediaImportTemplateVersion

2020-08-14

databaseInstallationFileNames

V46095-01_1of2.zip

V46095-01_2of2.zip

opatchFileNames

p6880880_121010_Linux-x86-64.zip

psuRuPatchFileNames

p32768233_121020_Linux-x86-64.zip

OtherPatchFileNames

p32876425_121020_Linux-x86-64.zip

p18759211_121020_Linux-x86-64.zip

p19396455_121020_Linux-x86-64.zip

p20875898_121020_Linux-x86-64.zip

p22037014_121020_Linux-x86-64.zip

p22873635_121020_Linux-x86-64.zip

p23614158_121020_Linux-x86-64.zip

p24701840_121020_Linux-x86-64.zip

p25881255_121020_Linux-x86-64.zip

p27015449_121020_Linux-x86-64.zip

p28125601_121020_Linux-x86-64.zip

p28852325_121020_Linux-x86-64.zip

p29997937_121020_Linux-x86-64.zip

p31335037_121020_Linux-x86-64.zip

p32327201_121020_Linux-x86-64.zip

p32327208_121020_Generic.zip

p17969866_12102210119_Linux-x86-64.zip

p20394750_12102210119_Linux-x86-64.zip

p24835919_121020_Linux-x86-64.zip

p23262847_12102201020_Linux-x86-64.zip

p21171382_12102201020_Generic.zip

p21091901_12102210720_Linux-x86-64.zip

p33013352_12102210720_Linux-x86-64.zip

p25031502_12102210720_Linux-x86-64.zip

p23711335_12102191015_Generic.zip

p19504946_121020_Linux-x86-64.zip

The following table shows valid values for Oracle Database 12c Release 2 (12.2).

Valid values for Oracle Database 12c Release 2 (12.2)
JSON field Valid values for Oracle Database 12c Release 2 (12.2)

MediaImportTemplateVersion

2020-08-14

databaseInstallationFileNames

V839960-01.zip

opatchFileNames

p6880880_122010_Linux-x86-64.zip

psuRuPatchFileNames

p33261817_122010_Linux-x86-64.zip

OtherPatchFileNames

p33192662_122010_Linux-x86-64.zip

p29213893_122010_Generic.zip

p28730253_122010_Linux-x86-64.zip

p26352615_12201211019DBOCT2021RU_Linux-x86-64.zip

p23614158_122010_Linux-x86-64.zip

p24701840_122010_Linux-x86-64.zip

p25173124_122010_Linux-x86-64.zip

p25881255_122010_Linux-x86-64.zip

p27015449_122010_Linux-x86-64.zip

p28125601_122010_Linux-x86-64.zip

p28852325_122010_Linux-x86-64.zip

p29997937_122010_Linux-x86-64.zip

p31335037_122010_Linux-x86-64.zip

p32327201_122010_Linux-x86-64.zip

p32327208_122010_Generic.zip

The following table shows valid values for Oracle Database 18c.

Valid values for Oracle Database 18c
JSON field Valid values for 18c

MediaImportTemplateVersion

2020-08-14

databaseInstallationFileNames

V978967-01.zip

opatchFileNames

p6880880_180000_Linux-x86-64.zip

psuRuPatchFileNames

p32126855_180000_Linux-x86-64.zip

OtherPatchFileNames

p28730253_180000_Linux-x86-64.zip

p27539475_1813000DBRU_Linux-x86-64.zip

p29213893_180000_Generic.zip

p29374604_1813000DBRU_Linux-x86-64.zip

p29782284_180000_Generic.zip

p28125601_180000_Linux-x86-64.zip

p28852325_180000_Linux-x86-64.zip

p29997937_180000_Linux-x86-64.zip

p31335037_180000_Linux-x86-64.zip

p31335142_180000_Generic.zip

The following table shows valid values for Oracle Database 19c.

Valid values for Oracle Database 19c
JSON field Valid values for 19c

MediaImportTemplateVersion

2020-08-14

databaseInstallationFileNames

V982063-01.zip

opatchFileNames

p6880880_190000_Linux-x86-64.zip

psuRuPatchFileNames

p32126828_190000_Linux-x86-64.zip

OtherPatchFileNames

p29213893_1910000DBRU_Generic.zip

p29782284_1910000DBRU_Generic.zip

p28730253_190000_Linux-x86-64.zip

p29374604_1910000DBRU_Linux-x86-64.zip

p28852325_190000_Linux-x86-64.zip

p29997937_190000_Linux-x86-64.zip

p31335037_190000_Linux-x86-64.zip

p31335142_190000_Generic.zip

Creating the CEV manifest

To create a CEV manifest

  1. List all installation files that you plan to apply, in the order that you want to apply them.

  2. Correlate the installation files with the JSON fields described in JSON fields in the CEV manifest.

  3. Do either of the following:

    • Create the CEV manifest as a JSON text file.

    • Edit the CEV manifest template when you create the CEV in the console. For more information, see Creating a CEV.

CEV manifest examples

The following examples show CEV manifest files for different Oracle Database releases. If you include a JSON field in your manifest, make sure that it isn't empty. For example, the following CEV manifest isn't valid because otherPatchFileNames is empty.

{ "mediaImportTemplateVersion": "2020-08-14", "databaseInstallationFileNames": [ "V982063-01.zip" ], "opatchFileNames": [ "p6880880_190000_Linux-x86-64.zip" ], "psuRuPatchFileNames": [ "p32126828_190000_Linux-x86-64.zip" ], "otherPatchFileNames": [ ] }

Topics

Example Sample CEV manifest for Oracle Database 12c Release 1 (12.1)

In the following example for the July 2021 PSU for Oracle Database 12c Release 1 (12.1), RDS Custom applies the patches in the order specified. Thus, RDS Custom applies p32768233, then p32876425, then p18759211, and so on. The example sets new values for the UNIX user and group, and the Oracle home and Oracle base.

{ "mediaImportTemplateVersion":"2020-08-14", "databaseInstallationFileNames":[ "V46095-01_1of2.zip", "V46095-01_2of2.zip" ], "opatchFileNames":[ "p6880880_121010_Linux-x86-64.zip" ], "psuRuPatchFileNames":[ "p32768233_121020_Linux-x86-64.zip" ], "otherPatchFileNames":[ "p32876425_121020_Linux-x86-64.zip", "p18759211_121020_Linux-x86-64.zip", "p19396455_121020_Linux-x86-64.zip", "p20875898_121020_Linux-x86-64.zip", "p22037014_121020_Linux-x86-64.zip", "p22873635_121020_Linux-x86-64.zip", "p23614158_121020_Linux-x86-64.zip", "p24701840_121020_Linux-x86-64.zip", "p25881255_121020_Linux-x86-64.zip", "p27015449_121020_Linux-x86-64.zip", "p28125601_121020_Linux-x86-64.zip", "p28852325_121020_Linux-x86-64.zip", "p29997937_121020_Linux-x86-64.zip", "p31335037_121020_Linux-x86-64.zip", "p32327201_121020_Linux-x86-64.zip", "p32327208_121020_Generic.zip", "p17969866_12102210119_Linux-x86-64.zip", "p20394750_12102210119_Linux-x86-64.zip", "p24835919_121020_Linux-x86-64.zip", "p23262847_12102201020_Linux-x86-64.zip", "p21171382_12102201020_Generic.zip", "p21091901_12102210720_Linux-x86-64.zip", "p33013352_12102210720_Linux-x86-64.zip", "p25031502_12102210720_Linux-x86-64.zip", "p23711335_12102191015_Generic.zip", "p19504946_121020_Linux-x86-64.zip" ], "installationParameters": { "unixGroupName": "dba", "unixGroupId": 123, "unixUname": "oracle", "unixUid": 12345, "oracleHome": "/home/oracle/oracle.12.1.0.2", "oracleBase": "/home/oracle" } }

Example Sample CEV manifest for Oracle Database 12c Release 2 (12.2)

In following example for the October 2021 PSU for Oracle Database 12c Release 2 (12.2), RDS Custom applies p33261817, then p33192662, then p29213893, and so on. The example sets new values for the UNIX user and group, and the Oracle home and Oracle base.

{ "mediaImportTemplateVersion":"2020-08-14", "databaseInstallationFileNames":[ "V839960-01.zip" ], "opatchFileNames":[ "p6880880_122010_Linux-x86-64.zip" ], "psuRuPatchFileNames":[ "p33261817_122010_Linux-x86-64.zip" ], "otherPatchFileNames":[ "p33192662_122010_Linux-x86-64.zip", "p29213893_122010_Generic.zip", "p28730253_122010_Linux-x86-64.zip", "p26352615_12201211019DBOCT2021RU_Linux-x86-64.zip", "p23614158_122010_Linux-x86-64.zip", "p24701840_122010_Linux-x86-64.zip", "p25173124_122010_Linux-x86-64.zip", "p25881255_122010_Linux-x86-64.zip", "p27015449_122010_Linux-x86-64.zip", "p28125601_122010_Linux-x86-64.zip", "p28852325_122010_Linux-x86-64.zip", "p29997937_122010_Linux-x86-64.zip", "p31335037_122010_Linux-x86-64.zip", "p32327201_122010_Linux-x86-64.zip", "p32327208_122010_Generic.zip" ], "installationParameters": { "unixGroupName": "dba", "unixGroupId": 123, "unixUname": "oracle", "unixUid": 12345, "oracleHome": "/home/oracle/oracle.12.2.0.1", "oracleBase": "/home/oracle" } }

Example Sample CEV manifest for Oracle Database 18c

In following example for the October 2021 PSU for Oracle Database 18c, RDS Custom applies p32126855, then p28730253, then p27539475, and so on. The example sets new values for the UNIX user and group, and the Oracle home and Oracle base.

{ "mediaImportTemplateVersion":"2020-08-14", "databaseInstallationFileNames":[ "V978967-01.zip" ], "opatchFileNames":[ "p6880880_180000_Linux-x86-64.zip" ], "psuRuPatchFileNames":[ "p32126855_180000_Linux-x86-64.zip" ], "otherPatchFileNames":[ "p28730253_180000_Linux-x86-64.zip", "p27539475_1813000DBRU_Linux-x86-64.zip", "p29213893_180000_Generic.zip", "p29374604_1813000DBRU_Linux-x86-64.zip", "p29782284_180000_Generic.zip", "p28125601_180000_Linux-x86-64.zip", "p28852325_180000_Linux-x86-64.zip", "p29997937_180000_Linux-x86-64.zip", "p31335037_180000_Linux-x86-64.zip", "p31335142_180000_Generic.zip" ] "installationParameters": { "unixGroupName": "dba", "unixGroupId": 123, "unixUname": "oracle", "unixUid": 12345, "oracleHome": "/home/oracle/18.0.0.0.ru-2020-10.rur-2020-10.r1", "oracleBase": "/home/oracle/" } }

Example Sample CEV manifest for Oracle Database 19c

In the following example for Oracle Database 19c, RDS Custom applies p32126828, then p29213893, then p29782284, and so on. The example sets new values for the UNIX user and group, and the Oracle home and Oracle base.

{ "mediaImportTemplateVersion": "2020-08-14", "databaseInstallationFileNames": [ "V982063-01.zip" ], "opatchFileNames": [ "p6880880_190000_Linux-x86-64.zip" ], "psuRuPatchFileNames": [ "p32126828_190000_Linux-x86-64.zip" ], "otherPatchFileNames": [ "p29213893_1910000DBRU_Generic.zip", "p29782284_1910000DBRU_Generic.zip", "p28730253_190000_Linux-x86-64.zip", "p29374604_1910000DBRU_Linux-x86-64.zip", "p28852325_190000_Linux-x86-64.zip", "p29997937_190000_Linux-x86-64.zip", "p31335037_190000_Linux-x86-64.zip", "p31335142_190000_Generic.zip" ], "installationParameters": { "unixGroupName": "dba", "unixGroupId": 123, "unixUname": "oracle", "unixUid": 12345, "oracleHome": "/home/oracle/oracle.19.0.0.0.ru-2020-04.rur-2020-04.r1.EE.1", "oracleBase": "/home/oracle" } }

Validating the CEV manifest

Optionally, verify that manifest is a valid JSON file by running the json.tool Python script.

For example, if you change into the directory containing a CEV manifest named manifest.json, run the following command.

python -m json.tool < manifest.json

Adding necessary IAM permissions

Make sure that the IAM principal that creates the CEV has the necessary policies described in Grant required permissions to your IAM user.