Oracle 11g Error Codes and Solution Suggestions from ORA-16200 to ORA-16300
- 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.
- ORA-16201: Skip procedure requested to apply statement
- Cause: Logical standby called a skip procedure that requested for a particular statement to be applied.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16202: Skip procedure requested to replace statement
- Cause: Logical standby called a skip procedure that requested for a particular statement to be replaced with a new statement.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16203: Unable to interpret skip procedure return values
- Cause: The skip procedure returned conflicting or invalid values.
- Action: Ensure that the new_statement output parameter is non-NULL when returning DBMS_LOGSTDBY.SKIP_ACTION_REPLACE and NULL otherwise. Also ensure SKIP_ACTION is specified correctly.
- ORA-16204: DDL successfully applied
- Cause: A DDL statement has successfully commited on the logical standby database.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16205: DDL skipped due to skip setting
- Cause: A setting in the logical standby skip table indicates that this type of DDL should always be skipped.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16206: database already configured as Logical Standby database
- Cause: This database has been previously configured as a Logical Standby database. A Logical Standby database is not capable of processing the requested operation.
- Action: Ensure that you entered the command on the correct database as this database is a Logical Standby and is not capable of servicing the request.
- ORA-16207: Logical standby dictionary build not permitted.
- Cause: A dictionary build is currently in progress. Only one build can be active at a time.
- Action: Wait for the active build to complete before invoking a new build.
- ORA-16208: Logical standby dictionary build failed to start.
- Cause: Failure to start the logical standby dictionary build process (LSP1)
- Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.
- ORA-16209: Logical standby dictionary build failed to complete.
- Cause: The logical standby dictionary build process terminated abnormally.
- Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.
- ORA-16210: Logical standby coordinator process terminated with error
- Cause: The logical standby coordinator process terminated abnormally.
- Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.
- ORA-16211: unsupported record found in the archived redo log
- Cause: Log apply services encountered a record in the archived redo log that could not be interpreted.
- Action: 1. Use DBMS_LOGSTDBY.INSTANTIATE_TABLE to re-create the table on the standby database or simply drop the table if it’s unimportant.
- 2. ALTER DATABASE START LOGICAL STANDBY APPLY;
- 3. Examine the current_scn column in the DBA_LOGSTDBY_EVENTS view to determine which log file contains the unsupported record.
- 4. Provide the log file to Oracle Support Services.
- ORA-16212: number of processes specified for SQL Apply is too great
- Cause: Logical standby apply engine was started with more processes requested than are available.
- Action: Adjust the values of the initialization parameters PROCESSES or the MAX_SERVERS parameter seen in the DBA_LOGSTDBY_PARAMETERS view. If you did not specify MAX_SERVERS, but instead specified PREPARE_SERVERS and APPLY_SERVERS through the dbms_logstdby.apply_set procedure, you will need to decrease either one or both of them.
- ORA-16213: ddl encountered, stopping apply engine
- Cause: stop_on_ddl callout specified and DDL was encountered.
- Action: Either disable stop_on_ddl callout or remove DDL.
- ORA-16214: apply stalled for apply delay
- Cause: A delay has been specified on the primary database for this destination.
- Action: Either turn off the delay on the primary or use DBMS_LOGSTDBY.APPLY_UNSET(‘APPLY_DELAY’); to override.
- ORA-16215: history metadata inconsistency
- Cause: internal error.
- Action: This is an internal error. Contact Oracle support.
- ORA-16216: Log stream sequence error
- Cause: The log stream being processed did not follow the last processed stream.
- Action: If the database is in an active configuration, issue an ALTER DATABASE START LOGICAL STANDBY APPLY NEW PRIMARY command to synchronize log stream data with the current primary database. If the database is not in an active configuration, manually add the next dictionary-begin log file that followed the previous log stream.
- ORA-16217: prepare to switchover has not completed
- Cause: An ALTER DATABASE PREPARE TO SWITCHOVER command was issued, but the prepare activity did not complete.
- Action: Verify that the standby was prepared properly. You may cancel the prepare and perform an unprepared switchover which requires a database link to complete. Or reissue the prepare operation on the standby.
- ORA-16218: This database is already preparing to switch over.
- Cause: The database was already preparing to switch over and was not able to accomodate another prepare attempt.
- Action: Cancel the current prepare attempt with the ALTER DATABASE PREPARE TO SWITCHOVER CANCEL command, then reissue the prepare request.
- ORA-16219: This database is not preparing to switch over.
- Cause: The database was not preparing to switch over. Therefore, it was not possible to cancel the SWITCHOVER command.
- Action: Preparing for the SWITCHOVER command can be accomplished with the ALTER DATABASE PREPARE TO SWITCHOVER command.
- ORA-16220: no failed transaction found
- Cause: No failed transaction was found.
- Action: Retry the ALTER DATABASE START LOGICAL STANDBY APPLY command without the SKIP FAILED TRANSACTION option.
- ORA-16221: history table synchronization error
- Cause: internal error.
- Action: This is an internal error. Contact Oracle support.
- ORA-16222: automatic Logical Standby retry of last action
- Cause: A failure occurred while running Logical Standby apply. A new attempt is automatically being made by Logical Standby apply.
- Action: No action is necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16223: DDL skipped, unsupported in current version
- Cause: The given DDL statement was not supported in the current version of Logical Standby and was skipped.
- Action: No action is necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16224: Database Guard is enabled
- Cause: Operation could not be performed because database guard is enabled
- Action: Verify operation is correct and disable database guard
- ORA-16225: Missing LogMiner session name for Streams
- Cause: An attempt was made to register the log file for Streams without a specified LogMiner session name.
- Action: Specify a valid LogMiner session name to which the log file will be registered.
- ORA-16226: DDL skipped due to lack of support
- Cause: Logical Standby does not support this type of DDL in this version, so the DDL is skipped.
- Action: The DBA may apply the DDL explicitly at a later time or a procedure to handle this type of DDL can be created. see DBMS_LOGSTDBY.SKIP procedure for details.
- ORA-16227: DDL skipped due to missing object
- Cause: A table or other database object upon which this DDL depended was not defined on the Logical Standby database.
- Action: No action is necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16228: Insufficient recovery for logical standby
- Cause: Insufficient amount of recovery was run for logical standby instantiation.
- Action: Continue to recover the database using ALTER DATABASE RECOVER MANAGED STANDBY DATABASE.
- ORA-16229: PDML child string string string for parent string string string cannot be skipped.
- Cause: A request was made to skip a parallel DML child transaction id. This is not supported.
- Action: Using the DBMS_LOGSTDBY.UNSKIP_TRANSACTION procedure, remove the child transaction id, then specify the parent transaction id using DBMS_LOGSTDBY.SKIP_TRANSACTION if appropriate.
- ORA-16230: committing transaction string string string
- Cause: Logical Standby apply was committing changes for the given transaction.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16232: adding Logical Standby skip entry for table string.string
- Cause: Table was previously unsupported due to datatype or storage attribute definitions. Table is now capable of being supported.
- Action: To have Logical Standby maintain the table, import that table directly from the primary.
- ORA-16233: The table string.string is unsupported now
- Cause: Table was previously supported but now is unsupported due to altered datatype or storage attribute definitions.
- Action: None
- ORA-16234: restarting to reset Logical Standby apply
- Cause: Logical Standby encountered a work load that required a restart to properly reschedule.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16235: DDL skipped because import has occurred
- Cause: An object was exported from the primary database and imported into the Logical Standby database. This DDL occurred before the export.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16236: Logical Standby metadata operation in progress
- Cause: The requested operation failed because an incompatible Logical Standby metadata operation such as DBMS_LOGSTDBY.SET_TABLESPACE, DBMS_LOGSTDBY.APPLY_SET or DBMS_LOGSTDBY.INSTANTIATE_TABLE was still running.
- Action: Wait for the incompatible Logical Standby metadata operation to finish, then reenter or respecify the operation.
- ORA-16237: SGA specified for Logical Standby is too small
- Cause: MAX_SGA must be at least 10 Megabytes for proper functioning of Logical Standby.
- Action: Specify the value of MAX_SGA to be greater than or equal to 10Mb. Alternatively, increase the shared_pool_size/sga_target so that 1/4 of it will amount to 10 Megabytes.
- ORA-16238: attempt to use version 9 log
- Cause: Version 9 log files are not supported.
- Action: Use log files of a supported version.
- ORA-16239: IMMEDIATE option not available without standby redo logs
- Cause: The IMMEDIATE option cannot be used without standby redo logs.
- Action: Do not specify the IMMEDIATE option unless standby redo logs are being used.
- ORA-16240: Waiting for log file (thread# string, sequence# string)
- Cause: Process is idle waiting for additional log file to be available.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16241: Waiting for gap log file (thread# string, sequence# string)
- Cause: Reader process was idle waiting for the log file to fill the log sequence gap.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16242: Processing log file (thread# string, sequence# string)
- Cause: Reader process was processing the log file.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16243: paging out string bytes of memory to disk
- Cause: Builder process is paging out momery to free up space in lcr cache.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16245: change db_name to string in the server-side parameter file (SPFILE)
- Cause: An ALTER DATABASE RECOVER TO LOGICAL STANDBY new-dbname command was successfully executed without a modifiable server parameter file (SPFILE).
- Action: The server-side parameter file must be modified so that db_name is set to the given name before mounting the database again. You must do this by executing CREATE PFILE FROM SPFILE, editing the resulting text parameter file, and then executing CREATE SPFILE FROM PFILE.
- ORA-16246: User initiated abort apply successfully completed
- Cause: SQL Apply was stopped using the abort option.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16247: DDL skipped on internal schema
- Cause: Logical Standby ignores DDLs on internal schemas such as SYS and SYSTEM. For a complete list of internal schemas ignored by Logical Standby perform the following query: SELECT owner FROM dba_logstdby_skip WHERE statement_opt = ‘INTERNAL SCHEMA’.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16248: RFS connections not permitted during Terminal Apply
- Cause: Writes by RFS are not permitted while Logical Standby is performing Terminal Apply.
- Action: Permit any outstanding Logical Standby operations to complete.
- ORA-16249: Terminal apply failed to complete during failover
- Cause: The logical standby coordinator process terminated abnormally.”
- Action: Examine the DBA_LOGSTDBY_EVENTS view for the reason behind the abnormal shutdown, and resolve accordingly. Once the problem has been rectified, reissue the ALTER DATABASE ACTIVATE LOGICAL STANDBY DATABASE command to complete the failover.
- ORA-16250: Failed to acquire starting scn of new log stream
- Cause: The starting SCN for the new log stream could not be determined.
- Action: Please reissue the ACTIVATE LOGICAL STANDBY DATABASE command.
- ORA-16251: LSP1 Background Build not permitted
- Cause: The LSP1 background process is not permitted to start because it had previously been attempted.
- Action: This is an internal error. Contact Oracle support.
- ORA-16252: Rebuild operation not permitted
- Cause: The REBUILD operation is not permitted.
- Action: Only on a primary database that has failed to complete the LogMiner dictionary build may the REBUILD operation take place. Reissue the ACTIVATE LOGICAL STANDBY DATABASE command if it previously failed to complete.
- ORA-16253: Logical standby cannot start due to a prior, incomplete operation
- Cause: A failure during a prior failover or configuration-related operation left the logical standby in an inconsistent state.
- Action: Identify and reissue the operation before attempting to restart the logical standby apply engine.
- ORA-16254: change db_name to string in the client-side parameter file (pfile)
- Cause: An ALTER DATABASE RECOVER TO LOGICAL STANDBY new-dbname command was successfully executed without a server parameter file (spfile).
- Action: The client-side parameter file must be edited so that db_name is set to the given name before mounting the database again.
- ORA-16255: Log Auto Delete conflicts with another LogMiner session
- Cause: Log Auto Delete cannot be on while another LogMiner session is running on the same database.
- Action: Start Logical Standby without Log Auto Delete or destroy other LogMiner sessions first.
- ORA-16256: Failure to complete standby redo log file archival after failover
- Cause: The standby redo log files processed during the failover of a logical standby were not archived.
- Action: Execute DBMS_LOGSTDBY.REBUILD to reattempt the archival.
- ORA-16257: Switchover initiated stop apply successfully completed
- Cause: SQL Apply was stopped because of a switchover.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16258: marking index unusable due to a constraint violation
- Cause: A constraint violation occurred during the apply of a direct path load. The index will be marked unusable and the apply will be restarted.
- Action: No action necessary. See alert log for index schema and name.
- ORA-16259: Switchover to logical standby requires a log archive destination
- Cause: A valid log archive destination was not found to which the local system could archive the end of redo (EOR) log file. A minimum of one destination is required.
- Action: Ensure all log archive destinations are properly configured and, if applicable, have network connectivity before reissuing the ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL STANDBY DDL operation.
- ORA-16260: Waiting to replace partial or corrupt log file (thread# string, sequence# string)
- Cause: LogMiner Reader process reached the end of a partial log file or encountered a corrupted block. It is now waiting for the log file to be recovered and reregistered.
- Action: No action necessary. Once the fetch archive log (FAL) archiver replaces the log file, standby will automatically restart to process the replaced file.
- ORA-16261: Identification key mismatch for table “string“.”string“.
- Cause: Internal error in SQL Apply.
- Action: Contact Oracle Support Services.
- ORA-16262: Invalid value specified for Logical Standby parameter
- Cause: The value specified in APPLY_SET is invalid for the parameter.
- Action: Specify correct parameter value. Please refer to documentation on DBMS_LOGSTDBY PL/SQL package for details.
- ORA-16263: Dynamic parameters can only be set on SQL apply instance
- Cause: Attempt to set a Logical standby dynamic parameter on an instacne other than where SQL apply coordinator is running.
- Action: Connect to the instance where SQL apply coordinator is running and reissue the statement.
- ORA-16264: invalid value for PREPARE_SERVERS parameter
- Cause: attempt to set PREPARE_SERVERS parameter to zero or to a value which would require MAX_SERVERS to be increased.
- Action: set PREPARE_SERVERS parameter to a non zero value and or increase MAX_SERVERS parameter accordingly.
- ORA-16265: Unsupported PL/SQL procedure encountered
- Cause: Apply encountered an unsupported procedure from an Oracle supplied PL/SQL package that is otherwise supported
- Action: Either add a skip rule for this procedure or manually apply the procedure and restart apply skipping the failed transaction Please refer to documentation on the PL/SQL package for details.
- ORA-16266: Cannot instantiate a Logical Standby from another Logical Standby
- Cause: An instantiation of a Logical Standby has been attempted for another database with the Logical Standby role, which is not supported.
- Action: Instantiate a Logical Standby database only from a Primary Database.
- ORA-16267: Cannot instantiate a Logical Standby during a switchover
- Cause: An instantiation of a Logical Standby has been attempted for a primary database that is in the middle of a switchover.
- Action: Execute ALTER DATABASE PREPARE TO SWITCHOVER CANCEL to cancel the switchover, and attempt the instantiation again.
- ORA-16268: user procedure processing of logical standby apply PL/SQL
- Cause: A user-provided stored procedure was called to inspect a PL/SQL statement prior to the statement 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-16269: PL/SQL procedure skipped due to failure on primary database
- Cause: Because the PL/SQL procedure failed when executed on the primary database, it could not be executed on the standby database.
- Action: This informational statement is provided to record the event for diagnostic purposes. The failed PL/SQL procedure needs to be investigated to ensure it did not commit interesting data before it failed.
- ORA-16270: PL/SQL procedure skipped due to unmaintained standby objects
- Cause: Because the PL/SQL procedure manipulated objects not being maintained by the standby database, it was skipped.
- Action: No action necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16271: PL/SQL successfully applied
- Cause: A PL/SQL procedure was successfully applied on the logical standby database.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16272: PL/SQL procedure skipped due to skip setting
- Cause: A setting in the logical standby skip table indicated that this PL/SQL procedure should always be skipped.
- Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
- ORA-16273: invalid value for APPLY_SERVERS parameter
- Cause: attempt to set APPLY_SERVERS parameter to zero or to a value which would require MAX_SERVERS to be increased.
- Action: set APPLY_SERVERS parameter to a non zero value or increase MAX_SERVERS parameter accordingly.
- ORA-16274: failure to perform operation on all Oracle RAC instances
- Cause: One or more instances encountered an error while performing an operation.
- Action: Ensure every instance in the Oracle RAC meets the requirements for the operation, and retry the operation.
- ORA-16275: prior failed CTAS detected and pre-existing table dropped
- Cause: During the processing of a CTAS operation, an existing empty table with the same name and attributes as the CTAS source table was found, and the table was dropped.
- Action: No action is necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16276: specified database link does not correspond to primary database
- Cause: The database link specified to DBMS_LOGSTDBY.INSTANTIATE_TABLE did not link to the primary database for this logical standby database.
- Action: Specify a database link that corresponds to the primary database for this logical standby database. The link should have privileges to read and lock the table being instantiated, as well as the SELECT_CATALOG_ROLE.
- ORA-16277: specified table is not supported by logical standby database
- Cause: A call was made to DBMS_LOGSTDBY.INSTANTIATE_TABLE to instantiate an unsupported table on the logical standby database. Tables with unsupported data types cannot be replicated to a logical standby database.
- Action: Specify a table which is not listed in the DBA_LOGSTDBY_UNSUPPORTED_TABLE view.
- ORA-16278: specified table has a multi-object skip rule defined
- Cause: A table that is instantiated via DBMS_LOGSTDBY.INSTANTIATE_TABLE must not have any skip rules defined with wildcard characters.
- Action: Remove or rewrite any skip rules defined for the specified table so that they no longer contain wildcard characters, or no longer affect the specified table.
- ORA-16279: supplied dblink does not have sufficient privileges
- Cause: A dblink was specified that lacked one or more of the CONNECT, RESOURCE, or SELECT_CATALOG_ROLE roles or that connects to a user with insufficient privileges to lock the table.
- Action: Grant the necessary privileges to the dblink and the user to which the dblink connects and retry the operation.
- ORA-16280: cannot change master key on a logical standby database
- Cause: An attempt was made to change the master key for transparent data encryption on a logical standby database.
- Action: Set GUARD to NONE and reissue the command. This prevents you from replicating tables with encrypted columns from the primary database.
- ORA-16281: missing identification key for table “string“.”string“.
- Cause: No identification key was created for specified table.
- Action: Create a primakey key or unique index for specified table.
- ORA-16282: operation not permitted during rolling upgrade
- Cause: An operation was attempted that is not supported during a rolling upgrade.
- Action: Retry the operation upon completion of the upgrade.
- ORA-16283: operation not permitted on non-apply instance
- Cause: An operation was attempted that is not supported since it requires a running logical apply on the local instance.
- Action: Retry the operation on the instance on which the apply engine is running.
- ORA-16284: timed out waiting for an in-progress operation to complete
- Cause: An operation timed out waiting for another operation to complete.
- Action: Retry the operation when the in-progress operation has completed.
- ORA-16285: operation not permitted due to inconsistent role state
- Cause: A prior attempt to change the role of this database has failed before the new role state could be fully committed.
- Action: Retry the previously attempted role-related operation before attempting the current operation.
- ORA-16286: operation not permitted due to lack of synchronized destination
- Cause: A synchronized log archive destination was not found to which the end-of-redo log file could be archived.
- Action: Before re-attempting the operation, wait at least one minute for the Remote File Server to automatically recover any missing log files or manually recover and register any missing log files with logical standby.
- ORA-16287: operation not permitted due to active apply state
- Cause: An operation was attempted that was not supported while the logical standby database had an active apply state.
- Action: Confirm the procedures used to configure the logical standby database. Procedures which attempt to reconfigure a logical standby database for a new primary database may encounter this error if an error in a preliminary step was encountered.
- ORA-16288: DDL skipped due to missing edition “string“
- Cause: The edition in which the DDL was performed on the primary did not exist on the standby database.
- Action: No action is necessary. This informational statement is provided to record the event for diagnostic purposes.
- ORA-16290: cannot alter the session logical replication state within a transaction
- Cause: A transaction was already in progress.
- Action: Commit or rollback the transaction and then reexecute.
This internet site is my inspiration, very good
style and design and Perfect subject material.