Oracle 11g Error Codes and Solution Suggestions from ORA-16100 to ORA-16200
- ORA-16100: not a valid Logical Standby database
- Cause: This database has not been completely configured as a Logical Standby database.
- Action: Verify that the database is the intended Logical Standby database. Ensure that you already started logical standby apply with the ALTER DATABASE START LOGICAL APPLY INITIAL statement. See the Oracle8i SQL Reference manual for the statement syntax.
- ORA-16101: a valid start SCN could not be found
- Cause: An SCN from which to start could not be found.
- Action: Register the first log file following the backup from which this database was generated. Using the ALTER DATABASE REGISTER LOGILE statement to register the database is recommended. Alternatively, you can provide a starting SCN value with this startement.
- ORA-16102: remote information is not available on the specified primary
- Cause: The new primary has not completed generating the necessary information for the standby to begin consuming its log stream.
- Action: Verify that the database link provided references a system that is about to become a new primary. Wait a short time before retrying the command to allow the primary some time to generate the necessary information.
- ORA-16103: Logical Standby apply must be stopped to allow this operation
- Cause: Logical Standby is currently applying changes. The apply must complete or be stopped to allow the requested operation.
- Action: Execute the ALTER DATABASE STOP LOGICAL STANDBY APPLY statement, then re-enter or respecify the operation.
- ORA-16104: Invalid Logical Standby parameter
- Cause: The specified parameter is not valid.
- Action: Check spelling or refer to the DBMS_LOGSTDBY PL/SQL package documentation for the correct statement syntax.
- ORA-16105: Logical Standby is already running in background
- Cause: A Logical Standby apply operation is already running.
- Action: None
- ORA-16106: loading previously applied transaction information
- Cause: Logical Standby coordinator was performing a scan to identify previously applied transactions.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16107: all log data from primary has been processed
- Cause: On the primary system, the log stream has been ended by the ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL STANDBY command.
- Action: Issue one of the following commands to make this standby a primary or resume applying changes from a new primary. ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL PRIMARY; ALTER DATABASE START LOGICAL STANDBY APPLY NEW PRIMARY dblink;
- ORA-16108: database is no longer a standby database
- Cause: The current database has already been made a primary database.
- Action: Issue the following commands to make this primary a standby. ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL STANDBY; ALTER DATABASE START LOGICAL STANDBY APPLY NEW PRIMARY dblink;
- ORA-16109: failed to apply log data from previous primary
- Cause: Log data from previous primary could not be completely applied.
- Action: . Then, reissue command.
- ORA-16110: user procedure processing of logical standby apply DDL
- Cause: A user provided stored procedure has been called to inspect a DDL statement prior to it being processed.
- Action: No action necessary, this informational statement is provided to record user involvement in the processing of a statement. Additional information can be found in the DBA_LOGSTDBY_EVENTS and the DBA_LOGSTDBY_SKIP views.
- ORA-16111: log mining and apply setting up
- Cause: This logical standby process is setting up to begin processing changes.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16112: log mining and apply stopping
- Cause: This logical standby process is cleaning up and stopping Logical Standby apply.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16113: applying change to table or sequence string
- Cause: The process is applying changes to a specific schema object.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16114: applying DDL transaction with commit SCN string
- Cause: The process is applying a DDL change that’s committed at the given SCN.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16115: string\% of LogMiner dictionary loading is done
- Cause: The process is loading dictionary information from the redo stream. This activity may take a few minutes.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16116: no work available
- Cause: The process is idle waiting for additional changes to be made available.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16117: processing
- Cause: The process is performing its primary function and is not waiting on any significant event.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16119: building transaction at SCN string
- Cause: The transaction being committed at the given SCN is being prepared for apply.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16120: dependencies being computed for transaction at SCN string
- Cause: The transaction committed at the given SCN is being analyzed for dependencies.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16121: applying transaction with commit SCN string
- Cause: The transaction committed at the given SCN is being applied.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16122: applying large dml transaction at SCN string
- Cause: A large transaction is being applied before the commit has been seen. The current redo being applied ends as the given SCN.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16123: transaction string string string is waiting for commit approval
- Cause: The apply process is waiting for approval to commit a transaction. This transaction may depend on another or other synchronization activity may delay the committing of a transaction.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16124: transaction string string string is waiting on another transaction
- Cause: The apply process is waiting to apply additional changes. This transaction likely depends on another.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16125: large transaction string string string is waiting for more data
- Cause: The apply process is waiting until additional changes for a large transaction are retrieved from the log stream.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16126: loading table or sequence string
- Cause: Information on the given table or sequence is being loaded into an in memory cache for future use.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16127: stalled waiting for additional transactions to be applied
- Cause: This process is waiting for additional memory before continuing. Additional log information cannot be read into memory until more transactions have been applied to the database, thus freeing up additional memory.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes. If this message occurs often and changes are not being applied quickly, increase available SGA or the number of apply processes.
- ORA-16128: User initiated stop apply successfully completed
- Cause: Logical standby was shutdown in an orderly fashion.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16129: unsupported DML encountered
- Cause: One or more DMLs to an unsupported table were encountered and skipped.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes. Optionally, check the DBA_LOGSTDBY_EVENTS view for more information including the impacted table owner and name.
- ORA-16130: supplemental log information is missing from log stream
- Cause: Supplemental logging is not enabled at the primary database.
- Action: Issue the following command to enable supplemental logging. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;
- ORA-16131: An error occurred during a Terminal Recovery of the standby.
- Cause: An error occurred during a Terminal Recovery of the standby.
- Action: Check the standby alert log additional information.
- ORA-16132: An error occurred during activation of the standby.
- Cause: An error occurred during activation of the standby database following a Terminal Recovery.
- Action: Check the standby alert log additional information.
- ORA-16133: Datafile string has incorrect terminal recovery stamp.
- Cause: After activation of a standby database following a terminal recovery (recovery of standby using current logs), recovery of a datafile from before the activation must have completed the same terminal recovery to avoid corruption.
- Action: A backup of the datafile taken after the terminal recovery and before activating the standby must be used for recovery.
- ORA-16134: invalid MANAGED recovery FINISH option
- Cause: A mode other than NOWAIT follows the FINISH keyword in RECOVER MANAGED STANDBY DATABASE statement.
- Action: Specify either nothing or NOWAIT following FINISH.
- ORA-16135: Invalid LOG_ARCHIVE_CONFIG modification while in protected mode
- Cause: The LOG_ARCHIVE_CONFIG parameter can not be modified while any RAC instance is open in either maximum protection or maximum availability mode. Also, the parameter can not be modified in such way that would cause all destinations to fail while in maximum protection mode.
- Action: Make the modification before the database is opened by any instance.
- ORA-16136: Managed Standby Recovery not active
- Cause: An attempt was made to cancel a managed recovery session but no managed recovery session was active.
- Action: No action is necessary.
- ORA-16138: end of log stream not received from primary
- Cause: The standby system has not received notification that the primary system log stream has been terminated. A graceful switchover is not possible.
- Action: Verify that the primary log stream has been terminated. Ensure that the standby has applied all necessary redo from the primary system and, if appropriate, reissue the graceful switchover command.
- ORA-16139: media recovery required
- Cause: An error has occurred while performing a switchover.
- Action: If you were switching a primary database to the standby role, the conversion was successful, but one or more errors occurred after the conversion completed. See the alert log for more information. You can proceed with switching the target standby database to the primary role, but you must address the errors reported at the old primary database before it can protect the new primary database. If you encountered this error while switching a physical standby database to the primary role, the switchover did not succeed because additional redo must be applied. Verify that redo apply is active and wait until the SWITCHOVER_STATUS column of the V$DATABASE dynamic performance view reports TO_PRIMARY or SESSIONS_ACTIVE before retrying the switchover.
- ORA-16140: standby online logs have not been recovered
- Cause: The standby database has online logs containing redo that has not been recovered. Activating the standby would lose redo contained in the online logs.
- Action: To recover the standby online logs issue the following command: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH. Then reissue the ALTER DATABASE ACTIVATE STANDBY DATABASE command. To activate the standby without recovering the online logs, issue the following command: ALTER DATABASE ACTIVATE STANDBY DATABASE SKIP STANDBY LOGFILE.
- ORA-16143: RFS connections not allowed during or after terminal recovery
- Cause: An attempt was made, by an RFS process, to access a standby online log file during or after a terminal recovery.
- Action: The primary must not attempt to archive to the standby after a terminal recovery.
- ORA-16145: archival for thread# string sequence# string in progress
- Cause: The indicated archived log file is not available for recovery due to the fact that it is still being archived.
- Action: Verify that archival of the indicated log file has completed and reissue the RECOVER STANDBY DATABASE command.
- ORA-16146: stringcontrol file enqueue unavailable
- Cause: The control file enqueue is currently unavailable.
- Action: No Action is required. We will try to re-fetch it at a later time.
- ORA-16147: standby database referenced by multiple archive log destinations
- Cause: Multiple archive log destinations reference the same standby database, using different service names. This is not allowed.
- Action: Remove one of the duplicate archive log destinations.
- ORA-16148: user requested expiration of managed recovery operation
- Cause: The managed standby database recovery operation has been canceled per user specified EXPIRE option of the RECOVER MANAGED STANDBY DATABASE statement.
- Action: No action is required.
- ORA-16150: FINISH recovery performed on another, older standby database
- Cause: An archive log containing a FINISH recovery indicator was received by a standby database that has received archive logs in the future of the received archive log. Because of the possibility that these future archive logs have been applied to this standby database, the received archive log must be rejected.
- Action: No action is required.
- ORA-16151: Managed Standby Recovery not available
- Cause: The attempted operation failed because of a pending CANCEL of the managed standby recovery operation.
- Action: Wait for the managed standby recovery session to end. Then retry the operation.
- ORA-16152: standby database is in ‘no-data-loss’ protected mode
- Cause: The attempted database operation is not allowed while the standby database is in ‘no-data-loss’ protected mode.
- Action: Verify that the attempted database operation is warranted, ALTER DATABASE SET STANDBY DATABASE UNPROTECTED and reissue the statement.
- ORA-16154: suspect attribute: string
- Cause: Use of the indicated attribute is illegal in the given context.
- Action: Make the appropriate changes and reissue the statement.
- ORA-16156: LGWR archive log dependency not allowed if database is standby protected
- Cause: The use of a LGWR archive log dependency is not allowed when the primary is protected by a standby database, as this requires use of the standby redo log files.
- Action: Remove the LGWR archive log dependency and use normal LGWR archival instead.
- ORA-16157: media recovery not allowed following successful FINISH recovery
- Cause: A RECOVER MANAGED STANDBY DATABASE FINISH command has previously completed successfully. Another media recovery is not allowed.
- Action: Issue one of these operations following a FINISH recocvery: ALTER DATABASE OPEN READ ONLY or ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY.
- ORA-16159: Cannot change protected standby destination attributes
- Cause: An attempt was made to change the LGWR/ARCH or SYNC/ASYNC attributes for a destination that is participating in the standby protection mode of the database.
- Action: No action is required.
- ORA-16160: Cannot change protected standby database configuration
- Cause: An attempt was made to change the standby database configuration when the primary database is in standby protected mode.
- Action: The standby database must be added to the configuration before the primary database is opened.
- ORA-16161: Cannot mix standby and online redo log file members for group string
- Cause: An attempt was made to add a log file member that did not match the other member types. This problem typically occurs when adding a standby log file member to an online redo log file group, or adding an online redo log file member to a standby redo log file group.
- Action: Verify the log file group type using the TYPE column of the V$LOG fixed view.
- ORA-16162: Cannot add new standby databases to protected configuration
- Cause: An attempt was made to enable a new standby database destination when the primary database is in standby protected mode.
- Action: The standby database must be added to the configuration before the primary database is opened.
- ORA-16163: LGWR network server host attach error
- Cause: The LGWR network server could not attach to remote host
- Action: The alert log contains more problem-specific information
- ORA-16164: LGWR network server host detach error
- Cause: The LGWR network server could not detach from remote host
- Action: The alert log contains more problem-specific information
- ORA-16165: LGWR failed to hear from network server
- Cause: The LGWR lost its connection to the network server
- Action: The alert log contains more problem-specific information
- ORA-16166: LGWR network server failed to send remote message
- Cause: The LGWR network server could not communicate with the remote host
- Action: The alert log contains more problem-specific information
- ORA-16167: LGWR network server could not switch to non-blocking mode
- Cause: The LGWR network server could not switch to non-blocking mode
- Action: The alert log contains more problem-specific information
- ORA-16168: LGWR network server could not switch to blocking mode
- Cause: The LGWR network server could not switch to blocking mode
- Action: The alert log contains more problem-specific information
- ORA-16169: LGWR network server invalid parameters
- Cause: The LGWR network server could not switch to blocking mode
- Action: The alert log contains more problem-specific information
- ORA-16170: Terminal recovery may have left the database in an inconsistent state
- Cause: When terminal recovery is invoked in a standby database without synchronous log shipping, in the rare case of the recovery session being in an unrecoverable state, terminal recovery cannot bring the standby database to a consistent SCN boundary if the primary database continues to have redo thread(s) open.
- Action: Continue standby recovery with additional log shipping from primary.
- ORA-16171: RECOVER…FINISH not allowed due to gap for thr string, seq string–string
- Cause: See alert log for more details
- Action: Copy missing archived logs from primary or another standby. Register the logs and reissue the RECOVER…FINISH command. If the logs are not available, issue the ALTER DATABASE RECOVER MANAGED STANDBY SKIP command to ignore the standby redo log files.
- ORA-16172: archive logs detected beyond Terminal End-Of-Redo
- Cause: An attempt to archive a Terminal End-Of-Redo archive log to a remote destination failed due the existence, at the remote site, of archive logs containing REDO in the future of the Terminal EOR.
- Action: None
- ORA-16173: incompatible archival network connections active
- Cause: One of two situations can cause this error: 1) An attempt to start a Terminal Incomplete Recovery operation failed due to an active Remote File Server process detected. 2) An attempt to archive a Terminal End-Of-Redo archive log to a remote destination failed due to an active Remote File Server process at the remote site. An active Remote File Server (RFS) process implies connectivity with the primary database which may indicate that a Terminal Incomplete Recovery operation is not warrented.
- Action: Verify the Managed Standby environment and re-evaluate the necessity of a Terminal Incomplete Recovery operation.
- ORA-16174: user requested thread/sequence termination of managed recovery
- Cause: The managed standby database recovery operation has been terminated per user specified THROUGH THREAD/SEQUENCE option of the RECOVER MANAGED STANDBY DATABASE statement.
- Action: No action is required.
- ORA-16175: cannot shut down database when media recovery is active
- Cause: An attempt was made to shut down a standby database while media recovery was active.
- Action: Cancel media recovery to proceed with the shutdown.
- ORA-16176: background dictionary build cannot be running
- Cause: The background process dedicated to dictionary build is active.
- Action: wait and try it later.
- ORA-16177: media recovery is not required
- Cause: The THROUGH LAST SWITCHOVER clause of the ALTER DATABASE RECOVER MANAGED STANDBY DATABASE was specified and the database has been recovered to the most recent End-Of-Redo marker. All known archived logs have been applied. Managed recovery is not required.
- Action: No action is necessary. The standby database may be activated as a new primary or may continue as a standby.
- ORA-16178: Cannot specify remote destinations in manual archiving mode
- Cause: The database is operating in manual archiving mode. Remote archivelog destinations are not allowed in this mode.
- Action: Use the ALTER DATABASE ARCHIVELOG command to place the database in automatic ARCHIVELOG mode, or defer the archivelog destinations that specify the SERVICE= attribute.
- ORA-16179: incremental changes to “string” not allowed with SPFILE
- Cause: Incremental changes to a log_archive_dest_n parameter cannot be made when using an SPFILE.
- Action: Specify either LOCATION or SERVICE plus all other attributes to be set in one ALTER SYSTEM/SESSION SET command.
- ORA-16180: number of processes specified is too large
- Cause: The number of server processes available for Logical Standby is currently limited to 1024 LogMiner processes and 1024 apply processes or a total of 2048.
- Action: Retry with a lower value.
- ORA-16181: SGA specified for Logical Standby is too large
- Cause: MAX_SGA is larger than 75% of the larger of initialization parameters SHARED_POOL_SIZE, MEMORY_TARGET, and SGA_TARGET.
- Action: Specify the value of MAX_SGA to be less than 75% of the maximum of SHARED_POOL_SIZE, MEMORY_TARGET, and SGA_TARGET.
- ORA-16182: Internal error on internal channel during remote archival
- Cause: An internal error was encountered on the internal channel between LGWR and Network Server.
- Action: No action is required, as an attempt will be made to re-archive the file that had this failure during archival.
- ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string
- Cause: The internal hash value generated for one DB_UNIQUE_NAME collided with the hash value of another DB_UNIQUE_NAME.
- Action: Slightly modify one of the DB_UNIQUE_NAMEs so it hashes to a different value.
- ORA-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
- Cause: Both the REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG parameters are defined in the initialization file and they are mutually exclusive.
- Action: The REMOTE_ARCHIVE_ENABLE parameter has been made obsolete. Use only the LOG_ARCHIVE_CONFIG parameter.
- ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID=’*’ qualifier
- Cause: The setting for the LOG_ARCHIVE_CONFIG parameter must be exactly the same on all RAC instances so the SID=’*’ qualifier is required.
- Action: Re-enter the command using the SID=’*’ qualifier.
- ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
- Cause: The LOG_ARCHIVE_CONFIG parameter was specified with duplicate, conflicting or invalid attributes.
- Action: Check the documentation regarding the correct specification of the LOG_ARCHIVE_CONFIG parameter.
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- Cause: The settings for the LOG_ARCHIVE_CONFIG parameter are inconsistent with the settings of a previously started instance. The settings for this parameter must be exactly the same for all instances.
- Action: Make sure all instances use the exact same LOG_ARCHIVE_CONFIG settings.
- ORA-16191: Primary log shipping client not logged on standby
- Cause: An attempt to ship redo to standby without logging on to standby or with invalid user credentials.
- Action: Check that primary and standby are using password files and that both primary and standby have the same SYS password. Restart primary and/or standby after ensuring that password file is accessible and REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to SHARED or EXCLUSIVE.
- ORA-16192: Primary and standby network integrity mismatch
- Cause: Standby wants sqlnet network integrity for redo shipment which is not configured properly at the primary.
- Action: Check sqlnet.ora documentation regarding how to setup network integrity and set it up identically on both primary and standby. Restart primary and/or standby.
- ORA-16193: Primary and standby network encryption mismatch
- Cause: Standby wants sqlnet network encryption for redo shipment which is not configured properly at the primary.
- Action: Check sqlnet.ora documentation regarding how to setup network encryption and set it up identically on both primary and standby. Restart primary and/or standby.
- ORA-16194: Modifying DB_UNIQUE_NAME requires SID=’*’ qualifier
- Cause: The setting for the DB_UNIQUE_NAME parameter must be exactly the same on all RAC instances so the SID=’*’ qualifier is required.
- Action: Re-enter the command using the SID=’*’ qualifier.
- ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
- Cause: The DG_CONFIG attribute of the LOG_ARCHIVE_CONFIG parameter can only be used if the DB_UNIQUE_NAME parameter has been explicitly defined.
- Action: Explicitly define a valid DB_UNIQUE_NAME.
- ORA-16196: database has been previously opened and closed
- Cause: The instance has already opened and closed the database, which is allowed only once in its lifetime.
- Action: Shut down the instance.
- ORA-16197: Invalid DB_UNIQUE_NAME parameter specification
- Cause: The DB_UNIQUE_NAME parameter has an invalid specification. The DB_UNIQUE_NAME parameter has a maximum length of 30 characters and the only characters allowed are alpha-numeric characters and “_”, “$” and “#”.
- Action: Check the documentation and re-enter the parameter.
- ORA-16198: Timeout incurred on internal channel during remote archival
- Cause: A timeout was incurred during remote archival.
- Action: No action is required, as an attempt will be made to re-archive the file that had this failure during archival.
- ORA-16199: Terminal recovery failed to recover to a consistent point
- Cause: See alert log for more details
- Action: Try to resolve the problem. Retry terminal recovery. If the problem occurs repeatedly and cannot be resolved, call Oracle support.
- ORA-16200: Skip procedure requested to skip statement
- Cause: Logical standby called a skip procedure that requested for a particular statement not to be applied.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.