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 : 29-04-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-22304 : input type is not an object type
  • ora-31406 : change source string is referenced by a change set
  • ora-13221 : unknown geometry type in the geometry object
  • ora-38723 : Invalid SCN expression.
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-14106 : LOGGING/NOLOGGING may not be specified for a clustered table
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-30079 : cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
  • ora-02354 : error in exporting/importing data string
  • ora-31631 : privileges are required
  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-16597 : Data Guard broker detects two or more primary databases
  • ora-28009 : connection as SYS should be as SYSDBA or SYSOPER
  • ora-25225 : invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-03261 : the tablespace string has only one file
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • ora-29809 : cannot drop an operator with dependent objects
  • ora-12407 : unauthorized operation for policy string
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-01614 : instance string (thread string) is busy - cannot enable
  • ora-25279 : dequeue as select not supported before 8.2
  • ora-16011 : Archivelog Remote File Server process in Error state
  • ora-38485 : invalid object type for the user-defined function
  • ora-13710 : Parameter "string" must have a higher value than parameter "string". The values supplied were "string" and "string" respectively.
  • ora-08181 : specified number is not a valid system change number
  • ora-19725 : can not acquire plug-in enqueue
  • ora-30181 : integer in argument index is not immediately followed by )
  • ora-14452 : attempt to create, alter or drop an index on temporary table already in use
  • ora-06021 : NETASY: connect failed
  • 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.