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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

No action necessary, this informational statement is provided to record the event for diagnostic purposes.

update : 24-06-2017
ORA-16125

ORA-16125 - large transaction string string string is waiting for more data
ORA-16125 - large transaction string string string is waiting for more data

  • ora-30442 : can not find the definition for filter string
  • ora-00299 : must use file-level media recovery on data file string
  • ora-09828 : SCLFR: atomic latch return error.
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-16191 : Primary log shipping client not logged on standby
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-02788 : Unable to find kernel process pointer in async process array
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-00111 : invalid attribute string
  • ora-32592 : all columns in log group can not be no log columns
  • ora-32031 : illegal reference of a query name in WITH clause
  • ora-15093 : buffer only contains string bytes, I/O requested is string bytes
  • ora-08313 : sllfop: could not allocate buffers
  • ora-07597 : spguns: $GETJPIW failure
  • ora-34143 : (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-08182 : operation not supported while in Flashback mode
  • ora-28536 : error in processing Heterogeneous Services initialization parameters
  • ora-22161 : type code [string] is not valid
  • ora-29956 : warning in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-32301 : object-relational materialized views must be primary key based
  • ora-02031 : no ROWID for fixed tables or for external-organized tables
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-00475 : TRWR process terminated with error
  • ora-16954 : SQL parse error.
  • ora-22618 : attribute is a BAD NULL in the image handle
  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-02274 : duplicate referential constraint specifications
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.