11 Applying Oracle AI Database Patches
You can upgrade or apply patches to the Oracle database while Database Vault
is enabled by granting a special role to SYS. As a user with the
DV_OWNER role, grant DV_PATCH_ADMIN to
SYS for all pluggable databases.
From the container database:
- Connect as a user with the
DV_OWNERrole:connect c##dvowner - Grant
DV_PATCH_ADMINtoSYSfor all pluggable databases:GRANT DV_PATCH_ADMIN TO SYS CONTAINER=ALL; - Once patching is complete, revoke
DV_PATCH_ADMINfrom theSYSuser:- Connect as a user with the
DV_OWNERrole:connect c##dvowner - Revoke
DV_PATCH_ADMIN:REVOKE DV_PATCH_ADMIN FROM SYS CONTAINER=ALL;
- Connect as a user with the