how to confirm JServer is installed in the db

Hi,

db:10.1.0.4
owb :10.1.0.4
AIX 5.2


Iam trying to install the OWB runtime repository during installtion Iam getting the error
INS0029: Error occurred during installation. Check the logfile
and in the logfile
i found the error as
ORA-01919: role 'JAVADEBUGPRIV' does not exist

I installed base software 10.1.0.2,applied the patch 10.1.0.4 and created the database manually.

while installing the OWB(ORACLE Warehouse Builder) there is pre-requiste saying:

When you install Warehouse Builder Runtime, you must have a working Oracle Database installation with J server installed

when i checked the value in the database for java in v$option;
select * from v$option;

JAVA True

is that mean JServer installed in my database or only java installed.

How to diffrentiate between these two and how to confirm that JServer is installed in my DB?


please guide.

Thanks

Gurus,

After doing little bit research I got it.

to verify whether JServer is installed or not :

dba_registry;

and need to run the $ORACLE_HOME/javavm/install/initjvm.sql.
to install the JServer.

I got this from orafaq using google.

Thanks

Quote:

---

Originally Posted by zakriyamhd

Gurus,

After doing little bit research I got it.

to verify whether JServer is installed or not :

dba_registry;

and need to run the $ORACLE_HOME/javavm/install/initjvm.sql.
to install the JServer.

I got this from orafaq using google.

Thanks

---

Can also get it from Oracle universal installer