June 18th 2011 01:26 am

alert "ORA-02019 : connection description for remote database not found" on alert log

Problem : Selalu muncul error ORA-02019 : connection description for remote database not found di alert log. Sebelumnya memang terdapat dblink ke database lain tetapi itupun sudah di drop dan tidak ada stored procedure yang mengarah/menggunakan dblink sama sekali.

Alert log :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Thread 1 advanced TO log SEQUENCE 9592
CURRENT log# 3 seq# 9592 mem# 0: /oradata/emrep/emrep/redo03.log
Thu Jun 16 13:30:34 2011
Errors IN file /oracle/app/admin/emrep/bdump/emrep_reco_3230.trc:
ORA-02019: connection description FOR remote DATABASE NOT found
Thu Jun 16 13:30:34 2011
Errors IN file /oracle/app/admin/emrep/bdump/emrep_reco_3230.trc:
ORA-02019: connection description FOR remote DATABASE NOT found
Thu Jun 16 13:30:34 2011
Errors IN file /oracle/app/admin/emrep/bdump/emrep_reco_3230.trc:
ORA-02019: connection description FOR remote DATABASE NOT found
Thu Jun 16 14:17:18 2011
Errors IN file /oracle/app/admin/emrep/bdump/emrep_reco_3230.trc:
ORA-02019: connection description FOR remote DATABASE NOT found
Thu Jun 16 14:17:18 2011
Errors IN file /oracle/app/admin/emrep/bdump/emrep_reco_3230.trc:
ORA-02019: connection description FOR remote DATABASE NOT found
Thu Jun 16 14:17:18 2011
Errors IN file /oracle/app/admin/emrep/bdump/emrep_reco_3230.trc:
ORA-02019: connection description FOR remote DATABASE NOT found

Penyebab : Hal ini dikarenakan terdapat transaksi yang masih gantung yang merefer ke database link padahal database linknya sendiri sudah tidak ada.

Solusi : Check table dba_2pc_pending.

1
SQL> SELECT LOCAL_TRAN_ID,GLOBAL_TRAN_ID,STATE,MIXED,COMMIT# FROM DBA_2PC_PENDING;

Ambil nilai local tran_id lalu purging transaksi tersebut menggunakan package DBMS_TRANSACTION.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
SQL> conn /AS sysdba
Connected.
SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('21.27.30277');
 
PL/SQL PROCEDURE successfully completed.
 
SQL> COMMIT;
 
Commit complete.
 
SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('3.18.124253');
 
PL/SQL PROCEDURE successfully completed.
 
SQL> COMMIT;
 
Commit complete.
 
SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('15.42.11902');
 
PL/SQL PROCEDURE successfully completed.
 
SQL> COMMIT;
 
Commit complete.

Check alert log lagi beberapa saat, maka error tersebut tidak akan muncul sama sekali.

Incoming search terms:

  • ora-02019: connection description for remote database not found
  • ora-02019 connection description for remote database not found
  • ora-02019
  • ora-02019 connection description for remote database in alert log

Tags:

2 Comments »

2 Responses to “alert "ORA-02019 : connection description for remote database not found" on alert log”

  1. Gabriel on 25 Sep 2012 at 1:14 pm #

    Thanks for any other excellent post. Where else could anybody get that kind of information in such a perfect manner of writing?
    I have a presentation subsequent week, and I am on the look for such information.

  2. education on 08 Apr 2013 at 3:50 am #

    Fantastic post however I was wondering if you could write a litte more on this
    subject? I'd be very grateful if you could elaborate a little bit further. Thanks!

Trackback URI | Comments RSS

Leave a Reply

Optionally add an image (JPEG only)

« | »