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

 

f 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.

You can check from your user schema but execute rollback or commit  from SYS user .

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

rollback force '72.6.1262301';

Then from SYS user execute below command:

SQL> rollback force '72.6.1262301';

SQL> commit force '72.6.1262301';

Enable local network access to sites on WAMP Server 3.2.6

 

In the place of httpd.conf , in the follwoing tagg , add

<Directory "d:/wamp/www/">

  # Require local

    Require all granted

     Order Deny,Allow

     Allow from all

</Directory>

also open httpd-vhosts.conf , modfy as below

<VirtualHost *:80>

    #Require local 

    Require all granted

</Directory>

</VirtualHost>

Weblogic: java.sql.SQLException: ORA-28001: the password has expired weblogic service start (During Admin Server start)

C:>sqlplus /nolog
SQL> connect / as SYSDBA
SQL> select * from dba_profiles;
SQL> alter profile default limit password_life_time unlimited;
SQL> alter user identified by ;
SQL> commit;

SQL> exit; 

First connect SYS users in the pluggable database:

We know, belows users are needed for WEBLOGIC start. May be, password of foloowing users may expire or locked account. 

DEV_IAU_VIEWER

DEV_IAU_APPEND

DEV_IAU

DEV_OPSS

DEV_STB

DEV_WLS

DEV_WLS_RUNTIME

For all above users, The following command needs to run from SYS user:

 alter user DEV_WLS account unlock

   alter user DEV_WLS_RUNTIME identified by ABc#654

Enable Desktop Environment : GNOME Desktop (Fedora Linux)

[root@dlp ~]# dnf -y group install "Basic Desktop" GNOME

[root@dlp ~]# startx 

[root@dlp ~]#yum update