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).
