Oracle 11g Error Codes and Solution Suggestions from ORA-16100 to ORA-16200

Posted on by Fatih Acar

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.

Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.