Resolving ORA-02050 error
Hi All,
I'm getting the following message in alert log for every 1 hour,
Quote:
Mon Jun 15 02:07:43 2009
HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=TMD)(PROTOCOL=TCP)(PORT=1526)))(CONNECT_DATA=(SID=GXN))),
NCR status = -2147385341
Error 2068 trapped in 2PC on transaction 18.11.404285. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 18.11.404285 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from GXN.WORLD
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=TMD)(PROT
OCOL=TCP)(PORT=1526)))(CONNECT_DATA=(SID=GXN)))
Mon Jun 15 02:07:43 2009
DISTRIB TRAN TOMD.0be16ba2.18.11.404285
is local tran 18.11.404285 (hex=12.0b.62b3d)
insert pending collecting tran, scn=72536760809 (hex=10.e38721e9)
Mon Jun 15 02:07:43 2009
Errors in file /toms/oracle/admin/TOMD2/bdump/tomd2_reco_5928.trc:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from GXN.WORLD
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from GXN.WORLD
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from GXN.WORLD
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from GXN.WORLD
Quote:
select * from dba_2pc_pending;
LOCAL_TRAN_ID GLOBAL_TRAN_ID STATE MIXED ADVICE TRAN_COMMENT FAIL_TIME FORCE_TIME RETRY_TIME OS_USER OS_TERMINAL HOST DB_USER COMMIT#
18.11.404285 TOMD.0be16ba2.18.11.404285 collecting no 6/15/2009 2:07 6/15/2009 7:31 tmd AW1BD-55 TMd\AW1BD-55 MAY09FUNC 72536760809
Quote:
select * from dba_2pc_neighbors
LOCAL_TRAN_ID IN_OUT DATABASE DBUSER_OWNER INTERFACE DBID SESS# BRANCH
18.11.404285 in MAY09FUNC N 1 0000
18.11.404285 out GXN.WORLD MAY09FUNC N DB21020 1 4
The host database is Oracle 10g and the db link GXN.WORLD connects to DB2 database.
Can anyone explain me what is happening in my database?What I've to do to resolve this problem so that the
following message will not appear in alert log?
Thanks...
