New Cartridge install and Java Errors.

Good Morning,





I am installing a new JCHEM and Cartridge server alongside an Oracle 10g R2 installation.  I downloaded the package which included java and installed.





./install.sh jchem/jchem@jchem worked fine, and all the index types, procedures, tables were created correctly.  During the next step, where I run





call jchem_core_pkg.use_password('jchem');





I recive an error, and when I run the ./test.sh jchem/jchem@jchem I recieve the following output.





************************************************************************





[root@sdprdjchem cartridge]# ./test.sh jchem/jchem@jchem





SQL*Plus: Release 10.1.0.3.0 - Production on Tue Mar 24 07:49:46 2009





Copyright (c) 1982, 2004, Oracle.  All rights reserved.





Enter user-name:


Connected to:


Oracle Database 10g Release 10.1.0.3.0 - 64bit Production





SQL> select jchem_core_pkg.getenvironment() from dual


       *


ERROR at line 1:


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.ExceptionInInitializerError


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 29


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 80








Disconnected from Oracle Database 10g Release 10.1.0.3.0 - 64bit Production





************************************************************************





Any help would be greatly apprecieated.  I am using the most rescent version of JCHEM downloaded from the site for Linux.





Thanks,





Brian Jackson

Good Morning Brian,





Are you sure this is the most recent JChem version? In the installation instructions of the most recent JChem Cartridge version (5.2.0), I cannot find any reference to the install.sh script or the test.sh script.





Thanks





Peter

Peter,





I did not have the correct instructions for the current cartridge install, I was using a previous versions documentation.  After going through the new documentation, I am able to connect to ORACLE, begin the schema intall and then encounter an error.





**************************************************************************








Name of the Oracle host. [localhost]:





Oracle listener port [1521]:





Name of the Oracle instance [mydb]: jchem





The host name of the JChem Server [localhost]:





The port at which the JChem Server accepts connections [1099]:





maximum memory allocated to JChem Server [700m]:


INFO: Checking JChem Server at localhost:1099...





DBA login [SYSTEM]:


DBA password:





Name of the cartridge owner: jchem


Password of the cartridge owner:





====> Schema jchem doesn't exists. It will be created





Local TNS name of the Oracle instance. [jchem]: ?





====> The local TNS name of the Oracle instance.





Local TNS name of the Oracle instance. [jchem]:





The role for basic JChem Cartridge user privileges [JCC_BASIC_ROLE]: ?





====> The role for basic JChem Cartridge user privileges





The role for basic JChem Cartridge user privileges [JCC_BASIC_ROLE]:








You have entered the following parameters:


==========================================





Name of the Oracle host.: localhost


Oracle listener port: 1521


Name of the Oracle instance: jchem


The host name of the JChem Server: localhost


The port at which the JChem Server accepts connections: 1099


maximum memory allocated to JChem Server: 700m


DBA login: SYSTEM


Name of the cartridge owner: jchem


Local TNS name of the Oracle instance.: jchem


The role for basic JChem Cartridge user privileges: JCC_BASIC_ROLE





Proceed with the Install? (y,n) [n]: y


INFO: Creating schema jchem


INFO: Checking JChem Server at localhost:1099...


INFO: Loading PL/SQL script jcart.jar into jchem's schema...


INFO: Loading PL/SQL script jchem_cart.sql_i into jchem's schema...


INFO: Loading PL/SQL script jchem_util.sql into jchem's schema...


INFO: Loading PL/SQL script jchem_opti.sql into jchem's schema...


INFO: Loading PL/SQL script privman.sql into jchem's schema...


java.sql.SQLException: ORA-29540: class chemaxon/jchem/cartridge/JcMetaDataFunct


ions does not exist





        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja


va:70)


        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1


31)


        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java


:204)


        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)


        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)


        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)


        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)


        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)





        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme


nt.java:1222)


        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja


va:1770)


        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)





        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrap


per.java:299)


        at chemaxon.jchem.cartridge.install.Schema.executeSql(Schema.java:1454)


        at chemaxon.jchem.cartridge.install.Installer.registerRmiLocator(Install


er.java:116)


        at chemaxon.jchem.cartridge.install.Installer.install(Installer.java:73)





        at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLin


e.java:150)


        at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLin


e.java:84)


        at chemaxon.jchem.cartridge.install.InstallCmdLine.main(InstallCmdLine.j


ava:682)





************************************************************************





