post migration errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: post migration errors

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    post migration errors

    Hi friends ,

    i have just migrated from 8.1.6 to 8.1.7

    but while compiling i am getting following error message ...
    is there anything i am missing in database migration ...

    i could start the listner ... start the database ..

    any insight in this ...

    $ doit.sql
    ksh: doit.sql: not found
    $ ./doit
    dropping ...
    dropping class : JSDgetCrit
    Compiling ...
    loading ...
    initialization complete
    loading : JSDgetCrit
    creating : JSDgetCrit
    Error while computing shortname of JSDgetCrit
    ORA-06550: line 1, column 13:
    PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    resolver :
    Error while computing shortname of JSDgetCrit
    ORA-06550: line 1, column 13:
    PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    resolving: JSDgetCrit
    Error while computing shortname of JSDgetCrit
    ORA-06550: line 1, column 13:
    PLS-00201: identifier 'DBMS_JAVA.SHORTNAME' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    errors : JSDgetCrit
    ORA-29521: referenced name java/io/PrintStream could not be found
    ORA-29521: referenced name java/lang/Exception could not be found
    ORA-29521: referenced name java/lang/Integer could not be found
    ORA-29521: referenced name java/lang/Math could not be found
    ORA-29521: referenced name java/lang/NumberFormatException could not be foun
    d
    ORA-29521: referenced name java/lang/Object could not be found
    ORA-29521: referenced name java/lang/String could not be found
    ORA-29521: referenced name java/lang/StringBuffer could not be found
    ORA-29521: referenced name java/lang/System could not be found
    ORA-29521: referenced name java/lang/Throwable could not be found
    ORA-29521: referenced name java/sql/CallableStatement could not be found
    ORA-29521: referenced name java/sql/Connection could not be found
    ORA-29521: referenced name java/sql/PreparedStatement could not be found
    ORA-29521: referenced name java/sql/ResultSet could not be found
    ORA-29521: referenced name java/sql/SQLException could not be found
    ORA-29521: referenced name java/sql/Statement could not be found
    ORA-29521: referenced name java/sql/Types could not be found
    ORA-29521: referenced name java/util/ArrayList could not be found
    ORA-29521: referenced name java/util/Vector could not be found
    ORA-29521: referenced name oracle/jdbc/driver/OracleDriver could not be foun
    d
    loadjava: 23 errors
    done

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Hi friends ,

    i figured this out ,
    just for everyone's benefit .. if any java store procedures are present in the database we need to instal jvm

    i ram @$ORACLE_HOME/javavm/install/initjvm.sql

    then everthing went fine .

    Thanks .

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