AWS AmazonRDS documentation change
Summary
Added CLI example for checking option group compatibility and post-upgrade object validation/recompilation procedures.
Security assessment
Changes are operational improvements for upgrade procedures. No security features or vulnerabilities are addressed, though invalid objects could indirectly impact security if left unaddressed.
Diff
diff --git a/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Oracle.Overview.md b/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Oracle.Overview.md index 9500ef7a3..38daf8367 100644 --- a//AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Oracle.Overview.md +++ b//AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Oracle.Overview.md @@ -126 +126,3 @@ Before you perform a major version upgrade of your RDS for Oracle DB instance, c - * Verify that your option group is compatible with the target version. Some options require updates or have different settings for different major versions. + * Verify that your option group is compatible with the target version. Some options require updates or have different settings for different major versions. To list the options available for a target version, run the [describe-option-group-options](https://docs.aws.amazon.com/cli/latest/reference/rds/describe-option-group-options.html) AWS CLI command, for example: + + aws rds describe-option-group-options --engine-name oracle-ee --major-engine-version 21 @@ -209,0 +212,7 @@ After the upgrade completes, verify the new version and check for invalid object +If the last query returns invalid objects that you own, recompile them by running the following procedure as the master user, substituting your schema name: + + + EXEC DBMS_UTILITY.COMPILE_SCHEMA(schema => 'schema_name'); + +If a component in `DBA_REGISTRY` shows a status other than `VALID`, or if Oracle-supplied objects (owned by `SYS` or `SYSTEM`) remain invalid after the upgrade, contact AWS Support. +