Any help is greatly appreciated,





Brian Jackson

Brian,





The only explanation I can think of is that you have some unusual setting in your database. (I've just did a successful install with this version in a brand new database which I created exclusively for this purpose.) How did you create your database: did you use DBCA or scripts?





Thanks





Peter

I setup a general use DB when I installed oracle.  Nothing fancy at all.  I guess I can delete the current DB and create a new fresh one.  I will try that and let you know how it go's.





Thanks,





Brina

Peter,





I deleted the database and ran DBSC to create a new one.  After that, I ran into exactly the same error at exactly the same point in the install procedure.





Are there any install logs created I can take a look at?





Brian

Brian,





Did you use the Database Configuration Assistant? Did you use the defaults? How much memory do you have in your Oracle machine?








The logs are in the jchem/cartridge/jcart0.log file, but they are fairly scarce by default. You can make them more verbose by uncommenting the line

Code:

# chemaxon.jchem.level = FINEST

jchem/cartridge/conf/logging.properties. Not sure if we'll find in them even in verbose mode, but who knows...





When you now execute the

Code:

test.sh jchem/password

script, what output do you get?





Thanks





Peter

Peter,





I created the Database using the Database Creation assistant and used all the defaults for a default general use DB. 





I am running with 8GB RAM.





Here is the output of root>test.sh jchem/jchem@jchem





**********************************************************************





[root@sdprdjchem cartridge]# test.sh jchem/jchem@jchem





SQL*Plus: Release 10.1.0.3.0 - Production on Wed Mar 25 12:02:12 2009





Copyright (c) 1982, 2004, Oracle.  All rights reserved.





Enter user-name:


Connected to:


Oracle Database 10g Release 10.1.0.3.0 - 64bit Production





SQL> select jchem_core_pkg.getenvironment() from dual


       *


ERROR at line 1:


ORA-29540: class chemaxon/jchem/cartridge/JcMetaDataFunctions does not exist


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 10


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 71








Disconnected from Oracle Database 10g Release 10.1.0.3.0 - 64bit Production





**********************************************************************





Thanks,











Brian Jackson

When you call





$ORACLE_HOME/bin/loadjava -user jchem/password@jchem jcart.jar








in the jchem/cartridge directory, does it appear to complete normally?





If it does, please, could you

1. set your JAVA_POOL_SIZE and SHARED_POOL_SIZE to 150m each
2. restart your database
3. repeat the above loadjava command
4. repeat the test.sh script

Is it still the same error message?








Thanks





Peter

I was able to run the loadjava command without any errors, but, there was no output on the screen other than a new terminal line.





I then changed the two instance parameters to 150m each and restarted the DB, here is what I get. 





**************************************************************************





ORACLE instance started.





Total System Global Area 2483027968 bytes


Fixed Size                  1323296 bytes


Variable Size             583782112 bytes


Database Buffers         1895825408 bytes


Redo Buffers                2097152 bytes


Database mounted.


Database opened.


SQL> quit


Disconnected from Oracle Database 10g Release 10.1.0.3.0 - 64bit Production


[oracle@sdprdjchem cartridge]$ exit


exit


[root@sdprdjchem cartridge]# $ORACLE_HOME/bin/loadjava -user jchem/jchem@jchem


jcart.jar


[root@sdprdjchem cartridge]# test.sh jchem/password@jchem





SQL*Plus: Release 10.1.0.3.0 - Production on Wed Mar 25 12:18:13 2009





Copyright (c) 1982, 2004, Oracle.  All rights reserved.





Enter user-name:


Connected to:


Oracle Database 10g Release 10.1.0.3.0 - 64bit Production





SQL> select jchem_core_pkg.getenvironment() from dual


       *


ERROR at line 1:


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.NullPointerException


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 29


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 80








Disconnected from Oracle Database 10g Release 10.1.0.3.0 - 64bit Production





************************************************************************





Previously the error was line 10 and 71, so this is different.





Brian Jackson

Please, could you drop the JCHEM schema and repeat the installation? I guess the explicit POOL memory settings should do the magic. (Not sure why...)








Thanks





Peter

Peter,





Same error.  I changed the JAVA and SHARED pool sizes in the Oracle Enterprise manageer to 150, but now they both read 494494.





Is that the correct locatoin?  Or am I doing it wrong?





Brian

This particular problem has been solved off line. The cure is believed to have been to use SYS instead of SYSTEM as privileged user for the installation.








P.