DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: initjvm.sql

  1. #1
    Join Date
    Jun 2001
    Posts
    76
    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.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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?




  3. #3
    Join Date
    Jun 2001
    Posts
    76
    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.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938


    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 :-)


  5. #5
    Join Date
    Jun 2001
    Posts
    76
    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
  •  


Click Here to Expand Forum to Full Width