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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > title:Ingeniera Informática > fn:Beatriz Martínez Jiménez > end:vcard > ===== Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
