Oracle Database Errors or Warnings from Error ORA-16242 to ORA-16253

SQLServerF1

ORA-16242: Processing logfile (thread# string, sequence# string)
Cause: Reader process is processing the logfile.
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-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 incomplete terminal apply
Cause: A previous ACTIVATE of the logical standby failed to complete.
Action: Reissue the ALTER DATABASE ACTIVATE LOGICAL STANDBY DATABASE FINISH APPLY command.

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

What are Oracle Database Error Messages?

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

Hope this was helpful.

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

 

Leave a Reply

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