Re: Help, database link reference in PL/SQL causes Oracle error
Date: 29 Jan 2003 09:19:58 -0800
Message-ID: <567a1b1.0301290919.12e19851_at_posting.google.com>
vahe.sarkissian_at_latimes.com (Vahe Sarkissian) wrote in message news:<510e7b7e.0301280757.28a0a92_at_posting.google.com>...
> Hi,
> We have a Oracle 9i installation on SunOS 5.8, with a remote database
> link to Oracle 8i (8.1.7.3.0) on NT.
>
> I can reference the link in interactive SQL (SQL*Plus or TOAD) with no
> problem. But when I try to compile a PL/SQL package or procedure on
> the 9i database that references the link, I get "ORA-03114: Lost
> connection to ORACLE" or "ORA-03113: end-of-file on communication
> channel", and the server dumps a stack trace beginning with:
>
> Unix process pid: 24821, image: oracle_at_etsdev (TNS V1-V3)
>
> *** 2003-01-27 12:20:00.752
> *** SESSION ID:(10.16594) 2003-01-27 12:20:00.728
> Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
> object), addr: 0x0, PC: [0x13d81a8, kglobld()+1060]
> *** 2003-01-27 12:20:00.838
> ksedmp: internal or fatal error
> ORA-07445: exception encountered: core dump [kglobld()+1060]
> [SIGSEGV] [Address not mapped to object] [0x0] [] []
> Current SQL statement for this session:
> CREATE OR REPLACE PACKAGE BODY ....
>
> This is just on the compile step -- it never reaches execution. If I
> substitute a link to a different 8i server (also on NT, but on a
> different machine), the problem goes away.
>
> The DBA is trying to get a hold of Oracle support, but I'm wondering
> if the collective wisdom of the net could give us any clue what's
> going on.
>
> Thanks in advance,
> --Vahe Sarkissian
sorry if you've already discovered this, but it appears to be a known bug (see metalink note 189914.1) and is supposed to be fixed in 9iR2 or 9.0.1.3. Received on Wed Jan 29 2003 - 18:19:58 CET