Oracle 11g Error Codes and Solution Suggestions from ORA-16700 to ORA-16800
- ORA-16700: the standby database has diverged from the primary database
- Cause: The primary database may have been flashed back or restored from a backup set and then reopened with the RESETLOGS option.
- Action: Re-create the standby database from the primary database or flash back the standby database to the same point the primary database had been flashed back to.
- ORA-16701: Data Guard broker command failed
- Cause: Command to modify or query the database failed.
- Action: Check the Data Guard broker log for the reason for the failure, and reissue the command.
- ORA-16702: Data Guard broker command warning
- Cause: A command to modify or query the database resulted in a warning.
- Action: Check the Data Guard broker log for the warning and, if necessary, reissue the command.
- ORA-16703: cannot set property while the database is enabled
- Cause: An attempt was made to change a database property while the database was enabled.
- Action: Disable the database first, update the property and then, reenable the database.
- ORA-16706: Data Guard broker worker process not available
- Cause: The Data Guard broker worker process was not available to service the request.
- Action: Contact Oracle Support Services.
- ORA-16707: the value of the property string is invalid, valid values are string
- Cause: An invalid property value was specified while broker management of the database was disabled.
- Action: Reset the property to a valid value.
- ORA-16708: the state supplied to broker is invalid
- Cause: The state name specified was invalid for the database.
- Action: Check the state name and reissue the request.
- ORA-16709: standby archived log location settings conflict with database recovery area
- Cause: The StandbyArchiveLocation or AlternateLocation property was set to USE_DB_RECOVERY_FILE_DEST, but the initialization parameter DB_RECOVERY_FILE_DEST did not specify a valid destination.
- Action: Use a value other than USE_DB_RECOVERY_FILE_DEST for StandbyArchiveLocation or AlternateLocation, or set up a valid database recovery area by setting DB_RECOVERY_FILE_DEST to a valid destination.
- ORA-16710: snapshot standby database should be converted back to a physical standby database as soon as possible
- Cause: A failover causes this snapshot standby database to enter a state that requires it to be re-created if another failover occurs before it is converted back to a physical standby database.
- Action: Reenable the snapshot standby database if it is disabled and convert it back to a physical standby database as soon as possible because the snapshot standby database will have to be re-created if another failover occurs while it is in this state.
- ORA-16713: the Data Guard broker command timed out
- Cause: The Data Guard broker timed out the command.
- Action: Verify that the command is valid for the database and then retry the command.
- ORA-16714: the value of property string is inconsistent with the database setting
- Cause: The value of the specified configuration property was inconsistent with database in-memory settings or server parameter file settings. This may be caused by changing an initialization parameter that corresponds to a configuration property.
- Action: Query the InconsistentProperties property on the database to determine the which properties are set inconsistently. Reset the properties to make them with the database settings.
- ORA-16715: redo transport-related property string of standby database “string” is inconsistent
- Cause: The value of the specified redo transport-related configuration property of the given standby database was inconsistent with the primary database redo transport service setting. This may be caused by changing an initialization parameter that corresponds to a configuration property.
- Action: Query the InconsistentLogXptProps property on the primary database to determine which redo transport properties are set inconsistently Reset the properties on the standby database to make them consistent with the primary database redo transport settings.
- ORA-16716: clearing parameter LOG_ARCHIVE_DEST failed
- Cause: An attempt to clear the LOG_ARCHIVE_DEST parameter failed.
- Action: Contact Oracle Support Services.
- ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
- Cause: An attempt to clear the LOG_ARCHIVE_DUPLEX_DEST parameter failed.
- Action: Contact Oracle Support Services.
- ORA-16718: failed to locate database
- Cause: The Data Guard broker was unable to locate the database in the broker configuration.
- Action: Add the database to the broker configuration and then reissue the command.
- ORA-16719: unable to query V$ARCHIVE_DEST fixed view
- Cause: The broker failed to query the V$ARCHIVE_DEST fixed view.”
- Action: Test and clear the problem using SQL*Plus.
- ORA-16720: no LOG_ARCHIVE_DEST_n initialization parameters available
- Cause: All LOG_ARCHIVE_DEST_n initialization parameters were in use.
- Action: Clear one or more LOG_ARCHIVE_DEST_n initialization parameters so that broker can use them to set up the primary database redo transport.
- ORA-16721: unable to set LOG_ARCHIVE_DEST_n initialization parameters
- Cause: The broker was unable to set one or more LOG_ARCHIVE_DEST_n initialization parameters.
- Action: Check the Data Guard broker log and Oracle alert logs for more details.
- ORA-16722: unable to set LOG_ARCHIVE_DEST_STATE_n initialization parameters
- Cause: The broker was unable to set one or more LOG_ARCHIVE_DEST_STATE_n initialization parameters.
- Action: Check the Data Guard broker log and Oracle alert logs for more details.
- ORA-16723: setting AlternateLocation property conflicts with the redo transport setting
- Cause: The standby database was not using standby redo logs, and the redo transport service to the standby database is set to a nonzero value for the ReopenSecs property and a value of zero for the MaxFailure property. In this case, the redo transport service will attempt to send redo data to the standby database indefinitely and never switch to the alternate destination.
- Action: Any one of the following actions will solve the problem:
- – add standby redo logs to the standby database.
- – set ReopenSecs property to zero.
- – set MaxFailure property to a nonzero value. After performing one of the above actions, reset the standby database AlternateLocation property.
- ORA-16724: cannot resolve gap for one or more standby databases
- Cause: The primary database could not resolve a gap request from one or more standby databases.
- Action: To see which standby database has an unresolvable gap, check the status of the primary database using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command. Copy the missing archived log files from either backups or from another database in the configuration that has the files to the standby database that is missing the files.
- ORA-16727: cannot close database
- Cause: The Data Guard broker could not close the database.
- Action: Terminate any active sessions connected to the database and then reissue the request.
- ORA-16728: consistency check for property string found string error
- Cause: The consistency check for the specified property failed due to the error shown.
- Action: Check the error message and clear the error.
- ORA-16729: validation of value for property string found string error
- Cause: The property value validation failed due to the error shown.
- Action: Check the error message and clear the error.
- ORA-16730: error executing DBMS_LOGSTDBY.SKIP_TXN procedure
- Cause: Logical standby database package may not be installed.
- Action: Install logical standby database packages and reissue the request.
- ORA-16731: error executing DBMS_LOGSTDBY.UNSKIP_TXN procedure
- Cause: Logical standby database package may not be installed.
- Action: Install logical standby database packages and reissue the request.
- ORA-16732: error executing DBMS_LOGSTDBY.SKIP procedure
- Cause: Logical standby database package may not be installed.
- Action: Install logical standby database packages and reissue the request.
- ORA-16733: error executing DBMS_LOGSTDBY.UNSKIP procedure
- Cause: Logical standby database package may not be installed.
- Action: Install logical standby database packages and reissue the request.
- ORA-16734: error executing DBMS_LOGSTDBY.SKIP_ERROR procedure
- Cause: Logical standby database package may not be installed.
- Action: Install logical standby database packages and reissue the request.
- ORA-16735: error executing DBMS_LOGSTDBY.UNSKIP_ERROR procedure
- Cause: Logical standby database package may not be installed.
- Action: Install logical standby database packages and reissue the request.
- ORA-16736: unable to find the destination entry of standby database “string” in V$ARCHIVE_DEST
- Cause: Either the standby destination was manually changed or deleted outside of Data Guard broker, or no entry was available for the Data Guard broker to use.
- Action: Clean up the destination setting, remove the unused settings, and reset the redo transport service.
- ORA-16737: the redo transport service for standby database “string” has an error
- Cause: A communication problem with the standby database caused the redo transport to fail.
- Action: Query the LogXptStatus property to see the error message. Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16738: redo transport service for database “string” is not running
- Cause: The redo transport service for the specified standby database was not running.
- Action: Check the Data Guard broker log and/or the alert log for more details. If necessary, start the redo transport service for the standby database.
- ORA-16739: redo transport service for standby database “string” is running
- Cause: The redo transport service for the standby database was running.
- Action: Check the Data Guard broker log for more details. If necessary, stop the redo transport service for the standby database.
- ORA-16740: redo transport service for standby database “string” incorrectly set to ALTERNATE
- Cause: The redo transport service to the standby database was set to ALTERNATE when no other destination was set to alternate to this destination.
- Action: Reenable the standby database or the entire configuration to allow the configuration property settings to be propagated to the initialization parameters.
- ORA-16741: the destination parameter of standby database “string” has incorrect syntax
- Cause: The destination defined in the server parameter file of the primary database had incorrect syntax and Data Guard broker failed to update the destination when redo transport services were enabled.
- Action: Fix the syntax error in the primary database server parameter file or remove the entry from the server parameter file. Also, check the values of the redo transport-related properties for the specified standby database.
- ORA-16742: the standby database “string” has exhausted its quota
- Cause: The standby database exhausted its quota for storing archived redo logs.
- Action: Remove some archived redo logs from the standby database or increase its quota.
- ORA-16743: cannot determine status of redo transport service for standby database “string“
- Cause: The status of redo transport to the specified standby database could not be determined.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16744: the DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full
- Cause: The DG_CONFIG list of the LOG_ARCHIVE_CONFIG attribute was full and the Data Guard broker was not able to add a new DB_UNIQUE_NAME to the list.
- Action: Remove some unused entries in the DG_CONFIG list, then reenable the database.
- ORA-16745: unable to add DB_UNIQUE_NAME “string” into the DG_CONFIG list because it is full
- Cause: The DG_CONFIG list of the LOG_ARCHIVE_CONFIG attribute was full and the Data Guard broker was not able to add the specified DB_UNIQUE_NAME to the list.
- Action: Remove some unused entries in the DG_CONFIG list, then reenable the database.
- ORA-16746: Data Guard broker cannot mount the database
- Cause: The Data Guard broker failed to mount the database.”
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16747: logical standby database guard could not be turned on
- Cause: The Data Guard broker could not turn on the logical standby database guard.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16748: Data Guard broker cannot open the primary database
- Cause: The Data Guard broker failed to open the primary database” the database.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16749: switchover to logical standby database failed
- Cause: The Data Guard broker failed to switch a logical standby database over to a primary database.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16750: failed to activate logical standby database
- Cause: The Data Guard broker failed to activate a logical standby database.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16751: failed to switchover to physical standby database
- Cause: The Data Guard broker failed to switch a physical standby database over to a primary database.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16753: Data Guard broker cannot open standby database
- Cause: The Data Guard broker failed to open the standby database.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16754: failed to activate physical standby database
- Cause: The Data Guard broker failed to activate the physical standby database.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16755: failed to set initialization parameter
- Cause: The Data Guard broker failed to set an initialization parameter using either the ALTER SYSTEM SET or ALTER SYSTEM RESET command.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16757: unable to get this property’s value
- Cause: The Data Guard broker failed to get the value for the specified property, possibly because the specified property’s value is not available for the current database role.
- Action: If the specified property’s value is not available for the database’s current role, please specify this property for a database for which it is available. Otherwise, check the Data Guard broker log for more details.
- ORA-16758: the specified apply instance is not running
- Cause: The Data Guard broker could not start apply services on the specified instance because that instance was not running.
- Action: Start the instance and then retry the command.
- ORA-16759: cannot start SQL Apply with initial SCN
- Cause: The Data Guard broker failed to start SQL Apply with an initial SCN.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16760: cannot start SQL Apply
- Cause: The Data Guard broker failed to start SQL Apply.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16761: cannot stop SQL Apply
- Cause: The Data Guard broker failed to stop SQL Apply.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16762: invalid database state
- Cause: Database was not in the intended state.
- Action: Determine the reason why the database is not running in the intended state and reissue the command.
- ORA-16763: redo transport service for a standby database is running
- Cause: The redo transport service for a standby database was running.
- Action: For more details, check the status of the primary database using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command. If necessary, stop the redo transport service to the standby database.
- ORA-16764: redo transport service to a standby database is not running
- Cause: The redo transport service to a standby database was not running.
- Action: For more details, check the status of the primary database using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command. If necessary, start the redo transport service to the standby database.
- ORA-16765: Redo Apply is running
- Cause: Redo Apply was running when it should have been stopped.
- Action: If necessary, stop Redo Apply.
- ORA-16766: Redo Apply is stopped
- Cause: Redo Apply was stopped when it should have been running.
- Action: Check the alert log to see why Redo Apply terminated, correct any problems that may exist, and restart Redo Apply by setting the physical standby database state to APPLY-ON.
- ORA-16767: SQL Apply is running
- Cause: SQL Apply was running when it should have been stopped.”
- Action: If necessary, stop SQL Apply.
- ORA-16768: SQL Apply is stopped
- Cause: SQL Apply was stopped when it should have been running.”
- Action: Check the alert log to see why SQL Apply terminated, correct any problems that may exist, and restart SQL Apply by setting the logical standby database state to APPLY-ON.
- ORA-16769: the physical standby database is open read-only
- Cause: All instances in the physical standby database were put into a read-only state instead of APPLY-OFF.
- Action: Issue the EDIT DATABASE SET STATE command to set the database to the APPLY-OFF state.
- ORA-16770: Redo Apply not started since physical standby database is opening
- Cause: Redo Apply services could not be started on the physical standby database because it was being opened. The Data Guard broker will start Redo Apply services once the physical standby database has been opened.
- Action: No action required.
- ORA-16771: failover to a physical standby database failed
- Cause: The Data Guard broker encountered errors when converting a physical standby database to a primary database.
- Action: Check the Data Guard broker log and the Oracle alert log for more details about the error.
- ORA-16772: switchover to a standby database failed
- Cause: The Data Guard broker encountered errors when switching over to the specified standby database.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16773: cannot start Redo Apply
- Cause: The Data Guard broker failed to start Redo Apply.
- Action: Check the Data Guard broker log and Oracle alert log for more details. If the database is already open, the broker will not start Redo Apply if the Active Data Guard option is not enabled.
- ORA-16774: cannot stop Redo Apply
- Cause: The Data Guard broker failed to stop Redo Apply.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16775: target standby database in broker operation has potential data loss
- Cause: The target standby database specified for the broker operation did not have all the redo data from the primary database.
- Action: Confirm that the redo transport service on the primary database is functioning correctly by checking its status using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command. Reissue the broker command once all redo data is available on the target standby database.
- ORA-16776: health check of the redo transport service failed
- Cause: The Data Guard broker could not complete the health check for the redo transport service.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16777: unable to find the destination entry of a standby database in V$ARCHIVE_DEST
- Cause: Either a destination was manually deleted or no entry was available for Data Guard.
- Action: Check the Data Guard broker log and the Oracle alert log for more details. The redo transport service may need to be reset.
- ORA-16778: redo transport error for one or more databases
- Cause: The redo transport service was unable to send redo data to one or more standby databases.
- Action: Check the Data Guard broker log and Oracle alert log for more details. Query the LogXptStatus property to see the errors.
- ORA-16779: the destination parameter of a database is set incorrectly
- Cause: The destination was defined in the LOG_ARCHIVE_DEST_n server parameter file with incorrect syntax. The Data Guard broker failed to update the destination when the redo transport was turned on.
- Action: Check the Data Guard broker log to see which database has the problem. Fix the syntax error in the server parameter file or remove the entry from the server parameter file. Check if the syntax of the redo transport-related properties are correct.
- ORA-16780: a database has exhausted its archived redo log storage quota
- Cause: A database has exhausted its quota for storing archived redo logs.
- Action: Check the Data Guard broker log to see which database has the problem. Remove some archived logs at the standby database or increase its quota.
- ORA-16781: cannot determine status of redo transport service for standby database
- Cause: The status of redo transport to the specified standby database could not be determined.
- Action: Check the Data Guard broker log and Oracle alert log for more details.
- ORA-16782: instance not open for read and write access
- Cause: The database was mounted on an instance but not opened for read and write access.
- Action: For more details, check the status of the database using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command. If possible, open the instance manually.
- ORA-16783: cannot resolve gap for database string
- Cause: The primary database could not resolve a gap request from the specified standby database(s).
- Action: Copy the missing archived redo log files from either backups or from another database in the configuration that has the files to the standby database(s) missing the files.
- ORA-16784: database name specified by Dependency property is incorrect
- Cause: The database name, that should be the value of the DB_UNIQUE_NAME initialization parameter, specified in the Dependency property was incorrect.
- Action: Reset the Dependency property to the correct name of the database.
- ORA-16785: the database is in NOARCHIVELOG mode
- Cause: The database was in NOARCHIVELOG mode when it was either a primary database or when it was a standby database that was being switched over to be a primary database.
- Action: Set the database to ARCHIVELOG mode by issuing the ALTER DATABASE ARCHIVELOG command.
- ORA-16786: unable to access Data Guard broker configuration files
- Cause: The Data Guard broker configuration files did not exist or or could not be accessed.
- Action: Check the Data Guard broker log for more details.
- ORA-16788: unable to set one or more database configuration property values
- Cause: This situation occurred when the broker attempted to set database configurable property values into the database by issuing ALTER SYSTEM or ALTER DATABASE commands. Typical causes of this error are:
- – The values of redo transport-related properties contain syntax syntax errors.
- – The value of the LogArchiveTrace property was out of range.
- Action: Check the Data Guard broker log to see which property has the problem and set the property to the correct value.
- ORA-16789: standby redo logs not configured
- Cause: Standby redo logs were not configured for the database.
- Action: Standby redo logs are required when the redo transport mode is set to SYNC or ASYNC. Check the Data Guard documentation to see how to create standby redo logs.
- ORA-16790: the value of the configurable property is invalid
- Cause: An invalid property value was entered, or a RESET was attempted on a property for which no Broker default value exists.
- Action: Set the property to a correct value.
- ORA-16791: unable to check the existence of the standby redo logs
- Cause: The database may not be mounted, or the query of the V$STANDBY_LOG fixed view failed.
- Action: Ensure the database is mounted and query the V$STANDBY_LOG fixed view to see if the problem has been corrected, and retry the operation.
- ORA-16792: configurable property value is inconsistent with database setting
- Cause: The values of one or more configurable properties were inconsistent with database in-memory settings or server parameter file settings. This may happen by directly altering initialization parameters instead of editing configurable property values using Data Guard broker.
- Action: Query the InconsistentProperties property on the database or check the Data Guard broker log to find which properties are set inconsistently. Reset these properties to make them consistent with the database settings. Alternatively, enable the database or the entire configuration to allow the configurable property settings to be propagated to the initialization parameters.
- ORA-16793: logical standby database guard is off
- Cause: The logical standby database guard was turned off.
- Action: Issue the ALTER DATABASE GUARD ALL command to turn the guard on and verify that Data Guard health check error or warning is cleared.
- ORA-16794: database guard is on for primary database
- Cause: The database guard was turned on for the primary database.
- Action: Issue the ALTER DATABASE GUARD NONE command to turn off the guard and verify that Data Guard health check error or warning is cleared.
- ORA-16795: the standby database needs to be re-created
- Cause: A switchover or failover operation caused this database to require re-creation. The database was marked for re-creation because it was not a viable standby database for the new primary database. Until this error status is resolved for this database, information about this database and the broker configuration to which it belongs is unavailable to a broker client that is connected to this database. Therefore, all commands directed by that client to this database cannot be completed.
- Action: Re-create (or flash back) the standby database. Connect to the primary database in the broker configuration and reenable broker management of that database. Once enabled, it is possible to connect to that standby database and manage it with the broker. Alternatively, many client commands that cannot be completed at the standby database when in this error state can be completed successfully when issued to the primary database. In this case, simply reconnect to the primary database and retry the command.
- ORA-16796: one or more properties could not be imported from the database
- Cause: The broker was unable to import property values for the database being added to the broker configuration. This error indicates:
- – The Oracle Net service name specified in DGMGRL CREATE CONFIGURATION or ADD DATABASE command was not one that provides access to the database being added.
- – There were no instances running for the database being added.
- Action: Remove the database from the configuration using the REMOVE CONFIGURATION or REMOVE DATABASE command. Make sure that the database to be added has at least one instance running and that the Oracle Net service name provides access to the running instance. Also check the broker log file for additional information. Then, reissue the CREATE CONFIGURATION or ADD DATABASE command.
- ORA-16797: database is not using a server parameter file
- Cause: The database was not using a server parameter file or the broker was unable to access the server parameter file.
- Action: Issue the CREATE SPFILE=’..’ FROM PFILE=’…'” command to create a server parameter file and then restart the database to use it.
- ORA-16798: unable to complete recovery during failover
- Cause: The physical standby database could not complete recovery during failover.
- Action: Check the Data Guard broker log and the Oracle alert logs to see more details on the reason for the failure.
- ORA-16799: Redo Apply is not running
- Cause: Either the Data Guard broker configuration indicates that Redo Apply was turned off, or the recovery process, MRP0, was not running. As a result, Redo Apply-related properties could not be set.
- Action: Turn on Redo Apply through Data Guard broker and reissue the command to set a Redo Apply-related property.
- ORA-16800: redo transport service for a standby database incorrectly set to ALTERNATE
- Cause: The redo transport service for a standby database was set to ALTERNATE when no other destination is set to alternate to this destination.
- Action: Reenable the standby database or the entire configuration to allow the configuration property settings to be propagated to the initialization parameters.