OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Alert log error

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

Alert log error [message #389021]

Fri, 27 February 2009 00:35

gajini
Messages: 262
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

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Can you connect to DB2 database successfully?

Report message to a moderator

Re: Alert log error [message #389030 is a reply to message #389021]

Fri, 27 February 2009 01:19

gajini
Messages: 262
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..

Report message to a moderator

Re: Alert log error [message #389046 is a reply to message #389030]

Fri, 27 February 2009 02:11

babuknb
Messages: 1736
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 18:53:41 CDT 2024