Thanks, christoffer, finally I have solved this and it works.
The parameters set I have now, is the following:
****************
shared_pool_size 68157440 (size in bytes )
shared_pool_reserved_size 3407872
large_pool_size 614400
java_pool_size 52500000
java_soft_sessionspace_limit 0
java_max_sessionspace_size 0
50 mb free in the system tablespace
XXX in the rollback segment.
I suppose that the rollback segment space is the following:
SQL> select sum(rssize-writes) from v$rollstat;
SUM(RSSIZE-WRITES)
------------------
29326204
****************
A lot of thanks all,
Christopher Spence wrote:
> I notice this happens when you don't have enough rollback space.
> You may want to go through and check back and see what the original error
> was.
>
> You may want to increase your SP a little and decrease your JP a little.
> Although it is recommended to have SP: 20M JP: 30M for the install, 90M of
> rollback, and if I remember 130M of System Tablespace.
>
> Also, there is a bug on metadink regarding changing call to execute, seems
> to cause this problem as well. Forget the bug number.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax: (707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
> -----Original Message-----
> Sent: Monday, October 01, 2001 5:35 AM
> To: Multiple recipients of list ORACLE-L
>
> 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,
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Christopher Spence
> 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).
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
