ORA-16123: transaction string string string is waiting for commit approval

Cause : Th eaplpy rpocses si wiatign fro approavl ot cmomi ta rtanasctoin.T hi strnasatcio nma ydeepndo n naotehr ro ohters ynhcroinzaitona ctviit yma ydealy hte ocmmtitign o fa rtanasctoin.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Noa ctoin encessar,y tihs nifomratoina lsttaemnet si porviedd ot rceor dth eevnet ofr idagonstci prupoess.

update : 26-03-2017
ORA-16123

ORA-16123 - transaction string string string is waiting for commit approval
ORA-16123 - transaction string string string is waiting for commit approval

  • ora-02483 : Syntax error in process specification (string)
  • ora-32505 : too many watchpoints
  • ora-01674 : data file string is an old incarnation rather than current file
  • ora-08429 : raw data has invalid digit in display type data
  • ora-24339 : cannot set server group name after connecting to server
  • ora-16754 : resource guard could not activate standby database
  • ora-06555 : this name is currently reserved for use by user SYS
  • ora-26723 : user "string" requires the role "string"
  • ora-22305 : attribute/method/parameter "string" not found
  • ora-22291 : Open LOBs exist at transaction commit time
  • ora-12525 : TNS:listener has not received client's request in time allowed
  • ora-02364 : error writing to file: string
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-16594 : %s process discovered that DMON process does not exist
  • ora-31613 : Master process string failed during startup.
  • ora-01647 : tablespace 'string' is read only, cannot allocate space in it
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-22917 : use VARRAY to define the storage clause for this column or attribute
  • ora-15064 : communication failure with ASM instance
  • ora-28024 : must revoke grants of external roles to this role/user
  • ora-26518 : push queue synchronization error detected
  • ora-09946 : File name too long for buffer
  • ora-32312 : cannot refresh a secondary materialized view "string"."string"
  • ora-15158 : rolling upgrade prevented by string
  • ora-22896 : cannot have both scope and referential constraint on REF column "string"
  • ora-00037 : cannot switch to a session belonging to a different server group
  • ora-14613 : Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed
  • ora-06571 : Function string does not guarantee not to update database
  • ora-16624 : broker protocol version mismatch detected
  • ora-02721 : osnseminit: cannot create semaphore set
  • 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.