Re: Oracle 10gR2: ORA-0600 when accessing data over database link

On 14 Feb 2007 08:21:22 -0800, "Mark D Powell" <Mark.Powell_at_eds.com> wrote:

>On Feb 14, 9:37 am, AlexB <b..._at_pisem.net> wrote:
>> Good day, everyone.
>>
>> I am testing Oracle 10gR2 on a Linux for POWER platform, and I came across a
>> strange crash when trying to access data over database link:
>>
>> SQL> desc workorder_at_l_amos
>> ERROR:
>> ORA-00600: internal error code, arguments: [kzdlk_zt2 err],
>> [18446744073709551603], [], [], [], [], [], []
>>
>> and then a huge text file in ?/admin/@/udump directory, containing all the
>> environment at the time of crash:
>>
>> [quote]
>> *** ACTION NAME:() 2007-02-14 15:49:11.349
>> *** MODULE NAME:(SQL*Plus) 2007-02-14 15:49:11.349
>> *** SERVICE NAME:(SYS$USERS) 2007-02-14 15:49:11.349
>> *** SESSION ID:(139.24400) 2007-02-14 15:49:11.349
>> *** 2007-02-14 15:49:11.349
>> ksedmp: internal or fatal error
>> ORA-00600: internal error code, arguments: [kzdlk_zt2 err],
>> [18446744073709551603], [], [], [], [], [], []
>> Current SQL statement for this session:
>> select count(*) from address_at_l_amos
>> ----- Call Stack Trace -----
>> calling call entry argument values in hex
>> location type point (? means dubious value)
>> -------------------- -------- -------------------- ----------------------------
>> ksedst()+36 bl ksedst1()+0
>> ksedmp()+700 bl ksedst()+0
>> ...
>>
>> ....
>> [unquote]
>>
>> Any type of SQL statement crashes - SELECT, DESCRIBE, UPDATE etc. Tables which I
>> am trying to access do not contain any LONG columns.
>>
>> I did some tests and found out, that this crash happens if database link has
>> been created with 'IDENTIFIED BY VALUES' clause:
>>
>> SQL> CREATE PUBLIC DATABASE LINK L_AMOS CONNECT TO AMOSLINK IDENTIFIED BY VALUES
>> '3412736517' USING 'DBSRV2';
>>
>> DBSRV2 is an Oracle 9.2.0.8 database running on AIX.
>>
>> If I create database link and use IDENTIFIED BY <password> clause - everything
>> works.
>>
>> Did not test same on Oracle9i yet, but this behavior seem to be stable on 10gR2
>>
>> Oracle version is:
>>
>> Connected to:
>> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
>> With the Partitioning, OLAP and Data Mining options
>>
>> I cannot remember password for remote user, this is why I am trying to use
>> CREATE DATABASE LINK ... IDENTIFIED BY VALUES, otherwise I have to change
>> password for this user and then sdjust other database links on other servers.
>>
>> Anyone has this issue or am I the only one?
>>
>> Kind regards,
>>
>> Alex
>
>I checked metalink but did not find a hit on the "kzdlk_zt2 err" as
>being published.
>
>You findings are interesting. Are you using the Oracle Wallet
>feature?
>
>I would suggest recreating the links using username password strings
>if you know them as a work-a-round since you have discovered this.
>
>Since you have a repeatable case I suggest that if you have support
>you open a Service Request with Oracle. I would attempt to duplicate
>you error if we had a working 10gR2 system to do this with but it is
>on hold while we migrate other database across platforms.
>
>If you do not have a support contract post back with this fact and
>maybe someone who does and also uses database links will have the time
>to duplicate your error and will want to pursue this.
>
>How did you get data and the links into 10gR2: Upgrade in place, data
>migration between versions, or new install.
>
>HTH -- Mark D Powell --

I failed to find anything on Metalink, too, and that is why I posted my findings here. Finally, I managed to recover password for the 'AMOSLINK' account from my records and re-created database links. Now everything works fine. I am not using Oracle Wallet feature, label security or any additional authentication modules - authentication is straight password check. We do have a support contract, never opened a Service Request, though. I bet it is a good opportunity to try opening a Service request. I will make some more experiments to see if situation is steadily reproducible before aplpying to Oracle (will check 9i, too) and post results here.

Data has been exported from 9i using exp utility 9.2.0.8 and imported to fresh install 10gR2 using imp 10.2.0.2. Somehow database links were not imported with our schemas (possibly they were PUBLIC, created by SYS), so I re-created them using Quest Toad for Oracle tool: extracted script for AMOSLINK user, then pasted 'IDENTIFIED BY VALUES' clause into CREATE DATABASE LINK statement.

---
Alex