Scribd
Upload
62 views1 page

Java Installation for Oracle Database

Java may already be installed in the database. To check, run a SQL query to count Java objects. If Java is installed, run scripts to replace it. Otherwise, run scripts located in the javavm directory to install Java, which may report errors that can be ignored.

Uploaded by

psaikrish
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
62 views1 page

Java Installation for Oracle Database

Java may already be installed in the database. To check, run a SQL query to count Java objects. If Java is installed, run scripts to replace it. Otherwise, run scripts located in the javavm directory to install Java, which may report errors that can be ignored.

Uploaded by

psaikrish
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Installing or Reinstalling Java

November 5, 2002

The following was taken from the [Link] Oracle 8i Data Server Patch Set readme.

1. If Java has previously been loaded into the database, invoke SQL*Plus (sqlplus),
connect as internal and run the following SQL DDL command:
SQL> create or replace java system
2 /
(Note that the / (slash) is important to ensure the execution of the command).
To ensure the correct installation of the XDK in the database run the following 2
scripts (Bug 2115227):
$ORACLE_HOME/oracore/admin/[Link]
$ORACLE_HOME/rdbms/admin/[Link]

* To determine whether Java has previously been loaded into


the database:
invoke SQL*Plus (sqlplus), connect as internal and run the
following:

SQL> select count(*) from all_objects where object_type like


'JAVA%';

Java is installed if you get a non zero result returned from the query.
2. If Java has previously been loaded into the database, invoke SQL*Plus (sqlplus),
connect as internal and run the following scripts which are located in
$ORACLE_HOME/javavm/:
load_jis.sql
[Link]
[Link]
[Link]

Notes:
When running the $ORACLE_HOME/javavm/install/[Link] script the following
error may be reported and can be ignored:
call jis_exit_java_session(0)
ERROR at line 1:
ORA-29515: exit called from Java code with status 0
Bug 1459233 was filed against this problem which is fixed in 9i.

I:\Software\Fims\[Link]

You might also like