Configure Oracle Managed Database Software Updates for Oracle Exadata Database Service on Exascale Infrastructure

Introduction

With Oracle managed database software updates, you can offload software maintenance for Exadata Database Service on Exascale Infrastructure databases to Oracle.

For enrolled databases, Oracle periodically runs readiness checks before scheduled maintenance, stages software in advance, applies the latest available Release Update (RU) during the maintenance window, and provides proactive notifications throughout the update process. Updates are applied in a rolling manner, one database instance at a time.

Oracle managed database software updates can use Delegate Access Control to let Oracle investigate and resolve eligible issues encountered during scheduled database software updates. If an issue cannot be fixed during the planned maintenance window, Oracle rolls back the update to keep the database healthy and available, then engages with you to resolve the issue before a future maintenance window.

You can enroll a database in Oracle managed database software updates during database creation or enroll an existing database. After enrollment, the Database Details page shows update details such as scheduling preference, next scheduled maintenance, software version, and maintenance method.

Key points

Objectives

In this tutorial, you will:

  1. Enroll a database in Oracle managed database software updates when you create it.

  2. Enroll an existing database in Oracle managed database software updates.

  3. Subscribe to event notifications for Oracle managed database software updates.

  4. Subscribe to notifications for Delegate Access Control.

  5. Reschedule the next scheduled maintenance.

  6. Review and resolve Oracle managed database software update issues.

  7. Unenroll a database from Oracle managed database software updates.

  8. Move a database from an Oracle managed database home to a customer managed database home.

Prerequisites

Before you begin, make sure you have:

Ask your tenancy administrator to verify the policies and network configuration described in Preparing for Delegate Access Control, using the ExaDB-XS checklist for When only Oracle Managed Software Updates for Database Cloud Services is subscribed.

Task 1: Enroll a database in Oracle managed database software updates when you create it

Use the database creation workflow to enroll a new database in Oracle managed database software updates.

  1. Open the navigation menu. Click Oracle AI Database, and then click Oracle Exadata Database Service on Exascale Infrastructure.

    Oracle AI Database navigation menu

  2. Select the compartment that contains the target VM cluster. Open the Exadata VM cluster, go to the Container databases tab, and then click Create container database.

    VM cluster Container databases tab with Create container database

  3. In the database configuration workflow, go to Database Software Management. For Software Management Preference, select Oracle managed software updates. Provide the preferred day and start time (UTC) for maintenance under Scheduling preferences. Complete the remaining database creation options. Click Create.

    Create container database form with Oracle managed software updates selected and scheduling and version preferences visible

  4. After the database is created, review the Oracle managed software update preference in the Database Version section on the Database Details page.

    Database details Oracle managed software update preference

Task 2: Enroll an existing database in Oracle managed database software updates

Use this task to enroll an existing database in Oracle managed database software updates.

  1. Open the navigation menu. Click Oracle AI Database, and then click Oracle Exadata Database Service on Exascale Infrastructure.

    Oracle AI Database navigation menu

  2. Select the compartment that contains the target VM cluster. Open the Exadata VM cluster, go to the Container databases tab, and then click the name of the container database that you want to modify.

    Container databases list with customer managed database selected

  3. On the Database Details page, click More Actions, and then select Manage database software update.

    More actions menu Manage database software update

  4. In the resulting window, select Oracle managed software updates. Provide the preferred day and start time (UTC) for maintenance under Scheduling preferences, and then click Save.

    Edit database software management panel showing Oracle managed software updates selected and scheduling preferences

  5. Review the Oracle managed software update preference in the Database Version section on the Database Details page. On the next scheduled maintenance date, Oracle updates the database and moves it to an Oracle managed database home. After the scheduled update, you can view and access the new database home in the Database Version section.

    Database details next scheduled maintenance

Task 3: Subscribe to event notifications for Oracle managed database software updates

Subscribe to events for Oracle managed database software updates to receive the scheduled-maintenance notification at least one week in advance. Events also report readiness-check results, update status changes, and maintenance completion.

  1. Open Developer Services > Notifications > Topics. Select the topic compartment, and then click Create topic. If you already have a topic, open it and continue with step 3.

    Notifications Topics page Create topic

  2. Enter a topic name and optional description, select the compartment, and then click Create. Open the topic after it is created.

    Create Notifications topic

    Notifications topic list

  3. On the Subscriptions tab, click Create subscription, select the protocol, enter the endpoint, and then create the subscription. Repeat for additional subscribers. For email and other protocols that require confirmation, follow the confirmation link sent to the endpoint. Verify that each subscription is Active. See Creating a subscription.

    Notifications topic subscription

  4. To create event rules, open Observability & Management > Events Service > Rules. Select the compartment containing the databases and database homes to monitor, and then click Create rule. Enter a display name and optional description.

    Events Rules page Create rule

  5. In Rule conditions, select Event type as the condition and Database as the Service name. In the Event type field, enter Oracle managed. Select the Oracle managed database software updates event types for both databases and database homes.

    Events rule Oracle managed database software update event types

  6. In Actions, select Notifications as the action type, select the Notifications compartment and topic, and then click Create rule.

    Events rule notification action

Task 4: Subscribe to notifications for Delegate Access Control

Enrolling a database in Oracle managed database software updates automatically creates a Delegation Control for the VM cluster hosting that database. Configure Delegate Access Control notifications so that you receive notifications for delegated access activity associated with Oracle managed maintenance. Delegate Access Control notifications are sent to the configured Notifications topic.

Ask your tenancy administrator to allow Delegate Access Control to publish to the topic. Replace <topic_compartment> with the compartment that contains the topic:

allow any-user to use ons-topics in compartment <topic_compartment> where ALL { request.principal.type='dlgtmgmtdelegationcontrol' }

