My Oracle Support Banner

Database Fleet Management UPDATE_RACDB & ROLLBACK_RACDB Fails (Doc ID 2431548.1)

Last updated on AUGUST 03, 2018

Applies to:

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

Symptoms

Environment: 2-node RAC Database
Database Fleet Management: UPDATE_RACDB & ROLLBACK_RACDB Fails

Failing procedure steps:

Update or Switches Oracle Instances
Switch Database
Switch Cluster Database
For all hosts: Steps for destination Oracle home
Apply PSU / Patches on the database

1)
Initially use commands:

emcli db_software_maintenance -performOperation \
-name="Update 12102 RACDB Home" \
-purpose=UPDATE_RACDB \
-target_type=rac_database \
-target_list="TS951CDB_PRIMARY1" \
-normal_credential=ORACLE_SSH_DEV:GCADMIN \
-privilege_credential=ORACLE_PRIV_DEV:GCADMIN \
-rolling=false \
-dataguard_role=PRIMARY

2)
At this point, the DB is in a 'mixed' state - where one instance came up.

srvctl status database -d TS951CDB_PRIMARY1
Instance TS951CDB1 is not running on node svp4951bdv
Instance TS951CDB2 is running on node svp4952bdv

Results:
The /oratab got updated
The files from 'dbs', tnsnames, sqlnet.ora did NOT get copied over

Workaround:
The parameter "cluster_database" was changed to FALSE, if you change to TRUE
then both instances come up.

3)
Subsequently if you try to "rollback" the RAC DB back to its original home,
it fails.

emcli db_software_maintenance -performOperation \
-name="Rollback RAC DB" \
-purpose=ROLLBACK_RACDB \
-target_type=rac_database \
-target_list="TS951CDB_PRIMARY1" \
-normal_credential=ORACLE_SSH_DEV:GCADMIN \
-privilege_credential=ORACLE_PRIV_DEV:GCADMIN \
-rolling=false \
-node_list="svp4951bdv.dev.schwab.com,svp4952bdv.dev.schwab.com"

--
Processing target "TS951CDB_PRIMARY1"...
Checking image subscription...
Check image subscription passed.
Destination home not found. Possible causes are either the Oracle home was
not deployed in case you're trying to do a update or the Oracle home has been
cleaned up in case you're trying to do a cleanup.
Already running on the same Oracle Home.
ERROR: Operation could not be completed

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!


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