Home » RDBMS Server » Networking and Gateways » ORA-02062: distributed recovery received DBID (Oracle 10g)
ORA-02062: distributed recovery received DBID [message #606926] Thu, 30 January 2014 15:11 Go to next message
akshara
Messages: 9
Registered: January 2014
Junior Member
Hello Everyone,

I found this error repeatedly in one of my db's alert log file.
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
I have 3 dblinks on this server,these are created before i got here,so i don't know how they are created.
why am i getting this error,i am new to dblinks and i don't know how to proceed.
can anyone please guide me?
Thank you.
Re: ORA-02062: distributed recovery received DBID [message #606927 is a reply to message #606926] Thu, 30 January 2014 15:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
02062, 00000, "distributed recovery received DBID %s, expected %s"
// *Cause: a database link at a coordinator no longer points to the expected
//         database.  Link may have been redefined, or a different DB mounted.
// *Action: restore link definition or remote database.

What is ORACLE_SID & DBID of the system which logs these entries?
What are the ORACLE_SID & DBID of the other DB Server systems?


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: ORA-02062: distributed recovery received DBID [message #606929 is a reply to message #606927] Thu, 30 January 2014 15:52 Go to previous messageGo to next message
akshara
Messages: 9
Registered: January 2014
Junior Member
#20.12 found the logs in ESRI gis database server.
alert log:
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_2286.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Jan 30 05:31:29 2014
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_2286.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Jan 30 06:40:48 2014
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_2286.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Jan 30 08:24:49 2014
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_2286.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Jan 30 09:21:10 2014
Thread 1 advanced to log sequence 41810
Current log# 1 seq# 41810 mem# 0: /opt/oracle/oradata/gis/gis/redo01.log
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
gis

SQL> select dbid from v$database;

DBID
----------
3617557193
SQL> select * from dba_db_links;

OWNER
------------------------------
DB_LINK
--------------------------------------------------------------------------------
USERNAME
------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
---------
PUBLIC
HANSEN.REGRESS.RDBMS.DEV.US.ORACLE.COM
IMSV7
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.Cool(
PORT = 1521)))(CONNECT_DATA = (SID = V75)))
24-FEB-11

PUBLIC
CSTAR.REGRESS.RDBMS.DEV.US.ORACLE.COM
CSTAR_PROD
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.Cool(
PORT = 1521)))(CONNECT_DATA = (SID = cstar)))
24-FEB-11

PUBLIC
PWMEDIA.REGRESS.RDBMS.DEV.US.ORACLE.COM
MEDIA_PROD
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.13)
(PORT = 1521)))(CONNECT_DATA = (SID = PWMEDIA)))
01-MAY-12

#cstar-10.8
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
cstar

SQL> select name,dbid from v$database;

NAME DBID
--------- ----------
CSTAR 108806196

#10.8-V75

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
V75
SQL> select name,dbid from v$database;

NAME DBID
--------- ----------
V75 3509506610

#20.13
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
pwmedia
SQL> select name,dbid from v$database;

NAME DBID
--------- ----------
PWMEDIA 118953468

