-
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
On the other hand, you have different fingers.
-
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)
On the other hand, you have different fingers.
-
I did what you suggested, and it worked (thank you).
You are welcome!
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?
On the other hand, you have different fingers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|