Home » RDBMS Server » Server Administration » Alert log error
Alert log error [message #389021] Fri, 27 February 2009 00:35 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi All,

I'm getting the following meesage in my alert log file,


Quote:
Thu Feb 26 20:45:00 2009
HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=TMSD)(PROTOCOL=TCP)(PORT=1526)))(CONNECT_DATA=(SID=GXN))),
NCR status = -2147385341
Error 2068 trapped in 2PC on transaction 7.42.514124. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from GXN.WORLD
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=TMSD)(PROT
OCOL=TCP)(PORT=1526)))(CONNECT_DATA=(SID=GXN)))
Thu Feb 26 21:53:50 2009
HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=TMSD)(PROTOCOL=TCP)(PORT=1526)))(CONNECT_DATA=(SID=GXN))),
NCR status = -2147385341
Error 2068 trapped in 2PC on transaction 4.43.524820. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from GXN.WORLD
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=TMSD)(PROT
OCOL=TCP)(PORT=1526)))(CONNECT_DATA=(SID=GXN)))


My database version is 10.2.0.3.0 and the database link GXN.WORLD is used to connect from oracle to DB2 database. Can anyone explain why I'm getting this message in alert log file and how to resolve this error.

Thanks...

[Updated on: Fri, 27 February 2009 00:40]

Report message to a moderator

Re: Alert log error [message #389026 is a reply to message #389021] Fri, 27 February 2009 00:58 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Can you connect to DB2 database successfully?
Re: Alert log error [message #389030 is a reply to message #389021] Fri, 27 February 2009 01:19 Go to previous messageGo to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

I can't directly connect to DB2 database but can check the connectivity of DB2 database by,

select * from dual@gxn.world;

It gives me the result.

Thanks..
Re: Alert log error [message #389046 is a reply to message #389030] Fri, 27 February 2009 02:11 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Error 2068 trapped in 2PC on transaction 4.43.524820. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from GXN.WORLD
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=TMSD)(PROT
OCOL=TCP)(PORT=1526)))(CONNECT_DATA=(SID=GXN)))


I think too many database link connect. Try to bounce your application (NOT database)

Error 2068 trapped in 2PC on transaction 4.43.524820. Cleaning up.


I think your donig manual distributed transaction. That's the reason you got above message; Try to enable automatted distributed recovery using.

alter system enable distributed recovery;


Otherwise Try to manually fix above errors using DBA_2PC_PENDING

Babu
Previous Topic: Segment Space Managemrnt
Next Topic: moving to new database after reducing table spaces
Goto Forum:
  


Current Time: Sat Dec 03 22:11:03 CST 2016

Total time taken to generate the page: 0.08472 seconds