Thursday, 14 January 2016

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



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

Situation
============

SQL>create public database link Pub_DB_user
  connect to Pub_DB_user identified by values '1A1BB86FA3C47631'
  using 'PROD_DB';



SQL> set pages 1000 lines 180
column DB_LINK format a30
column HOST format a50
select * from dba_db_links;

OWNER                          DB_LINK                        USERNAME                       HOST                                               CREATED
------------------------------ ------------------------------ ------------------------------ -------------------------------------- ---------
PUBLIC                         Pub_DB_user                  Pub_DB_user                  PROD_DB                                             15-JAN-16



SQL> select count(*) from dual@Pub_DB_user;
select count(*) from dual@Pub_DB_user
                          *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdlk_zt2 err], [1844674407370955160


Solution :- (Recreate the database link using valid syntax. )
================================================================


SQL > Drop public database link "Pub_DB_user";

SQL > create public database link Pub_DB_user
      connect to Pub_DB_user identified by allow123
      using 'PROD_DB';


     
Note :-

There is MOS note related to this error: [ID 1309705.1]


 The error suggests that when the database link was created, using the syntax IDENTIFIED BY VALUES.
 this clause IDENTIFIED BY VALUES is reserved for internal Oracle use only.
 While earlier Oracle releases allowed the use of IDENTIFIED BY VALUES, this is not documented as being valid syntax.
 From Oracle release 10gR2, database links must be created using the documented syntax.

Although you could create database link using this syntax but it's not have documented as being valid syntax. So use valid when we would be create DBLINK.

  

No comments:

Post a Comment