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.