My Oracle Support Banner

Fleet Maintenance: UPDATE_DB/UPDATE_RACDB Skips Datapatch With Message "DB is a Physical StandBy DB and hence no patches will be applied" In Apply PSU Step (Doc ID 2646762.1)

Last updated on SEPTEMBER 13, 2021

Applies to:

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

Symptoms

In Enterprise Manager Cloud Control, Fleet Maintenance UPDATE_DB,UPDATE_RACDB skips datapatch execution with message "DB is a Physical StandBy DB and hence no patches will be applied" in Apply PSU step assuming that database is standby.

Command Snippet:
$ emcli db_software_maintenance -performOperation -name=Fleet -purpose=UPDATE_DB/UPDATE_RACDB -target_type=oracle_database/rac_database -target_list=ABC -normal_credential=ORACLE:SYSMAN -privilege_credential=ROOT:SYSMAN

Job Step Log:: Job Steps Log for Job :Apply PSU/Patches on the database
-----------------------------------------------------------------------------------
Final command line to execute is $PERL_HOME/perl "/tmp/JOB_8E54D823E6ED0952E053BC48F20A9210/applyUpdates.pl" -oracleHome="/opt/oracle/db/dbhome1/12.2.0.1.190716" -newDbSID="XXXX" -workDir="/opt/oracle/tmp/54232933005877312/1563879841510" -physicalStdySids="XXXX" -isRAC="true" -isCDB="true" -racSID="XXXX"
-sqlSeq="${SQL_SEQ}" -isExa="${IS_EXA}" -nonRolling="false"

The output of the directive is:

****** Applying patches to PCD70254**********
XXXX is a Physical StandBy DB and hence no patches will be applied.
Applying patches ends***End of apply updates step

Ran script successfully

Deleted temporary destination directory
/tmp/JOB_8E54D823E6ED0952E053BC48F20A9210

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