ORA-01591: lock held by in-doubt distributed transaction

 ORA-01591: lock held by in-doubt distributed transaction

If you got ” ORA-01591: lock held by in-doubt distributed transaction ” error, it means there are some uncommitted transactions in the database.

We need to perform rollback or commit force for Uncommitted transactions to solve this problem.

ORA-01591

You can query uncommitted or pending transaction with following script. This script will generate rollback force command also, so you can execute the result of following command.

SQL> select 'rollback force '''||local_tran_id||''';' from DBA_2PC_PENDING where state='prepared';

rollback force '72.6.1262301';

You can perform rollback related transaction with following command.

SQL> rollback force '72.6.1262301';

lock held by in-doubt distributed transaction

Following script will generate commit force command also, so you can execute the result of following command.

SQL> select 'commit force '''||local_tran_id||''';' from DBA_2PC_PENDING where state='prepared';

commit force '72.6.1262301';

You can perform force commit to related transaction with following command.

SQL> commit force '72.6.1262301';

Source:- https://ittutorial.org/ora-01591-lock-held-by-in-doubt-distributed-transaction/

Command to resolve display issue for Oracle Linux

xauth add `echo "${DISPLAY}" | sed 's/.*\(:.*\)/\1/'` . `mcookie`

Source: https://bbs.archlinux.org/viewtopic.php?id=98524

TMF814 Corba API Tips

 1. Use an existing holder to fetch next_n elements instead of creating a new holder for better performance.

Useful commands

• sudo netstat -tulpn | grep LISTEN 
• iostat -c

Update Ubuntu with latest packages

Steps to update packages

$ sudo apt update

$ sudo apt list --upgradable

$ sudo apt install <SPECIFIC_PACKAGE_NAME>

or

$ sudo apt upgrade  

 

Running VNC Server on OCI Linux 7

 Step 1: Install the GUI server

$ sudo yum group install "Server with GUI" -y

Step 2: Install VNC Server

$ sudo yum install tigervnc-server tigervnc-server-module -y

Step 3: Create a password for vncserver

$ vncpasswd

Step 4: Copy vncserver@.service to /etc/systemd/system/

$ sudo cp /usr/lib/systemd/system/vncserver@.service /etc/systemd/system/. 

Step 5: Edit /etc/systemd/system/vncserver@.service for Linux user.

$ sudo vi /etc/systemd/system/vncserver@.service

Search for below line and replace <USER> with opc as mentioned 

ExecStart=/usr/bin/vncserver_wrapper opc %i -geometry 1366x768

Step 6: Starting VNC Server

$ sudo systemctl daemon-reload

$ sudo systemctl start vncserver@:1.service (Here :1 is the port of vncserver)

$ sudo systemctl enable vncserver@:1.service

$ sudo systemctl status vncserver@:1.service

 Step 7: Tunneling VNC server port onto localhost (use Git Bash, in case of Windows OS)

$ ssh -v -C -L 5901:localhost:5901 opc@<public_ip> -i <private_key>

Step 8: Connect to VNC session using "localhost:5901"

// We can also access the VNC session directly, by opening 5901 open in Linux firewall. 

Step 7a: Open port '5901' in the firewall configuration.

$ sudo firewall-cmd --zone=public --permanent --add-port=5901/tcp

$ sudo firewall-cmd --reload 

 

 

Basic Test Framework with Protractor-Jasmine-TypeScript-NodeJS.

Basic Test Framework with Protractor-Jasmine-TypeScript-NodeJS, provides a bootstrap platform to write UI automation test cases for Angular applications.

https://github.com/ksuresh8/HelloProtractor

For more details: https://github.com/ksuresh8/HelloProtractor/blob/main/README.md