Re: ORA-02062: distributed recovery received DBID [message #606930 is a reply to message #606929] Thu, 30 January 2014 16:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
I am stumped & have no answer for you because neither DBID in the line above matches any of your posted databases.
You have a mystery & I don't see any clues.

does every existing DB Link still work?
SELECT COUNT(*) FROM USER_OBJECTS@REMOTE_DB;
SQL above should be valid to test each DB Link
If 1 DB Link throws error, it could be the culprit.
Re: ORA-02062: distributed recovery received DBID [message #606968 is a reply to message #606930] Fri, 31 January 2014 08:04 Go to previous messageGo to next message
akshara
Messages: 9
Registered: January 2014
Junior Member
SQL> SELECT COUNT(*) FROM USER_OBJECTS@HANSEN.REGRESS.RDBMS.DEV.US.ORACLE.COM;

COUNT(*)
----------
1625

SQL> SELECT COUNT(*) FROM USER_OBJECTS@CSTAR.REGRESS.RDBMS.DEV.US.ORACLE.COM
2 ;

COUNT(*)
----------
1072

SQL> SELECT COUNT(*) FROM USER_OBJECTS@PWMEDIA.REGRESS.RDBMS.DEV.US.ORACLE.COM
2 ;

COUNT(*)
----------
79

seems like every db link is working.i don't know what is the problem.
what is dba_2pc_pending?
SQL> select * from dba_2pc_pending;

LOCAL_TRAN_ID
----------------------
GLOBAL_TRAN_ID
--------------------------------------------------------------------------------
STATE MIX A
---------------- --- -
TRAN_COMMENT
--------------------------------------------------------------------------------
FAIL_TIME FORCE_TIM RETRY_TIM
--------- --------- ---------
OS_USER
----------------------------------------------------------------
OS_TERMINAL
--------------------------------------------------------------------------------
HOST
--------------------------------------------------------------------------------
DB_USER COMMIT#
------------------------------ ----------------
2.21.82515
GIS.REGRESS.RDBMS.DEV.US.ORACLE.COM.9ca8f97d.2.21.82515
collecting no

21-OCT-10 31-JAN-14
arcsde

gisdbprod
RAYG 817570634

what if i restore the db links? do i still get that error?
Re: ORA-02062: distributed recovery received DBID [message #606970 is a reply to message #606968] Fri, 31 January 2014 08:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
just ignore the alert_SID.log entry
Re: ORA-02062: distributed recovery received DBID [message #606971 is a reply to message #606970] Fri, 31 January 2014 08:25 Go to previous messageGo to next message
akshara
Messages: 9
Registered: January 2014
Junior Member
bdump folder is filling with the trace files of this error.My manager wants me to fix this one but don't know how?

[Updated on: Fri, 31 January 2014 08:27]

Report message to a moderator

Re: ORA-02062: distributed recovery received DBID [message #606972 is a reply to message #606971] Fri, 31 January 2014 08:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
file a Service Request with MOS
Re: ORA-02062: distributed recovery received DBID [message #607200 is a reply to message #606972] Mon, 03 February 2014 12:54 Go to previous messageGo to next message
akshara
Messages: 9
Registered: January 2014
Junior Member
this error has started in 2010
Error 2068 trapped in 2PC on transaction 2.21.82515. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 2.21.82515 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from HANSEN
ORA-03135: connection lost contact
Thu Oct 21 10:22:16 2010
DISTRIB TRAN GIS.REGRESS.RDBMS.DEV.US.ORACLE.COM.9ca8f97d.2.21.82515
is local tran 2.21.82515 (hex=02.15.14253)
insert pending collecting tran, scn=817570634 (hex=0.30bb234a)
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c
Thu Oct 21 10:22:16 2010
Errors in file /opt/oracle/admin/gis/bdump/gis_reco_27003.trc:
ORA-02062: distributed recovery received DBID 232de21d, expected e2d7746c

http://www.orafaq.com/forum/mv/msg/67115/185213/#msg_185213

i found this thread

1) SQL> select state, tran_comment, advice from dba_2pc_pending
2 where local_tran_id ='2.21.82515';

STATE
----------------
TRAN_COMMENT
--------------------------------------------------------------------------------
A
-
collecting

2) if i do commit or rollback,i don't think it's going to work it's more than 3 years now.

3)execute dbma_transaction.purge_lost_db_entry('2.21.82515');

if i do the 3rd step,does it effect other database?
please guide me.
Thanks!!
Re: ORA-02062: distributed recovery received DBID [message #607201 is a reply to message #607200] Mon, 03 February 2014 13:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>if i do the 3rd step,does it effect other database?
You should try this. It can't hurt existing transactions.
Re: ORA-02062: distributed recovery received DBID [message #610989 is a reply to message #607201] Wed, 26 March 2014 09:43 Go to previous message
akshara
Messages: 9
Registered: January 2014
Junior Member
I did the 3rd step i.e
execute dbma_transaction.purge_lost_db_entry('2.21.82515');

it fixed my issue.

Thank you!!
Previous Topic: Configuring Oracle gateway for MS SQL Server
Next Topic: access my application over the internet
Goto Forum:
  


Current Time: Fri Mar 29 00:31:09 CDT 2024