Home » RDBMS Server » Server Administration » Resolving ORA-02050 error
Resolving ORA-02050 error [message #408287] Mon, 15 June 2009 10:52 Go to next message
gajini
Messages: 259
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 #408289 is a reply to message #408287] Mon, 15 June 2009 11:02 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>ORA-01017: invalid username/password; logon denied
Fix above error!
Re: Resolving ORA-02050 error [message #408292 is a reply to message #408289] Mon, 15 June 2009 11:17 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Look like your database link not working. Check your database link status.

Babu
Re: Resolving ORA-02050 error [message #408295 is a reply to message #408287] Mon, 15 June 2009 11:33 Go to previous messageGo to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

There is no problem with username and password and database link working status, everything is fine.

Thanks...
Re: Resolving ORA-02050 error [message #408297 is a reply to message #408287] Mon, 15 June 2009 11:40 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>There is no problem with username and password and database link working status, everything is fine.
Then the errors are a figment of your imagination & should be ignored since "everything is fine".
Re: Resolving ORA-02050 error [message #408298 is a reply to message #408295] Mon, 15 June 2009 12:00 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>>There is no problem with username and password and database link working status, everything is fine.


Proff ??
Re: Resolving ORA-02050 error [message #408308 is a reply to message #408287] Mon, 15 June 2009 12:35 Go to previous messageGo to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

Please find the proof of db link working status,

Quote:
SQL> select * from dual@gxn.world;

DUM
---
X


Please note, I got this error while compiling a package body
which uses db link to access DB2 tables.

Thanks...



[Updated on: Mon, 15 June 2009 12:35]

Report message to a moderator

Re: Resolving ORA-02050 error [message #408311 is a reply to message #408287] Mon, 15 June 2009 13:07 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Gee, I did not know that DB2 also had a DUAL table just like Oracle's.

Can you provide proof that you are actually getting to the DB2 database?
Re: Resolving ORA-02050 error [message #408312 is a reply to message #408308] Mon, 15 June 2009 13:18 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


From which user your executeing SQL Query?

Babu
Re: Resolving ORA-02050 error [message #408317 is a reply to message #408287] Mon, 15 June 2009 14:14 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: DBCA on Putty
Next Topic: upgrade from oracle 9.2.0.1 to 9.2.0.8
Goto Forum:
  


Current Time: Sun Dec 11 04:31:26 CST 2016

Total time taken to generate the page: 0.09372 seconds