Home » RDBMS Server » Server Administration » Identifiying two databases involved in a distributed transaction (Oracle 11.2.0.3 on Linux)
Identifiying two databases involved in a distributed transaction [message #599464] Thu, 24 October 2013 12:41 Go to next message
orausern
Messages: 738
Registered: December 2005
Location: Hyderabad
Senior Member
Hi Experts,

I am on Oracle 11.2.0.3 on Linux. In my production database, I am getting this alert, in the alert log:

--the below two lines are from alert log.
Error 604
trapped in 2PC on transaction 50.73.546578. Cleaning up.
--query from a data dictionary view   
SQL> select count(*) from DBA_2PC_PENDING;  
  COUNT(*)  
----------  
         1  





When I query the production database I see that there is one row in the DBA_2PC_PENDING view. But I dont' know how to identify which are the databases that are involved in this distributed transaction. That is my first issue - how to identify which are the two databases that are involved in the distributed transaction?

Can someone please help on it?

Thanks,
N.




icon5.gif  Re: Identifiying two databases involved in a distributed transaction [message #599467 is a reply to message #599464] Thu, 24 October 2013 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 60044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The first thing to know is what the value of STATE, MIXED and ADVICE columns.
Then you can query DBA_2PC_NEIGHBORS.


Re: Identifiying two databases involved in a distributed transaction [message #599469 is a reply to message #599467] Thu, 24 October 2013 12:57 Go to previous messageGo to next message
BlackSwan
Messages: 23177
Registered: January 2009
Senior Member
http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_txnman005.htm
Re: Identifiying two databases involved in a distributed transaction [message #599474 is a reply to message #599467] Thu, 24 October 2013 13:26 Go to previous messageGo to next message
orausern
Messages: 738
Registered: December 2005
Location: Hyderabad
Senior Member
Thanks Experts!!

The values from DBA_2PC_PENDING ARE:

STATE:prepared
MIXED:no
ADVICE: NULL (no value here).

From this how can I identify what is the remote database?

Re: Identifiying two databases involved in a distributed transaction [message #599475 is a reply to message #599474] Thu, 24 October 2013 13:27 Go to previous messageGo to next message
Michel Cadot
Messages: 60044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Then you can query DBA_2PC_NEIGHBORS.


Re: Identifiying two databases involved in a distributed transaction [message #599477 is a reply to message #599475] Thu, 24 October 2013 13:32 Go to previous messageGo to next message
orausern
Messages: 738
Registered: December 2005
Location: Hyderabad
Senior Member
Yes, I see the following when I query DBA_2PC_NEIGHBOURS:

LOCAL_TRAN_ID:  25.17.14031         
IN_OUT:  in               
DATABASE : jdbcdb1             
DBUSER_OWNER : prod1          
INTERFACE :    N         
DBID  :   jdbcdb8              
SESS#  :  1              
BRANCH   :  <some long hexa type of string like X2SLJFLSADKJFLASFJALLKDAFJLLLKSKLLKKLKLK>            


But what to do next based on this information?

[Updated on: Thu, 24 October 2013 13:33]

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599478 is a reply to message #599477] Thu, 24 October 2013 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 60044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So connection from jdbcdb1/jdbcdb8 with account prod1.

Re: Identifiying two databases involved in a distributed transaction [message #599479 is a reply to message #599478] Thu, 24 October 2013 14:22 Go to previous messageGo to next message
orausern
Messages: 738
Registered: December 2005
Location: Hyderabad
Senior Member
Thanks a lot Michel!

note that prod1 is my local database schema.

I guess what you mean is that , from the remote database: jdbcdb1/jdbcdb8 , a connection is comming to the prod1 schema in my local database. Am I right?
Re: Identifiying two databases involved in a distributed transaction [message #599520 is a reply to message #599479] Fri, 25 October 2013 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 60044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes.

Re: Identifiying two databases involved in a distributed transaction [message #599546 is a reply to message #599520] Fri, 25 October 2013 13:32 Go to previous message
orausern
Messages: 738
Registered: December 2005
Location: Hyderabad
Senior Member
Thanks Michael. Unluckily the mystery continued! No one is aware of any database called jdbcdb1/jdbcdb8. Is it possible that this can be a tns service name or something else? We are just not able to locate which is this database.
Previous Topic: Making a dbms_scheduler job to execute in next 10 minutes
Next Topic: window can not start the oracleserviceORCL on local computer
Goto Forum:
  


Current Time: Wed Dec 24 21:05:26 CST 2014

Total time taken to generate the page: 0.11450 seconds