Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for April 1st, 2011

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

Posted by Kamran Agayev A. on 1st April 2011

While creating a database link between two databases and querying the remote object, I got the following internal error

[code]

SQL>   CREATE PUBLIC DATABASE LINK "DBTST"
  2     CONNECT TO "USERNAME" IDENTIFIED BY VALUES ‘548674B80234E4BDF8686’
  3     USING ‘DBTST’;

Database link created.

SQL> select name from v$database@DBTST;
Warning: Entry/Exit code is optimized.  Cannot restore context (UNWIND 22)
select name from v$database@DBTST
                            *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdlk_zt2 err], [18446744073709551603], [], [], [], [], [], []

[/code]

After a metalink search I found 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 reason was the in Oracle 10g dblink passwords are stored in special encrypted form to improve database link security. For more information, you can go to the above link

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

[code]

SQL> drop public database link dbtst;

Database link dropped.

SQL>   CREATE PUBLIC DATABASE LINK "DBTST"
  2     CONNECT TO "username" IDENTIFIED BY password
  3     USING ‘DBTST’;

Database link created.

SQL> select name from v$database@DBTST;

NAME
———
DBTST

[/code]

Posted in Administration | No Comments »