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 : 29-04-2017
ORA-02058

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

  • ora-29285 : file write error
  • ora-19812 : cannot use string without DB_RECOVERY_FILE_DEST
  • ora-19661 : datafile string could not be verified
  • ora-29519 : name string resolved via a synonym in schema string to a class with a different name
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-01589 : must use RESETLOGS or NORESETLOGS option for database open
  • ora-36708 : (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
  • ora-08268 : create_ora_addr: cannot close nameserver
  • ora-19625 : error identifying file string
  • ora-02258 : duplicate or conflicting NULL and/or NOT NULL specifications
  • ora-30435 : job_queue_processes must be non-zero in order to refresh summaries
  • ora-29553 : class in use: string.string
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-22338 : must specify CASCADE INCLUDING DATA when altering the final property
  • ora-02173 : invalid option for DROP TABLESPACE
  • ora-30956 : invalid option for XML Index
  • ora-19203 : Error occurred in DBMS_XMLGEN processingstring
  • ora-08320 : scnget: Call to scnget before scnset or scnfnd.
  • ora-14517 : subpartition of index 'string.string' is in unusable state
  • ora-01123 : cannot start online backup; media recovery not enabled
  • ora-14511 : cannot perform operation on a partitioned object
  • ora-14272 : only a partition with higher bound can be reused
  • ora-02034 : speed bind not permitted
  • ora-00061 : another instance has a different DML_LOCKS setting
  • ora-01324 : cannot add file string due to DB_ID mismatch
  • ora-06790 : TLI Driver: poll failed
  • ora-27083 : waiting for async I/Os failed
  • ora-30657 : operation not supported on external organized table
  • ora-00017 : session requested to set trace event
  • ora-30957 : cannot downgrade because there are XML indexes
  • 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.