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

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 -- Received on Wed Feb 14 2007 - 10:21:22 CST