ORA-00600: internal error code, arguments: [kzdlk_zt2 err]

By Kamran Agayev A.

Recently, I was creating a database link between two databases and querying the remote object, I got the following ORA-00600 internal error:

01 SQL>   CREATE PUBLIC DATABASE LINK "DBTST"
02   2     CONNECT TO "USERNAME" IDENTIFIED BY VALUES '548674B80234E4BDF8686'
03   3     USING 'DBTST';
04   
05 Database link created.
06   
07 SQL> select name from v$database@DBTST;
08 Warning: Entry/Exit code is optimized.  Cannot restore context (UNWIND 22)
09 select name from v$database@DBTST
10                             *
11 ERROR at line 1:
12 ORA-00600: internal error code, arguments: [kzdlk_zt2 err], [18446744073709551603], [], [], [], [], [], []

After a MOSC search, I was able to determine that it’s a bug:

 Bug:5576894 – Abstract: GET ORA-600 [KZDLK_ZT2_ERR] WHEN LINK CREATED WITH ‘IDENTIFIED BY VALUES’

ORA-00600: [Kzdlk_zt2 Err] While Selecting Using a Database Link [ID 456320.1]

The error was due to the fact that in Oracle 10g dblink passwords are stored in special encrypted form to improve database link security. MOSC has more information.

 As a solution, you need to create a database link without “IDENTIFIED BY VALUES” clause:

 01 SQL> drop public database link dbtst;
02   
03 Database link dropped.
04   
05 SQL>   CREATE PUBLIC DATABASE LINK "DBTST"
06   2     CONNECT TO "username" IDENTIFIED BY password
07   3     USING 'DBTST';
08   
09 Database link created.
10   
11 SQL> select name from v$database@DBTST;
12   
13 NAME
14 ---------
15 DBTST