My Oracle Support Banner

EM 13c Fleet: Pluggable databases Status Are Not Getting Preserved At Same State After Succesful Completion of UPDATE_DB Operation (Doc ID 2646765.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Symptoms

 In Enterprise Manager (EM) Cloud Control, the Pluggable databases status are not getting preserved at same state after successful completion of Fleet UPDATE_DB operation

Before submitting of Update DB job

SQL> COLUMN name FORMAT A30
SQL> select INST_ID,NAME,OPEN_MODE,RESTRICTED from gv$pdbs order by 1,2;

   INST_ID NAME                           OPEN_MODE  RESRESTRICTED
---------- ------------------------------ ---------- -------------
         1 PDB$SEED                       READ ONLY  NO
         1 TARGETPDB1                     MOUNTED
         1 TARGETPDB2                     MOUNTED


$ emcli db_software_maintenance -performOperation
-name="Update DB" -purpose=UPDATE_DB -target_type=oracle_database -target_list="<target_name>"
-normal_credential="ORACLE:SYSMAN"
-privilege_credential="ROOT:SYSMAN"

Processing target "<TARGET_NAME>"...
Checking if target is already running from the current version of the image...
Check Passed.
Checking image subscription...
Check image subscription passed.
Operation 'Update DB' created successfully.


After Successful completion of above job

SQL> select INST_ID,NAME,OPEN_MODE,RESTRICTED from gv$pdbs order by 1,2;

   INST_ID NAME                                               OPEN_MODE  RES
---------- -------------------------------------------------- ---------- ---
         1 PDB$SEED                                           READ ONLY  NO
         1 TARGETPDB1                                         READ WRITE NO
         1 TARGETPDB2                                         READ WRITE NO

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.