Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-3113 and 1041 with large PL/SQL scripts
I saw a similar error once.
This in only applicable to UNIX sqlplus though.
The sqlplus executable was different from the libraries being picked up in the
LD_LIBRARY_PATH variable.
i.e. sqlplus was in the 7.3.2.3 $ORACLE_HOME and the LD_LIBRARY_PATH was 7.1.6
This took forever on a sev 1 TAR with Oracle to find.
Bart Kersteter wrote:
> Hello,
>
> I'm writing a decent-sized PL/SQL package (2000 + lines ) and when I try to
> compile the package body, I get an ORA-3113 'End of file on communication
> channel.' This is followed up with an ORA 3114 immediately. When I exit
> SQL*Plus, I get an ORA-01041 'hostdef extension doesn't exist' error.
>
> I've checked with Oracle Metalink and they suggest taking out any
> DBMS_OUTPUT procedure calls. This doesn't work for me, unfortunately.
> Also, I've increased my buffer size, MAXDATA and serveroutput buffer size to
> the max. (This is on a server with 1GB RAM and an SGA sized to match).
>
> Might one of the PL/SQL gurus out there have any ideas to try?
>
> Thanks,
>
> Bart
Received on Tue Apr 21 1998 - 22:59:11 CDT