The following is the ORA-16516 error message, you can learn the cause and solution of the Oracle database error.


ORA-16516 the resource state is invalid for the attempted operation

Cause: The broker will return this error for switchover operations and for resource state change operations. If this error is returned for a switchover operation, then the broker has determined that either:

  • The sites changing roles are offline.
  • The primary database is not shipping log files.
  • The standby database that will become the primary is not applying log files.

The broker returns this error for resource state change operations if the resource state specified is invalid for the resource.

Solution: If this error is returned when attempting a switchover operation, then make sure that:

  • The sites changing roles are online.
  • The primary database is shipping log files.
  • The standby database is applying log files.

If this error is returned when attempting a resource state change operation, then make sure you specify a valid state for the resource.

Case:

Please wait for the update…