For the required user permissions and ExaDB-XS setup, see Preparing for Delegate Access Control.

  1. Create an OCI Notifications topic for Delegate Access Control notifications, or identify an existing topic to use. Follow Task 3, steps 1–3, to create and confirm the required subscriptions. Verify that the subscriptions are Active.

    Notifications topic subscriptions list

  2. Open Oracle AI Database > Delegate Access Control > Delegation Controls. Select the compartment and open the Delegation Control for the VM cluster that hosts the database.

    Delegate Access Control delegation control row

  3. On the Delegation Control details page, click Edit.

    Delegation Control details Edit button

  4. Under Notification requirements, select the notification topic compartment and topic, and then click Save.

    Edit delegation control notification topic

Task 5: Reschedule the next scheduled maintenance

Use this task to reschedule the next Oracle managed database software update for a database. You can reschedule only the upcoming maintenance instance. You cannot use the reschedule window to modify the maintenance day and time. Oracle determines the next feasible maintenance date and time based on the scheduling preference selected for the database. To change the recurring preference, use Manage database software update as described in Task 2.

  1. Open the navigation menu. Click Oracle AI Database, and then click Oracle Exadata Database Service on Exascale Infrastructure.

    Oracle AI Database navigation menu

  2. Select the compartment that contains the target VM cluster. Open the Exadata VM cluster, go to the Container databases tab, and then click the name of the container database whose next managed software update you want to reschedule.

    Container databases list with Oracle managed database selected

  3. In the Database Version section, locate Next Scheduled Maintenance, and then click Reschedule.

    Database details Reschedule button

  4. In the Reschedule maintenance window, review the read-only Next Scheduled Maintenance and Target Database Software Version fields. Review the warning message, and then click Confirm.

    Reschedule maintenance confirmation

  5. Open the Work requests tab to monitor the reschedule request. After the request completes successfully, review Next Scheduled Maintenance in the Database Version section.

    Database details rescheduled maintenance

Task 6: Review and resolve Oracle managed database software update issues

Oracle periodically performs readiness checks before the scheduled maintenance window. If readiness checks detect an issue, the Database Details page displays the issue and recommended resolution steps. Issues that require your action must be resolved before the maintenance window.

Key points

  1. Open the navigation menu. Click Oracle AI Database, and then click Oracle Exadata Database Service on Exascale Infrastructure.

  2. Select the compartment that contains the target VM cluster. Open the Exadata VM cluster, go to the Container databases tab, and then click the name of the container database for which you want to view managed database software update issues.

  3. In the Database panel, click View details on the banner that reports the readiness issues.

  4. Review each issue and follow the Fix Recommendation comments. For additional issue-resolution guidance, see Exadata Database Service on Exascale Infrastructure troubleshooting documentation.

  5. After resolving the listed issues, optionally click Run Check to manually rerun readiness checks, and confirm the action in the resulting window.

  6. Click Close. Review Next Scheduled Maintenance in the Database Version section for the current maintenance status.

Task 7: Unenroll a database from Oracle managed database software updates

Unenroll a database from Oracle managed database software updates when you want to stop Oracle managed database software maintenance and return the database to customer managed software updates. After unenrollment, the database continues to be hosted by the Oracle managed database home and is unaffected by scheduled Oracle managed maintenance.

  1. Open the navigation menu. Click Oracle AI Database, and then click Oracle Exadata Database Service on Exascale Infrastructure.

    Oracle AI Database navigation menu

  2. Select the compartment that contains the target VM cluster. Open the Exadata VM cluster, go to the Container databases tab, and then click the name of the container database that you want to unenroll from Oracle managed database software updates.

    Container databases list with DB0609 selected

  3. On the Database Details page, click More Actions, and then select Manage database software update.

    DB0609 More actions Manage database software update

  4. In the resulting window, select Customer managed software updates. Click Save.

    Edit database software management customer managed updates

  5. Review the warning message. Click Confirm.

    Disable Oracle managed software updates confirmation

  6. In the Database Version section on the Database Details page, verify that Database software updates shows Customer managed software updates. The database home remains unchanged.

    Database details showing customer managed software updates after unenrollment

Task 8: Move a database from an Oracle managed database home to a customer managed database home

A database enrolled in Oracle managed database software updates cannot be moved to another database home. To move the database to a customer managed database home, first unenroll the database from Oracle managed database software updates. After unenrollment, the database remains hosted by the Oracle managed database home. Follow these steps to move the database from an Oracle managed database home to a customer managed database home.

  1. Open the navigation menu. Click Oracle AI Database, and then click Oracle Exadata Database Service on Exascale Infrastructure.

    Oracle AI Database navigation menu

  2. Select the compartment that contains the target VM cluster. Open the Exadata VM cluster, go to the Container databases tab, and then click the name of the container database that you want to move from an Oracle managed database home to a customer managed database home.

    Container databases list with customer managed DB0609

  3. If the database is enrolled in Oracle managed database software updates, unenroll it using the steps in Task 7 above.

  4. Make sure a compatible customer managed database home exists on the VM cluster. Use the same database release and a supported target patch version; see Database home eligibility for the current requirements. To change to a different major database release, use the database upgrade workflow. Click More Actions, and then select Move to Another Home.

    More actions Move to Another Home

  5. In the resulting dialog, select the target customer managed database home. Click Move.

    Move database to another home select target

  6. Review the Confirm Database move dialog. The move stops and restarts database instances in a rolling manner, one node at a time. Click Move.

    Confirm database move dialog

  7. Monitor the move in Work requests. After it completes successfully, verify the target Database Home and Database version in the Database Version section on the Database Details page.

    Database details after move home

Acknowledgments

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.