Home » RDBMS Server » Server Administration » JVM
JVM [message #233590] Thu, 26 April 2007 14:27 Go to next message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
Hello Experts,

I was investigate if/how JVM can be installed on a machine or a database? Basically in order for my application to work, i need to have JVM enable for the database.

would greatly apprecaite, if someone please advice.

Many thanks,
Cali
Re: JVM [message #233594 is a reply to message #233590] Thu, 26 April 2007 15:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i need to have JVM enable for the database

What do you mean?

Regards
Michel
Re: JVM [message #233599 is a reply to message #233594] Thu, 26 April 2007 15:34 Go to previous messageGo to next message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
Well i have a application package which i would like to create in a database. This package requires JVM. I was investigating how JVM can be installed on a Database? Thats what i meant.

So could somebody please advice?
Re: JVM [message #233603 is a reply to message #233599] Thu, 26 April 2007 16:26 Go to previous messageGo to next message
dbaxchangedba
Messages: 26
Registered: November 2005
Junior Member
You haven't included the database version but for a 9i database on a unix box, its as simple as running $ORACLE_HOME/javavm/install/initjvm.sql as sysdba through sqlplus.
A few pre-requisites for installing JVM on the database:

SHARED_POOL_SIZE >= 60Mb (minimum)
JAVA_POOL_SIZE >= 30Mb
The SYSTEM tablespace has at least 120Mb of free space
The RBS tablespace has at least 250Mb of free space

Oracle's metalink has a script that checks your database to see if you meet the pre-requisites.

Also, make sure that your database is not java enabled already. To check if your database is already java enabled:

select count(*), owner from all_objects
where object_type like '%JAVA%' group by owner;

If there are pre-existing java objects within the database then you'll have to do a JVM reload which are a different set of steps. Oracle's metalink has detailed instructions on the reload process.

Good Luck.......

http://www.dbaxchange.com
Re: JVM [message #233814 is a reply to message #233603] Fri, 27 April 2007 11:37 Go to previous message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
Sorry forget to mention my oracle version. But you are right, I am using Oracle 9i version. Thank you so much for your answer. I will look into this.

Thanks again
Cali

Previous Topic: Character Set Change
Next Topic: 8.1.7 Error
Goto Forum:
  


Current Time: Fri Dec 09 17:29:14 CST 2016

Total time taken to generate the page: 0.13068 seconds