ORA-00600: internal error code, arguments: [kzdlk_zt2 err]
Posted by Kamran Agayev A. on April 1st, 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]