ORA-00904 on cartridge install

Dear Support,


While executing for the first time the installation of JChem Cartridge (version 5.1.4) I patched Oracle 9.2.0.1 to 9.2.0.6.

Using JDK 1.5 I have the following error message

C:\Program Files\ChemAxon\JChem\cartridge>install-interact.bat

C:\Program Files\ChemAxon\JChem\cartridge>"C:\jdk1.5.0_08\bin\java.exe" -classpath "..\lib\jchem.jar;C:\oracle\ora92\jdbc\lib\ojdbc5.jar;C:\oracle\ora92\jdbc\lib\ojdbc14.jar" -Djava.util.logging.config.file=conf\logging.properties chemaxon.jchem.cartridge.install.InstallCmdLine --oracle-home "C:\oracle\ora92"

Name of the Oracle host. [localhost]:

Oracle listener port [1521]:

Name of the Oracle instance [mydb]:

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

Name of the cartridge owner: myname
Password of the cartridge owner:

Local TNS name of the Oracle instance. [mydb]:
java.sql.SQLException: ORA-00904: "JCHEM_CORE_PKG"."GET_CARTOWNER_SCHEMA" : identificateur non valide
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1957)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:850)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2555)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2896)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:647)
        at chemaxon.jchem.cartridge.dbsession.DbSessionBase.getCartOwnerSchema(DbSessionBase.java:58)
        at chemaxon.jchem.cartridge.dbsession.DbContext.getCartOwnerSchema(DbContext.java:76)
        at chemaxon.jchem.cartridge.rmi.client.RmiDirectory.getRmiServerDesc(RmiDirectory.java:120)
        at chemaxon.jchem.cartridge.install.InstallParameters.adjustRmiUrlFromDb(InstallParameters.java:70)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.getParamsInteractively(InstallCmdLine.java:226)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLine.java:59)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.main(InstallCmdLine.java:521)
C:\Program Files\ChemAxon\JChem\cartridge>


The user of the jchem cartridge has administrators right and can create, modify and execute PL/SQL or java classes.

Where could be the problem?

Thank your very much for your help
Warmest Regards

Jack

Dear Jack,

Please, follow the installation instructions provided with the JChem packages you're trying to use. The install-interact.bat file can be used starting with JChem version 5.2.0.

Regards,

Peter

Sorry,

I really apologize since I followed the instruction of the website instead of those that accompany the cartridge. I will install 5.1.4 and later, the latest version of JChem Cartridge.

Thank you for your answer.