JDBC connection problem on fresh install

Hi - I have just installed 5.1.01 on 64 bit Linux (Centos 4.7) and Oracle 10g 10.2.0.4 64 bit with latest recommended patches and Java 1.6.0_11. I have installed the application as a UNIX user called jchem who is part of the oracle dba group. I have used the install procedure as detailed in http://www.chemaxon.com/jchem/doc/admin/cartridge.html#req and when running the server.sh script and the install.sh script, I get no errors. I connect to the database as user jchem and running sqlplus and then run the test call jchem_core_pkg.use_password('passwd');





I get the following error:-





ERROR at line 1:


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


java.rmi.ServerException: RemoteException occurred in server thread; nested


exception is:


java.rmi.RemoteException: Problem connecting to the followingJDBC URL:


jdbc:oracle:thin:@localhost:1521:ccd3tra: Io exception: The Network Adapter


could not establish the connection. Please, check the JDBC connection


properties of the JChem Server.





using telnet to connect on port 1099 I get





Trying 127.0.0.1...


Connected to localhost.localdomain (127.0.0.1).


Escape character is '^]'.


  sr4chemaxon.jchem.cartridge.rmi.impl.DirectoryImpl_Stub  xr java.rmi.server.RemoteStub   e xrj ava.rmi.server.RemoteObject


                                                   a3xpw2


UnicastRef      localhost xConnection closed by foreign host.





The environment variables for jchem are





_=/bin/env


CLASSPATH=/apps/oracle/product/10.2.0/jdbc/lib/ojdbc14.jar


G_BROKEN_FILENAMES=1


HISTSIZE=1000


HOME=/apps/Chemaxon/JChem/5.1.01


HOSTNAME=uk-abi-sdb11


INPUTRC=/etc/inputrc


JAVA_HEAP_SIZE=1024m


JAVA_HOME=/usr/java/jdk1.6.0_11


KDEDIR=/usr


LANG=en_GB.UTF-8


LD_LIBRARY_PATH=/usr/java/jdk1.6.0_11/lib


LESSOPEN=|/usr/bin/lesspipe.sh %s


LOGNAME=jchem


LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:


MAIL=/var/spool/mail/jchem


ORACLE_BASE=/apps/oracle


ORACLE_HOME=/apps/oracle/product/10.2.0


ORACLE_SID=ccd3tra


PATH=/usr/java/jdk1.6.0_11/bin:/apps/oracle/product/10.2.0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin


PS1=uk-abi-sdb11 jchem $


PS2=uk-abi-sdb11 jchem >


PWD=/apps/Chemaxon/JChem/5.1.01/cartridge


QTDIR=/usr/lib64/qt-3.3


SHELL=/bin/bash


SHLVL=3


SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass


TERM=xterm


USER=jchem





Any ideas?

Hi,


What happens when telneting to localhost:1521?

Code:

telnet localhost 1521

Thanks for the reply. To begin with, I could only get a sensible response doing that when logged in as oracle, but got connection refused for user jchem. That problem inexplicably, seems to have gone away, but coincides with me getting the Oracle Enterprise Manager (emctl) working.





I looked through the notes again and checked this section





"Make sure that your Oracle database is JVM-enabled and properly configured for use of Java Stored Procedures. To do so, follow the instructions in the sections Initializing a Java-Enabled Database and Configuring Oracle JVM in the chapter Java Installation and Configuration of Oracle's Java Developer's Guide."





I had a look through the guide just in case I had missed something, because I thought I already had a JVM enabled database but found that the JAVA_POOL_SIZE and SHARED_POL_SIZE in the were both set at zero. I've fixed that and the basic tests work now.





So now for the next stage......





Cheers