Look in trace files. Probably you are hitting a 4030
error. If this the case, not only shared_pool_size or
java_pool_size are the parameters to be increased.
Also increase java_soft_sessionspace_limit or
java_max_sessionspace_size.
If it isn't a 4030 case, put the event to get the
errorstack of the 3113 in the init.ora:
event="3113 trace name errorstack level 10"
REGARDS.
- Beatriz Martínez Jiménez <beamar_at_cidaut.es> wrote:
> Hello all of you,
> I get the ORA-03113 (end-of-file on communication
> channel) error when I
> execute the initjvm script. This script is needed to
> use utl_smtp
> package. Here is the output I get:
> *******
> ERROR:
> ORA-03114: not connected to ORACLE
> create or replace java system;
> *
> ERROR en línea 1:
> ORA-03113: end-of-file on communication channel
> *********
>
> The script is composed of several calls to another
> scripts, and is in
> the second one, the initjvm2.sql where the error
> appears.
> I have checked the trace and log files, but there
> isn´t any one that
> give me a clue on the problem.
> I have read something about checking some
> parameters, here is the output
> showing them:
> **********
> SQL> select * from v$parameter
> 2 where name like '%pool_size%';
>
> NUM
> NAME
> TYPE
> ----------
>
> ----------
> VALUE
>
>
> ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ
> --------- ----- --------- ---------- -----
> DESCRIPTION
>
> 23
> shared_pool_size
> 2
> 19643392
> FALSE FALSE FALSE FALSE FALSE
> size in bytes of shared pool
>
> 28
> large_pool_size
> 2
> 614400
> FALSE FALSE FALSE FALSE FALSE
> size in bytes of the large allocation pool
>
> 30
> java_pool_size
> 2
> 52500000
> FALSE FALSE FALSE FALSE FALSE
> size in bytes of the Java pool
> *************
> I think they are setting correctly...
> Has anyone faced this problem?
> TIA,
> > begin:vcard
> n:Jimenez;Beatriz Martinez
> x-mozilla-html:FALSE
> org:Fundación CIDAUT;Departamento de Informática
> adr:;;Parque Tecnológico de Boecillo
> p.209;Boecillo;Valladolid;47151;Spain
> version:2.1
> email;internet:beamar_at_cidaut.es
> title:Ingeniera Informática
> fn:Beatriz Martínez Jiménez
> end:vcard
>
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Oct 01 2001 - 04:38:22 CDT
