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