Enabling Java in 8i

[pando]

Hi

Does anyone know how to enable Java option in 8i?
I have ran initjvm.sql and set java_pool_size but when I see v$options Java options still says false.

[TerryD]

There is a stored procedure I think you need to run....

I'll try and find out what it is, if you have the upgrade notes, you may find it in there...

[TerryD]

This is what I was thinking of.. Have you run this yet? (as internal)

create or replace java system
/

[pando]

Hi

how long does this command take to finish? ran it for like 7 8 minutses already but it just hangs, checked v$open_cursor and nothing is going on...

[TerryD]

I've never run it to completion becaue I've never used the java option... I ran it once by mistake (as it's listed in the patch details after catalog etc.), but it took so long on my old slow server that I killed the process through boredom!

[pando]

aps has anyone else used java option? :o

[TerryD]

I finally found this on Metalink, don't know if it's of any help:

[url]http://support.oracle.com.sg/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=105472.1[/url]

[pando]

Hm that´s what I did and when I do

SELECT count(*)
FROM dba_objects
WHERE object_type LIKE 'JAVA%';

I see about 9000 objects, however when I see options it still says Java is false. I have everything true expcet Java and Parallel Server...

[rcaballe]

When you ran initjvm.sql everything was fine?
Did you see the output?

[pando]

yep everything was fine, I even checked the logs. The thing is this happened in 2 machines not just 1