How to fix the Oracle error ORA-16623: database detected role change?

In this post, you’ll learn more about the Oracle ErrorORA-16623: database detected role change with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16623: database detected role change

Reason for the Error ORA-16623: database detected role change

A successful switchover or failover operation had been completed and was detected during database startup or broker health check. If this database was unavailable during a switchover or failover operation, it may not be a viable standby database for the new primary database and was disabled by the Data Guard broker.

How to fix the Error ORA-16623: database detected role change ?

You can fix this error in Oracle by following the below steps

Connect to the new primary database and examine the broker configuration for databases that were disabled and that may require reinstatement or re-creation.