Showing posts with label Resolve In-Doubt-Transaction (IDT) in Oracle Database. Show all posts
Showing posts with label Resolve In-Doubt-Transaction (IDT) in Oracle Database. Show all posts

Friday, May 12, 2023

Resolve In-Doubt-Transaction (IDT)

 select LOCAL_TRAN_ID from dba_2pc_pending;
retruns idt Value
rollback force 'IDT Value' ;
commit;
commit;
exec dbms_transaction.purge_lost_db_entry('IDT Value');
commit;

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...