| JVM [message #233590] |
Thu, 26 April 2007 14:27  |
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 #233599 is a reply to message #233594] |
Thu, 26 April 2007 15:34  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
