Oracle Database Errors or Warnings from Error ORA-16821 to ORA-16830

SQLServerF1

ORA-16821: logical standby database dictionary not yet loaded
Cause: The logical standby database had not loaded the dictionary. This status was detected by the broker health check mechanism. Alternatively, this status may be returned when attempting to switch or fail over to a logical standby database that had not yet loaded its dictionary.
Action: Start SQL Apply on the logical standby database, if it is not already running, and wait for it to reach the APPLYING state.
ORA-16822: new primary database not yet ready for standby database reinstatement
Cause: The new primary database, as a result of a logical standby database failover operation, had not fully completed the failover operation. An attempt to reinstate a disabled standby database could not be completed until failover completed on the new primary database.
Action: Wait until the failover operation has completed on the new primary database. Then retry the reinstate operation.
ORA-16823: redo transport mode is incompatible for current operation
Cause: The redo transport mode of this database was incompatible for this broker operation.
Action: Reset the LogXptMode database property for this database and retry the broker operation.

ORA-16824: multiple warnings, including fast-start failover-related warnings, detected for the database
Cause: The broker detected multiple warnings for the database. At least one of these warnings may have prevented fast-start failover from occurring.
Action: Check the StatusReport monitorable property of the database specified.
ORA-16825: multiple errors or warnings, including fast-start failover-related errors or warnings, detected for the database
Cause: The broker detected multiple errors or warnings for the database. At least one of these errors or warnings may have prevented a fast-start failover from occurring.
Action: Check the StatusReport monitorable property of the database specified.
ORA-16826: apply service state is inconsistent with the DelayMins property
Cause: This warning was caused by one of the following reasons:
– The apply service was started without specifying the real-time apply option or without the NODELAY option when the DelayMins property was set to zero.

– The apply service was started with the real-time apply option or with the NODELAY option when the DelayMins property was set to a value greater than zero.

Action: Reenable the standby database to allow the broker to restart the apply service with the apply options that are consistent with the specified value of the DelayMins property.

ORA-16827: Flashback Database is disabled
Cause: The broker detected that the Flashback Database feature was disabled. With Flashback Database disabled, the broker would not be able to:
– reinstate a database that required reinstatement.

– convert a physical standby database to a snapshot standby database.

– convert a snapshot standby database to a physical standby database. Flashback Database may been disabled manually with the ALTER DATABASE FLASHBACK DATABASE OFF command or automatically by the database in the event of an error.

Action: Check the database alert log to determine whether Flashback Database was disabled due to errors and then correct the problem. If Flashback Database had been manually disabled, reenable Flashback Database with the ALTER DATABASE FLASHBACK DATABASE ON command. If, after enabling Flashback Database, the database still cannot be reinstated or converted, you must re-create the database from a copy of the primary database.
ORA-16828: invalid value specified for REDO_TRANSPORT_USER initialization parameter
Cause: An invalid value was specified for the REDO_TRANSPORT_USER initialization parameter. The length of the user name exceeded 30 characters.
Action: Check the documentation and specify a new value for the REDO_TRANSPORT_USER initialization parameter.
ORA-16829: fast-start failover configuration is lagging
Cause: The fast-start failover target standby database was not within the lag limit specified by the FastStartFailoverLagLimit configuration property. As a result, a fast-start failover could not happen in the event of a primary database failure.
Action: Ensure that the fast-start failover target standby database is running and applying redo data and that the primary database is successfully trasmitting redo data. If this condition persists consider raising the value of the FastStartFailoverLagLimit configuration property.
ORA-16830: primary isolated from fast-start failover partners longer than FastStartFailoverThreshold seconds: shutting down
Cause: The primary database was isolated from both the observer and target standby database for longer than the seconds specified by the FastStartFailoverThreshold property. A fast-start failover probably occurred. If the FastStartFailoverPmyShutdown configuration property was set to TRUE, the broker will shut down the primary database in this situation.
Action: Ensure one instance of this database is running and the database is mounted on that instance so that the broker may reinstate the old primary database.

Above are list of Oracle Database Errors or Warnings from Error ORA-16821 to ORA-16830 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *