OraFAQ Forum: Server Administration » Resolving ORA-02050 error

Home » RDBMS Server » Server Administration » Resolving ORA-02050 error

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

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

Report message to a moderator

Re: Resolving ORA-02050 error [message #408289 is a reply to message #408287]

Mon, 15 June 2009 11:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-01017: invalid username/password; logon denied
Fix above error!

Report message to a moderator

Re: Resolving ORA-02050 error [message #408292 is a reply to message #408289]

Mon, 15 June 2009 11:17

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

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

Babu

Report message to a moderator

Re: Resolving ORA-02050 error [message #408295 is a reply to message #408287]

Mon, 15 June 2009 11:33

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi,

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

Thanks...

Report message to a moderator

Re: Resolving ORA-02050 error [message #408297 is a reply to message #408287]

Mon, 15 June 2009 11:40

BlackSwan
Messages: 26766
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".

Report message to a moderator

Re: Resolving ORA-02050 error [message #408298 is a reply to message #408295]

Mon, 15 June 2009 12:00

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

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

Proff ??

Report message to a moderator

Re: Resolving ORA-02050 error [message #408308 is a reply to message #408287]

Mon, 15 June 2009 12:35

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

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Resolving ORA-02050 error [message #408312 is a reply to message #408308]

Mon, 15 June 2009 13:18

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

From which user your executeing SQL Query?

Babu

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	DBCA on Putty
Next Topic:	upgrade from oracle 9.2.0.1 to 9.2.0.8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 22:35:15 CDT 2024