| Installing DBMS_JAVA package [message #92121] |
Tue, 16 March 2004 23:57  |
Ong
Messages: 5
Registered: January 2004
|
Junior Member |
|
|
|
I recently came to discover that one of my client's Oracle 9i database (unix platform) is installed without a DBMS_JAVA package which in turn forbids me to load java stored procedures. Can someone help me or tell me how do i install the package? Bear in mind, the database is the REAL thing not a testing machine. Thanks!
|
|
|
|
|
|
|
|
| Re: Installing DBMS_JAVA package [message #92432 is a reply to message #92121] |
Wed, 14 July 2004 02:27  |
Debashis Panigrahi
Messages: 1
Registered: July 2004
|
Junior Member |
|
|
Hi
This is Debashis here
Plz follow these steps to install DBMS_JAVA package
1) Connect to sys account
Ex:connect / as sysdba
Check the database status, because it has to be in
OPEN state.
Ex:select status from v$instance;
2)just run initjvm.sql script to install DBMS_JAVA
package
SQL>@ORACLE_HOMEjavavminstallinitjvm.sql
Just write the complete path name of ur ORACLE_HOME
Regds
Dev
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
