RE: ORA-03113 when executing the initjvm script

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Mon, 01 Oct 2001 07:45:58 -0700
Message-ID: <F001.0039D545.20011001061018@fatcity.com>

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: cspence_at_FuelSpot.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 - 09:45:58 CDT