Home » SQL & PL/SQL » SQL & PL/SQL » Installing Java manually in Oracle8i
Installing Java manually in Oracle8i [message #36679] Tue, 11 December 2001 23:20 Go to next message
David Jeyathilak
Messages: 9
Registered: October 2001
Junior Member
Hi,

While I was executing an Oracle PL/SQL procedure which sends a mail, It gave me an error message saying "ORA-29540: class oracle/plsql/net/TCPConnection does not exist".
After refering to pre-requisites in the URL, http://home.clara.net/dwotton/dba/oracle_smtp.htm, I executed this script "$ORACLE_HOME/javavm/install/initjvm.sql" as SYS to install java.

It gave me the following errors....Please help.

regards,
David
----------------------------------------------
drop index java$rmjvm$auxi
*
ORA-01418: specified index does not exist
drop index java$rmjvm$auxi2
*
ORA-01418: specified index does not exist

drop role javauserpriv
*
ORA-01919: role 'JAVAUSERPRIV' does not exist
Statement processed.
Statement processed.
drop role javaidpriv
*
ORA-01919: role 'JAVAIDPRIV' does not exist
Statement processed.
Statement processed.
drop role javasyspriv
*
ORA-01919: role 'JAVASYSPRIV' does not exist
Statement processed.
Statement processed.
Statement processed.
drop role javadebugpriv
*
ORA-01919: role 'JAVADEBUGPRIV' does not exist
Statement processed.
create or replace java system;
*
ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater
COUNT(*)
----------
0
1 row selected.
Statement processed.
JVMRMACTION
------------
FULL_REMOVAL

Statement processed.
create or replace trigger aurora$server$startup after startup on database call dbms_java.server_startup
*
ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater
create or replace trigger aurora$server$shutdown before shutdown on database call dbms_java.server_shutdown
*
ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater
Statement processed.
-----------------------------------------------------

----------------------------------------------------------------------
Re: Installing Java manually in Oracle8i [message #36691 is a reply to message #36679] Wed, 12 December 2001 17:56 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
change compatible parameter in init.ora file.
other errors are common (drop...).
compatible=8.1.0

----------------------------------------------------------------------
Re: Installing Java manually in Oracle8i [message #36698 is a reply to message #36679] Thu, 13 December 2001 06:22 Go to previous messageGo to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
i had to do a manual java install on 8.1.6., oracle recommended minimum system requirements before running the script SHARED_POOL_SIZE 65MB, JAVA_POOL_SIZE 50MB, 50MB free space in SYSTEM tablespace, use 250MB sized rollback. i also recall that after a failed install i needed to run a remove script before trying to install again rmjvm.sql(should be located in the same directory as the install script) run this query
SELECT Count(1)
FROM dba_objects
WHERE object_type Like '%JAVA%';
you should get >4000 rows if less run rmjvm.sql and try again with adjusted system requirements

----------------------------------------------------------------------
Re: Installing Java manually in Oracle8i [message #36703 is a reply to message #36679] Thu, 13 December 2001 10:00 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
THINGS TO DO BEFORE INSTALLING JVM...

Rollback segment space
Allocate at least 100MB worth of rollback segment space for the JVM install, this is in addition to the rollback segment space allocated for any other activity on the database.

2.System tablespace

Combined, all of the scripts will consume approximately 130MB of free space in the system tablespace. The objects introduced by the initjvm.sql script will consume approximately 90MB of the system tablespace by itself.

3) Shared_pool_size
At least 50MB of free shared_pool space is needed. That is a minimum for the JVM installation.

4) Java_pool_size
30MB should be adequate for the Installation.The pool sizes can be monitored by querying V$SGASTAT.

Eg: SQL> select * from v$sgastat where name = 'free memory';

----------------------------------------------------------------------
Previous Topic: PL/SQL and API's
Next Topic: fetch question. plz help ;
Goto Forum:
  


Current Time: Mon Aug 03 05:04:10 CDT 2020