User 952e1d9361
07-04-2009 15:59:58
Hello
I have just setup a brand new install of Oracle and JChem on a Linux server and am getting ORA-03113 errors when trying to use JChem to do anything.
The server is a 64bit AMD server with RHEL4, Oracle 10g, JDK 1.6.
The JChem 'test' works fine :
SQL>
JCHEM.JCHEM_CORE_PKG.GETENVIRONMENT()
--------------------------------------------------------------------------------
Oracle environment:
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_13
Java VM version: 11.3-b02
JCHEM.JCHEM_CORE_PKG.GETENVIRONMENT()
--------------------------------------------------------------------------------
JChem version: 5.2.0
JChem Index version: 5020005
JDBC driver version: 11.1.0.7.0-Production
but when I go to create an index I get the error :
SQL> create index struct_jchem_idx on structure_ids (structure)
2 indextype is jchem.jc_idxtype
3 parameters('tableType=anyStructures');
create index struct_jchem_idx on structure_ids (structure)
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
The JCHem server console doesn't seem to show anything useful :
$ ./server.sh start
+ /usr/java/default/bin/java -Djava.util.logging.config.class=chemaxon.jchem.cartridge.util.LoggingConfigurator -Dchemaxon.jchem.cartridge.config.file=conf/jcart.properties -Djava.awt.headless=true -classpath ./../lib/jchem.jar -XX:-OmitStackTraceInFastThrow chemaxon.jchem.cartridge.server.Bootstrapper start
INFO: Server control process started
INFO: Using classpath: /opt/ChemAxon/JChem/lib/jchem.jar:
INFO: Server process start-ed.
INFO: Listening on network interface 0.0.0.0/0.0.0.0 at port 1099...
INFO: Using chemaxon.jchem.cartridge.util.cpool.Oracle10gDataSource
INFO: JDBC driver version: 11.1.0.7.0-Production
INFO: Testing connection=oracle.jdbc.driver.LogicalConnection@30c06258
INFO: Testing connection=oracle.jdbc.driver.LogicalConnection@a4133b0
INFO: Testing connection=oracle.jdbc.driver.LogicalConnection@5fa13338
and I can't find anything in the Oracle 'dump' directories either.
Any suggestions anyone?
Thanks,
Steve H