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 laterInformation 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 |