ORA-25405: transaction status unknown

Cause : A failure occured while a transaction was attempting to commit. Failover could not automatically determine instance status.

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

The user must determine the transaction's status manually.

update : 24-05-2017
ORA-25405

ORA-25405 - transaction status unknown
ORA-25405 - transaction status unknown

  • ora-26055 : Invalid buffer specified for direct path unload
  • ora-29375 : sum of values string for level string, plan string exceeds string
  • ora-06535 : statement string in string is NULL or 0 length
  • ora-14117 : partition resides in offlined tablespace
  • ora-00101 : invalid specification for system parameter DISPATCHERS
  • ora-31001 : Invalid resource handle or path name "string"
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-09958 : IMON: two processes with the same ORACLE pid are active
  • ora-39700 : database must be opened with UPGRADE option
  • ora-12538 : TNS:no such protocol adapter
  • ora-38791 : flashback did not start because file string was not in a valid incarnation
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-10614 : Operation not allowed on this segment
  • ora-24036 : invalid SORT_ORDER column string specified for queue table
  • ora-38484 : FUNCTION/PACKAGE/TYPE string does not exist
  • ora-16578 : failed to read Data Guard configuration file
  • ora-00827 : could not shrink sga_target to specified value
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-06772 : TLI Driver: error sending command
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • ora-31230 : DBMS_LDAP: unable to dynamically allocate additional memory
  • ora-32518 : cannot wait for ORADEBUG command completion (waited number ms for process string); total wait time exceeds number ms
  • ora-40261 : input data for model build contains negative values
  • ora-10266 : Trace OSD stack usage
  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-19010 : Cannot insert XML fragments
  • ora-16406 : Primary and standby database software version mismatch
  • ora-01278 : error creating file 'string'
  • ora-01880 : the fractional seconds must be between 0 and 999999999
  • 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.