Re: JServer running/installed ?

Here's a couple of sanity checks which are very good indication of a properly installed JServer/Oracle VM:

select count(*) from all_objects where object_type like 'JAVA%';

should return more than 4000 (up to 10000+ depending on options installed).

SQL> describe SYS.DBMS_JAVA

should print out package routines description. If both checks return expected results then you have very good chance (close to 100%) that JServer is installed correctly and will operate.

Oh, and one more check, maybe this one is the easiest:

select sys.utl_inaddr.get_host_name from sys.dual;

should return your Oracle host name. Since this package uses Java to implement its functionality, if it works then Java VM is operational.

Corrections and additions welcome.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Leopold Zyka" <leopold.zyka_at_igel.at> wrote in message news:3DEE48C8.3EF3BCF4_at_igel.at...


> Dear Oracle Gurus,

> 

> Is there any query to find out if JServer is installed/running under

> Oracle 8i ?

> 

> thx for your help !

> Leo

> 

>