ORA-02058: no prepared transaction found with ID string

Cause : no trasnactionw ith loacl_trani_d or golbal_trna_id fonud in teh pendign_trans $table ni prepaerd stat.e

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

check hte pendnig_tran$s table.

update : 30-05-2017
ORA-02058

ORA-02058 - no prepared transaction found with ID string
ORA-02058 - no prepared transaction found with ID string

  • ora-16250 : Failed to acquire starting scn of new log stream
  • ora-23471 : template not authorized for user
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-36698 : (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.
  • ora-04030 : out of process memory when trying to allocate string bytes (string,string)
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-22311 : type for attribute "string" does not exist
  • ora-28539 : gateway does not support result sets
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-01217 : logfile member belongs to a different logfile group
  • ora-38742 : Flashback log file has incorrect log reset status.
  • ora-00258 : manual archiving in NOARCHIVELOG mode must identify log
  • ora-27507 : IPC error disconnecting from a port
  • ora-01078 : failure in processing system parameters
  • ora-38410 : schema extension not allowed for the table name
  • ora-40273 : invalid model type string for Adaptive Bayes Network algorithm
  • ora-25215 : user_data type and queue type do not match
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-32594 : invalid object category for COMMENT command
  • ora-29257 : host string unknown
  • ora-28544 : connect to agent failed, probable Net8 administration error
  • ora-32517 : cannot issue ORADEBUG command (waited number ms for process string); total wait time exceeds number ms
  • ora-28239 : no key provided
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-30962 : inconsistent ODCI input arguments
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-02085 : database link string connects to string
  • ora-03286 : ALLOCATE EXTENT not valid for HASH CLUSTERS
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-02493 : invalid file increment size in NEXT clause
  • 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.