Resolving ORA-02050 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Resolving ORA-02050 error

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Resolving ORA-02050 error

    Hi All,

    I'm getting the following message in alert log for every 1 hour,

    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
    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
    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...

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    ORA-01017: invalid username/password; logon denied

    ??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width