connecting to oracle via jchem

User 76612d09f2

04-05-2007 17:57:25

I get an error while trying to connect to oracle a new instance..





java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNU


M=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))


at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java :134)


at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)


at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)


at oracle.jdbc.driver.OracleConnection.<init>( OracleConnection.java:404)


at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja


va:468)


at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)


at java.sql.DriverManager.getConnection (DriverManager.java:582)


at java.sql.DriverManager.getConnection(DriverManager.java:185)


at chemaxon.util.ConnectionHandler.setConnected(ConnectionHandler.java:2


06)


at chemaxon.util.ConnectionHandler.connect (ConnectionHandler.java:246)


at chemaxon.jchem.gui.Connector.go(Connector.java:63)


at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:561)


at chemaxon.jchem.JChemManager.init(JChemManager.java :89)


at chemaxon.jchem.JChemManager.main(JChemManager.java:106)

ChemAxon 9c0afc9aaf

04-05-2007 18:59:59

Hi,





The program does not seem to be able to connect to Oracle.





Pleas make sure


- the connection URL is OK (host name, port, etc.)


- there is no firewall that blocks the port in question


- the host name can be resolved (you may also try the IP instead)


- the database is running and listening on that port





You may check if a telnet connection can be established:





telnet <host> <port>





e.g.:





telnet 127.0.0.1 1521





Best regards,





Szilard