OraFAQ Forum: Server Administration » Identifiying two databases involved in a distributed transaction

Home » RDBMS Server » Server Administration » Identifiying two databases involved in a distributed transaction (Oracle 11.2.0.3 on Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Identifiying two databases involved in a distributed transaction [message #599464]

Thu, 24 October 2013 12:41

orausern
Messages: 826
Registered: December 2005

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.

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599467 is a reply to message #599464]

Thu, 24 October 2013 12:55

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599469 is a reply to message #599467]

Thu, 24 October 2013 12:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_txnman005.htm

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599474 is a reply to message #599467]

Thu, 24 October 2013 13:26

orausern
Messages: 826
Registered: December 2005

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?

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599475 is a reply to message #599474]

Thu, 24 October 2013 13:27

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Then you can query DBA_2PC_NEIGHBORS.

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599477 is a reply to message #599475]

Thu, 24 October 2013 13:32

orausern
Messages: 826
Registered: December 2005

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So connection from jdbcdb1/jdbcdb8 with account prod1.

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599479 is a reply to message #599478]

Thu, 24 October 2013 14:22

orausern
Messages: 826
Registered: December 2005

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?

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599520 is a reply to message #599479]

Fri, 25 October 2013 01:20

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.

Report message to a moderator

Re: Identifiying two databases involved in a distributed transaction [message #599546 is a reply to message #599520]

Fri, 25 October 2013 13:32

orausern
Messages: 826
Registered: December 2005

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:53:16 CST 2024