Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • logminer and my_lbu Oracle
  • Removing Blank lines from file using grep Linux/Unix
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • pvm_rbs1.sql (to collect rbs info from db) Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • plan10g.sql good Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • Oracle 11g Environment Setup Oracle
  • create user with unlimited quota Oracle
  • switchlogfile.sh Linux/Unix
  • Index Range Scan Oracle
  • Remove DOS CR/LFs (^M) Linux/Unix

Distributed Transaction Troubleshooting.

Posted on 08-Feb-2010 By Admin No Comments on Distributed Transaction Troubleshooting.

SQL> select * from sys.pending_trans$ where local_tran_id = ‘26.2.2712168’;

no rows selected

SQL> select * from sys.pending_sessions$ where local_tran_id = ‘26.2.2712168’;

no rows selected

SQL> select * from sys.pending_sub_sessions$ where local_tran_id = ‘26.2.2712168’;

no rows selected

SQL> select * from dba_2pc_neighbors;

no rows selected

SQL> select * from dba_2pc_pending;

no rows selected

SQL> commit force ‘26.2.2712168’;

commit force ‘26.2.2712168’

*

ERROR at line 1:

ORA-02058: no prepared transaction found with ID 26.2.2712168

SQL> rollback force ‘26.2.2712168’;

rollback force ‘26.2.2712168’

*

ERROR at line 1:

ORA-02058: no prepared transaction found with ID 26.2.2712168

SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(‘26.2.2712168’);

BEGIN DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(‘26.2.2712168’); END;

*

ERROR at line 1:

ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

ORA-06512: at “SYS.DBMS_TRANSACTION”, line 65

ORA-06512: at “SYS.DBMS_TRANSACTION”, line 85

ORA-06512: at line 1

SELECT KTUXEUSN, KTUXESLT, KTUXESQN, /* Transaction ID */

KTUXESTA Status,

KTUXECFL Flags

FROM x$ktuxe

WHERE ktuxeusn= 26;

no rows selected

Oracle, SQL scripts

Post navigation

Previous Post: Deleting first line and lastline of a file using sed
Next Post: Query to Generate aggregate on every 30 mins.

Related Posts

  • Resolving RMAN Hung Jobs Oracle
  • CPU Core related projections AWS
  • Database link password in user_db_links Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
  • SQL_PROFILE – I explaination Oracle
  • Renaming the column name Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Oracle 11g Training on 29JAN1010 Oracle
  • How to Make Trace Files Created by Oracle Readable by All Users ? Oracle
  • All About Trace Fils Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • Monitor and Trace Unix processes using truss Linux/Unix
  • Oracle GoldenGate lag monitoring shell script Linux/Unix
  • Export With Query Another Example. Oracle
  • default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme