| Resolving ORA-02050 error [message #408287] |
Mon, 15 June 2009 10:52  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
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...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Resolving ORA-02050 error [message #408317 is a reply to message #408287] |
Mon, 15 June 2009 14:14  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Please note, I got this error
ERROR? What Error? I do not see any error.
>while compiling a package body which uses db link to access DB2
tables.
What package body? I don't see any code?
Most folks are severely challenged to debug stuff they can't see.
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
