initjvm.sql

All -

I tried running the initjvm.sql ($ORACLE_HOME/javavm/install/initjvm.sql) script on my database and it returned many errors.

I am curious if there is some sort of preparation I must do before trying to run the script.

Thanks,

R

You do not provide much info on the character of those errors, the version you use but let's try.

1. Create a big RBS.
2. Bounce the instance with only that RBS (edit init.ora first).
3. remove the javavm (copy it locally somewhere first, you will edit it a bit later): $ORACLE_HOME/javavm/install/initjvm.sql
4. Run 'create or replace java system;'
5. Remove 'create or replace java system;' from initjvm.sql
6. Now run the initjvm.sql file

You run Oracle below 8.1.7, right?

Oracle 8.1.5
Solaris 7

I did what you suggested, and it worked (thank you). However, when I tried to run it in sqlplus it died. So I then tried it using svrmgrl, and it appeared to run flawlessly. Any thoughts as to why? The errors I got ranged from "object does not exist" to "identifier must be declared" and so on...


R (once again, than you)

Quote:

---

I did what you suggested, and it worked (thank you).

---

You are welcome!

Quote:

---

The errors I got ranged from "object does not exist" to "identifier must be declared" and so on...
(once again, than you)

---

I'can't say for sure. If you post the complete error info. But since everything is OK now, I hope it doesn't matter :-)

A week later, I realize that JServer has not been correctly installed. Now when I try to run $ORACLE_HOME/javavm/install/initjvm.sql, I get the following errors:

...
Statement processed.
DBMS_JAVA.LONGNAME(NAME)
--------------------------------------------------------------------------------
0 rows selected.
DBMS_JAVA.LONGNAME(O.NAME) TEXT
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
USAGE_RADDAILY_DOMAIN_V ORA-00904: invalid column name

GET_ERROR$ PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow
GET_ERROR$ PLS-00905: object USAGETEST.GET_ERROR$ is invalid
GET_ERROR$ PLS-00304: cannot compile body of 'GET_ERROR$' without its specification
GET_ERROR$ PL/SQL: Compilation unit analysis terminated
DBMS_ORB_CONTEXT PLS-00103: Encountered the symbol "end-of-file" when expecting one of the follow
DBMS_ORB_CONTEXT PLS-00905: object USAGETEST.DBMS_ORB_CONTEXT is invalid
DBMS_ORB_CONTEXT PLS-00304: cannot compile body of 'DBMS_ORB_CONTEXT' without its specification
DBMS_ORB_CONTEXT PL/SQL: Compilation unit analysis terminated
DBMS_JAVA PLS-00201: identifier 'DBMS_JAVA' must be declared
DBMS_JAVA PLS-00304: cannot compile body of 'DBMS_JAVA' without its specification
DBMS_JAVA PL/SQL: Compilation unit analysis terminated
SQLJUTL PLS-00201: identifier 'ARGUMENT$' must be declared
SQLJUTL PL/SQL: SQL Statement ignored
SQLJUTL PLS-00201: identifier 'ARGUMENT$' must be declared
SQLJUTL PL/SQL: SQL Statement ignored
16 rows selected.
Statement processed
...

Any suggestions?