i restarted the server but of no use
solution:
SQL> select local_tran_id from dba_2pc_pending;
LOCAL_TRAN_ID
------------------------------ ------------------------------ ------
6.44.24689
SQL> rollback force '6.44.24689';
Rollback complete.
SQL> exec dbms_transaction.purge_lost_ db_entry('6.44.24689');
PL/SQL procedure successfully completed.
SQL> select local_tran_id from dba_2pc_pending;
no rows selected
reference:
1 comment:
Hi RAJESHKUMAR,
I'm Shyju working in an IT firm in Dubai. I have find your blog which is very informative and I'm sure you have good knowledge in Oracle. I'm very new to Oracle and E-Business Suite. Here we have installed e-business suite 12 and Vision Database in a Windows 2003 machine. Now I want to access the Vision database. I can login to e-business suite with user which is there in Vision database(ie. username: cbrown and password:welcome).,and I have got sysadmin access also, but I could not find the table where the user cbrown resides.
Can you give me some suggestions to find that table (using SQL+ or any other oracle client).
Post a Comment