Unable to switchover database roles back to the default after a failover (Error: ORA-16608: one or more databases have warnings)
Originally Published: 2010-06-14
Article Number
Applies To
Issue
Unable to switchover database roles back to the default after a failover (Error: ORA-16608: one or more databases have warnings)
An attempt (through rkmawa => Operations => Cluster => Make Primary button) to switchover roles back to the default configuration failed with the following error:
Cluster Settings
Message:
Make primary performed on cluster XXXX; output:
Switching over to xxxxrkmp
DGMGRL for Linux: Version 10.2.0.4.0 - Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
Performing switchover NOW, please wait...
Error: ORA-16608: one or more databases have warnings
Failed.
Unable to switchover, primary database is still "xxxxrkms"
Resolution
1. Check detailed status of Oracle DataGuard and Fast Start FailOver using either the status pages tool ( How to check status or health of RKM Appliance for troubleshooting purposes? ) or the following commands (shown in red while replacing xxxxrkm, xxxxrkmp, and xxxxrkms with your installation specific names):
Log in to shell prompt as root
[root@rkmapp1 ~]# su - oracle
-bash-3.00$ dgmgrl
DGMGRL for Linux: Version 10.2.0.4.0 - Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password: <== provide Oracle password
Connected.
DGMGRL> show configuration verbose
Configuration
Name: xxxxrkm
Enabled: YES
Protection Mode: MaxAvailability
Fast-Start Failover: ENABLED
Databases:
xxxxrkmp - Primary database
xxxxrkms - Physical standby database
- Fast-Start Failover target
Fast-Start Failover
Threshold: 30 seconds
Observer: rkmapp2.domain.com
Shutdown Primary: FALSE
Current status for "xxxxrkm":
SUCCESS
DGMGRL> show database xxxrkmp
Database
Name: xxxxrkmp
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
XXXXRKM
Current status for "xxxxrkmp":
SUCCESS
DGMGRL> show database xxxrkms
Database
Name: xxxxrkms
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
XXXXRKM
Current status for "xxxxrkms":
SUCCESS
2. Review the output of above commands/tool. The example shown above is normal/correct output. In case of an error or failure, specific Oracle error code will show in the output. Depending upon the error condition(s), take corrective steps to resolve those error conditions.
3. If you see a combination of the following errors, take steps provided in solution "Oracle DataGuard and FSFO status check shows ORA-16607 ORA-12541 and ORA-16825":
ORA-16607: one or more databases have failed
ORA-12541: TNS:no listener
ORA-16825: Fast-Start Failover and other errors or warnings detected for the database
4. If you see a combination of the following errors, take steps provided in solution "ORA-16766: Redo Apply unexpectedly offline":
ORA-16607: one or more databases have failed
ORA-16766: Redo Apply unexpectedly offline
5. Once the actual error conditions have been rectified, and Oracle DataGuard/FSFO output shows normal like shown in step #1 above, an attempt to switchover database roles back to the default should work fine.
Workaround
Related Articles
RSA Identity Governance and Lifecycle error when using the IBM DB2 driver: "Unable to load database driver" Number of Views On RSA Via Lifecycle and Governance the aveksa_server start returns message: Cannot connect to the database, but the DB is up Number of Views How to manually sync a replica in an RSA Authentication Manager 8.x deployment with one or more replicas Number of Views Test connection failed. One or more directory connections is incorrect error during testing connection from RSA Authentica… Number of Views How to stop RSA Via Lifecycle & Governance (IMG) review items from reverting back to the default state after a change requ… Number of Views
Trending Articles
RSA-2026-07: RSA Identity Router Security Update for Third-Party Component Vulnerabilities How to add a static route in RSA Authentication Manager 8.x Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
