connection refused installing cartridge

Hi.

I've installed Oracle 11G R2 64bit on a Windows 2008 R2 64 bit server.

I've installed jchem 5.4.0.1

The installtion of Marvin worked well, and I can connect to the database using sqlplus

but, when I try to install the cartridge , I get the following error.

Microsoft Windows [Version 6.1.7600]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>cd C:\Program
Files\ChemAxon\JChem\cartridge

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

Name of the Oracle host. [localhost]:

Oracle listener port [1521]:

Name of the Oracle instance [mydb]: ct15

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]:

The structure cache id of this JChem Server instance
[JCC1]:

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

====> Trying to start JChem Server...

INFO: Using classpath: C:\Program
Files\ChemAxon\JChem\lib\jchem.jar

INFO: Server process start-ed.

INFO: Cache id set to JCC1

INFO: Directory licenses does not exist. Leaving it to
LicenseHandler to check t he default location for licenses.

INFO: Listening at 1099

DBA login [SYSTEM]:

DBA password:

 INFO: Using
classpath: C:\Program Files\ChemAxon\JChem\lib\jchem.jar

INFO: Connecting to localhost:1099

AdminImpl: shutdown called...

INFO: shutdown called

Exiting...

INFO:

Shutting down...

INFO: Server process stop-ed.

java.sql.SQLException: The Network Adapter could not
establish the connection

        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

:197)

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

:525)

        at
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)

        at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:

508)

        at
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)

        at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio

n.java:33)

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

        at
java.sql.DriverManager.getConnection(Unknown Source)

        at java.sql.DriverManager.getConnection(Unknown
Source)

        at
chemaxon.jchem.cartridge.install.ConnectUtil.getConnection(ConnectUti

l.java:82)

        at
chemaxon.jchem.cartridge.install.schema.Schema.connect(Schema.java:86

)

        at
chemaxon.jchem.cartridge.install.params.InstallParameters.checkLogin(

InstallParameters.java:229)

        at
chemaxon.jchem.cartridge.install.params.InstallParameters.checkDbaLog

in(InstallParameters.java:216)

        at
chemaxon.jchem.cartridge.install.InstallCmdLine.getCheckDbaLoginInter

actively(InstallCmdLine.java:269)

        at
chemaxon.jchem.cartridge.install.InstallCmdLine.getParamsInteractivel

y(InstallCmdLine.java:173)

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

e.java:89)

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

ava:707)

Caused by: oracle.net.ns.NetException: The Network
Adapter could not establish t he connection

        at
oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)

        at
oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.j

ava:421)

        at
oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)

        at
oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)

        at
oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)

        at
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)

        ... 14 more

Caused by: java.net.ConnectException: Connection refused:
connect

        at
java.net.PlainSocketImpl.socketConnect(Native Method)

        at
java.net.PlainSocketImpl.doConnect(Unknown Source)

        at
java.net.PlainSocketImpl.connectToAddress(Unknown Source)

        at
java.net.PlainSocketImpl.connect(Unknown Source)

        at
java.net.SocksSocketImpl.connect(Unknown Source)

        at
java.net.Socket.connect(Unknown Source)

        at
java.net.Socket.connect(Unknown Source)

        at
java.net.Socket.<init>(Unknown Source)

        at
java.net.Socket.<init>(Unknown Source)

        at
oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127)

        at
oracle.net.nt.ConnOption.connect(ConnOption.java:126)

        at
oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)

        ... 19 more

C:\Program Files\ChemAxon\JChem\cartridge>

What have I missed ?

Regards,

Micke

Hi Micke,

The error messages indicate that either no process is listening on port 1521 or the system blocks connections to this port. (The latter cause is very unlikely in a single-host scenario.)

What is the output of the following Windows command:

netstat -a | find "1521"

?

Thanks

Peter

JIRA: JC-2749

Hi Peter.

I know the listener is working cause I can connect using sqlplus scott@ct15/tiger.

But anyways, the output shows

TCP 127.0.0.1:1521 WIN-DNC10BELH2L:0 LISTENING

TCP 127.0.0.1:1521 WIN-DNC10BELH2L:49195 ESTABLISHED

TCP 127.0.0.1:1521 WIN-DNC10BELH2L:49277 ESTABLISHED

TCP 127.0.0.1:49195 WIN-DNC10BELH2L:1521 ESTABLISHED

TCP 127.0.0.1:49277 WIN-DNC10BELH2L:1521 ESTABLISHED

Regards,

Micke

Micke,

Can you connect with a command like this:

sqlplus scott/tiger@//localhost:1521/ct15

?

Thanks

Peter

Hi Peter.

Yes, that works.

Regards,

Micke

Hi Micke,

Please, could you upload or send me by mail the jcart0.log file found in the directory the installation was started in. I am mainly interested in the log entries for ConnectUtil. In my environment they look like this:

[main/10]: Feb 27, 2011 9:42:00 PM chemaxon.jchem.cartridge.install.ConnectUtil getConnection

FINER: Loading driver class oracle.jdbc.OracleDriver

[main/10]: Feb 27, 2011 9:42:00 PM chemaxon.jchem.cartridge.install.ConnectUtil getConnection

FINER: Connecting with url: jdbc:oracle:thin:@localhost:1521:mydb as SYSTEM

Thanks

Peter

Hi Peter.

Here is what's in the jcart0.log

"[main/10]: Feb 25, 2011 5:15:51 AM chemaxon.jchem.cartridge.rmi.impl.AdminImpl setStructureCacheId
INFO: Cache id set to JCC1
[main/10]: Feb 25, 2011 5:15:52 AM chemaxon.jchem.cartridge.rmi.impl.AdminImpl loadLicenses
INFO: Directory licenses does not exist. Leaving it to LicenseHandler to check the default location for licenses.
[main/10]: Feb 25, 2011 5:15:52 AM chemaxon.jchem.cartridge.rmi.impl.AdminImpl startServer
INFO: Listening at 1099
[RMI TCP Connection(1)-10.10.10.10/11]: Feb 25, 2011 5:16:12 AM chemaxon.jchem.cartridge.rmi.impl.AdminImpl shutdown
INFO: shutdown called
[Thread-1/12]: Feb 25, 2011 5:16:12 AM chemaxon.jchem.cartridge.rmi.impl.AdminImpl$1 run
INFO:
Shutting down...
"

and this is from jcart1.log

"[main/10]: Feb 25, 2011 5:16:12 AM chemaxon.jchem.cartridge.rmi.impl.AdminImpl main
INFO: Connecting to localhost:1099
"

Regards,

Micke

Hi Micke,

I think this is from the jchem/cartridge/logs directories. I meant the log file in the jchem/cartridge directory, where you started the installation program.

Thanks

Peter

Hi Peter, yes sorry.

Here is the log from the installation directory.

"[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: # property name | description | prompt | accepted input | default value | is value to be saved...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: save.params | Should the upgrade parameters entered be stored? | Should the upgrade parameters entered be stored? |y,n|y|n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: proceed.with.upgrade | Do you want to proceed with the upgrade? |Do you want to proceed with the upgrade? | y,n|n|n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: create.baserole | The basic role for basic JChem Cartridge user privileges doesn't exist. Do you want to create it now? | The basic role for basic JChem Cartridge user privileges doesn't exist. Do you want to create it now? | y,n|n|n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: # property name | description | prompt | accepted input | default value | is value to be saved   ...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: path.to.old.jchem | The path to home directory of the old JChem version | The path to the home directory of the old JChem version | | | n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: old.jcc.dir | The JChem Cartridge subdirectory in the installation package of the old JChem version | The JChem Cartridge subdirectory in the installation package of the old JChem version | | | n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: path.to.old.jcc | The path to the home of the old JChem Cartridge version | The path to the home of the old JChem Cartridge version | | | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: oracle.home | The directory where Oracle's "bin" directory can be found containing the Oracle executables | Oracle's home | |  /opt/oracle/product/10.2.0/db_1 | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: oracle.server.host | The name of the Oracle host. | Name of the Oracle host. | | localhost | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: oracle.server.port | The port where the Oracle listener accepts connections | Oracle listener port | | 1521 | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: oracle.server.instance | Name of the Oracle instance | Name of the Oracle instance | |mydb|y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: tns.name | The local TNS name of the Oracle instance. | Local TNS name of the Oracle instance. | | XXXX | y  ...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jcart.owner.login | The name of schema where JChem Cartridge has been installed | Name of the cartridge owner | | | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jcart.owner.password | The password of the Oracle user in whose schema JChem Cartridge has been installed |Password of the cartridge owner | | | n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: staging.schema | The name of an empty schema where the types and procedures required by the new JChem Cartridge version will be temporarily stored. This schema must have CONNECT and RESOURCE privileges and must be empty. If DBA credentials will be specified later, this schema will be automatically created, otherwise the staging schema must already be available with CONNECT and RESOURCE roles granted to it|Staging schema for the version| |JCC_UPGR_STAGE|y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: staging.password | The password for the staging schema | The password for the staging schema | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: dba.login| DBA login is required to create the staging schema, public synonyms and rebuilding all jc_idxtype indexes in one sweep. If you don't wish to specify a DBA login, please enter '!'. If a DBA login is not specified, (a) the staging schema must be already available when starting this program, (b) creation of public synonyms will be skipped and (b) jc_idxtype indexes will not be automatically rebuilt. | DBA login | | SYSTEM |y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: dba.password | The password of the DBA with create schema privileges. If the DBA password is not specified, the dba login is considered not having been specified either. | DBA password | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jchem.server.host | The host name of the JChem Server, as seen (pingable) from the Oracle host. In a single-host setup, it is "localhost" or 127.0.0.1. | The host name of the JChem Server | | localhost |y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jchem.server.port | The port at which the JChem Server accepts connections | The port at which the JChem Server accepts connections | | 1099 |y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: rebuild.indexes| Specifies whether and how jc_idxtype indexes should be rebuilt. If 'none' is specified, no jc_idxtype indexes will be rebuilt. If 'ask' is specified, you will be prompted for confirmation to go ahead or skip before each index. If 'all' is specified, all jc_idxtype indexes will be rebuilt in one sweep"| Rebuild jc_idxtype indexes | none, ask, all | none | n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: skip.rebuild.autocalcct | Specifies whether regeneration of data in auto calculated columns should be skipped or not | Skip recalculation of Chemical Terms columns | | | n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: basic.jcc.role | The role for basic JChem Cartridge user privileges | The role for basic JChem Cartridge user privileges | | JCC_BASIC_ROLE | y|...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: oracle.server.login | Oracle "super user" login used by JChem Server to connect back to Oracle | Oracle "super user" login used by JChem Server to connect back to Oracle | | |n  ...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: oracle.server.password | Password for the Oracle "super user" used by JChem Server to connect back to Oracle | Password for the Oracle "super user" login used by JChem Server to connect back to Oracle | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: license.dir | The directory containing the license files | The directory containing the license files  | | | y  ...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: logging.config.file | Configuration file for logging | Configuration file for logging | | conf/logging.properties | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: logging.output.dir | Directory to store the log files | Directory to store the log files | | logs | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jcserver.maxmem | The maximum memory allocated to JChem Server. See http://www.chemaxon.com/jchem/doc/admin/cartridge.html#server_memory for details on how to calculate the required amount. | maximum memory allocated to JChem Server | | 700m |y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: structure.cache.id | The structure cache id of the JChem Server instance currently being configured. The structure cache id must uniquely identify JChem structure caches across all JChem based application accessing the same structure tables. | The structure cache id of this JChem Server instance | | JCC1 | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: old.structure.cache.id | n/a | n/a | | | n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jdbc.driver.path | The path to the JDBC driver to be used by JChem Server. By default, the JDBC driver will be used which came with the Oracle installation pointed to by the ORACLE_HOME environment variable. | The path to the JDBC driver to be used by JChem Server | | | y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: reservedMemory | The size of memory (in megabytes) which should not be used by the JChem Structure Cache | The size of memory (in megabytes) which should not be used by the JChem Structure Cache | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: indexingThreadsPerCall | One index operation will be executed in this many concurrent threads. The default is the number of processing CPU cores. | Number of threads per index operations | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jcSearchThreadsPerCall | One search operation will be executed in this many concurrent threads. The default is the number of processing CPU cores. | Number of threads per search requests | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: jcReactThreadsPerCall | One jc_react operation will be executed in this many concurrent threads. The default is the number of processing CPU cores. | Number of threads per jc_react requests | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: connection.cached.pool.impl | Connection pool implementation to use. See http://www.chemaxon.com/forum/viewpost17530.html#17530 | Connection pool implementation to use | | |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: service.name | Name of the JChem Server service. | Name of the JChem Server service | | JChemCartridgeService |y...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: service.display.name | Display name of the JChem Server service. | Display name of the JChem Server service | | JChem Cartridge Service |n...
[main/10]: Feb 25, 2011 5:15:33 AM chemaxon.jchem.cartridge.install.params.ParamProperties createParapProperties
FINEST: Processing line: upgrade.plan.only | Do only as much as is required to produce the upgrade plan (the sequence of SQL statements for upgrading the database schema object) | Create only the upgrade plan | | n | n...
[Thread-3/11]: Feb 25, 2011 5:15:41 AM chemaxon.jchem.cartridge.install.InstallUtil$1 run
FINE: sleep interrupted
java.lang.InterruptedException: sleep interrupted
    at java.lang.Thread.sleep(Native Method)
    at chemaxon.jchem.cartridge.install.InstallUtil$1.run(InstallUtil.java:324)

[main/10]: Feb 25, 2011 5:15:44 AM chemaxon.jchem.cartridge.install.InstallUtil checkJChemServer
INFO: Checking JChem Server at localhost:1099...
[main/10]: Feb 25, 2011 5:15:45 AM chemaxon.jchem.cartridge.install.InstallUtil checkJChemServer
FINE: Exception while locating Directory
java.rmi.ConnectException: Connection refused to host: localhost; nested exception is:
    java.net.ConnectException: Connection refused: connect
    at sun.rmi.transport.tcp.TCPEndpoint.newSocket(Unknown Source)
    at sun.rmi.transport.tcp.TCPChannel.createConnection(Unknown Source)
    at sun.rmi.transport.tcp.TCPChannel.newConnection(Unknown Source)
    at sun.rmi.server.UnicastRef.newCall(Unknown Source)
    at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)
    at chemaxon.jchem.cartridge.rmi.client.RmiDirectory.locateBypassCache(RmiDirectory.java:141)
    at chemaxon.jchem.cartridge.rmi.client.RmiDirectory.locateBypassCache(RmiDirectory.java:128)
    at chemaxon.jchem.cartridge.install.InstallUtil.checkJChemServer(InstallUtil.java:137)
    at chemaxon.jchem.cartridge.install.InstallCmdLine.checkStartNewJChemServer(InstallCmdLine.java:429)
    at chemaxon.jchem.cartridge.install.InstallCmdLine.checkStartNewJChemServer(InstallCmdLine.java:416)
    at chemaxon.jchem.cartridge.install.InstallCmdLine.getParamsInteractively(InstallCmdLine.java:171)
    at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLine.java:89)
    at chemaxon.jchem.cartridge.install.InstallCmdLine.main(InstallCmdLine.java:707)
Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(Unknown Source)
    at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(Unknown Source)
    at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(Unknown Source)
    ... 13 more
[Thread-5/12]: Feb 25, 2011 5:15:46 AM chemaxon.jchem.cartridge.install.InstallUtil$1 run
FINE: sleep interrupted
java.lang.InterruptedException: sleep interrupted
    at java.lang.Thread.sleep(Native Method)
    at chemaxon.jchem.cartridge.install.InstallUtil$1.run(InstallUtil.java:324)

[main/10]: Feb 25, 2011 5:15:51 AM chemaxon.jchem.cartridge.install.ServerCtrl isRunning
FINER: returning false
[Thread-7/13]: Feb 25, 2011 5:15:51 AM chemaxon.jchem.cartridge.install.InstallUtil$1 run
FINE: sleep interrupted
java.lang.InterruptedException: sleep interrupted
    at java.lang.Thread.sleep(Native Method)
    at chemaxon.jchem.cartridge.install.InstallUtil$1.run(InstallUtil.java:324)

[Thread-9/14]: Feb 25, 2011 5:15:51 AM chemaxon.jchem.cartridge.install.InstallUtil$1 run
FINE: sleep interrupted
java.lang.InterruptedException: sleep interrupted
    at java.lang.Thread.sleep(Native Method)
    at chemaxon.jchem.cartridge.install.InstallUtil$1.run(InstallUtil.java:324)

[main/10]: Feb 25, 2011 5:15:51 AM chemaxon.jchem.cartridge.server.Bootstrapper createClasspath
INFO: Using classpath: C:\Program Files\ChemAxon\JChem\lib\jchem.jar
[main/10]: Feb 25, 2011 5:15:51 AM chemaxon.jchem.cartridge.server.Bootstrapper serverControl
INFO: Server process start-ed.
[main/10]: Feb 25, 2011 5:15:56 AM chemaxon.jchem.cartridge.install.ServerCtrl isRunning
FINER: returning true
[main/10]: Feb 25, 2011 5:16:06 AM chemaxon.jchem.cartridge.install.ConnectUtil getConnection
FINER: Loading driver class oracle.jdbc.OracleDriver
[main/10]: Feb 25, 2011 5:16:06 AM chemaxon.jchem.cartridge.install.ConnectUtil getConnection
FINER: Connecting with url: jdbc:oracle:thin:@localhost:1521:ct15 as SYSTEM
[main/10]: Feb 25, 2011 5:16:07 AM chemaxon.jchem.cartridge.install.params.InstallParameters checkLogin
FINEST: error code: 20
[Thread-16/15]: Feb 25, 2011 5:16:07 AM chemaxon.jchem.cartridge.install.InstallUtil$1 run
FINE: sleep interrupted
java.lang.InterruptedException: sleep interrupted
    at java.lang.Thread.sleep(Native Method)
    at chemaxon.jchem.cartridge.install.InstallUtil$1.run(InstallUtil.java:324)

[main/10]: Feb 25, 2011 5:16:12 AM chemaxon.jchem.cartridge.install.ServerCtrl isRunning
FINER: returning true
[main/10]: Feb 25, 2011 5:16:12 AM chemaxon.jchem.cartridge.server.Bootstrapper createClasspath
INFO: Using classpath: C:\Program Files\ChemAxon\JChem\lib\jchem.jar
[main/10]: Feb 25, 2011 5:16:12 AM chemaxon.jchem.cartridge.server.Bootstrapper serverControl
INFO: Server process stop-ed.
"

Thank you, Micke!

Here is my last request to you before I have our sysadmin set up a Windows 2008 R2 64 bit server for this problem: (I have been testing this on Windows 7 64-bit which I believe is reasonably close to 2008 server, but may not be close enough...)

Please, could you execute the following command in the jchem/bin directory:

.\jcman.bat t -l scott -p tiger --driver oracle.jdbc.OracleDriver --dburl jdbc:oracle:thin:@localhost:1521:ct15

It will create a jchemproperties table in the scott schema, if none exists yet, or, if one already exists, list the JCB tables found in the schema. The purpose really is just to see if another Java program can successfully connect with the JDBC parameters which the JCC installer is trying to use.

Thanks

Peter

Hi Peter.

Here is the result.

"C:\Program Files\ChemAxon\JChem\bin>jcman.bat t -l eln -p eln123 --driver oracle
.jdbc.OracleDriver --dburl jdbc:oracle:thin:@localhost:1521:ct15
Cannot connect:
java.sql.SQLException: The Network Adapter could not establish the connection
        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
:197)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:525)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
508)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:33)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at chemaxon.util.ConnectionHandler.connectToDatabase(ConnectionHandler.j
ava:322)
        at chemaxon.util.ConnectionHandler.connect(ConnectionHandler.java:312)
        at chemaxon.jchem.Command.run(Command.java:633)
        at chemaxon.jchem.Command.main(Command.java:226)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish t
he connection
        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
        at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.j
ava:421)
        at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
        ... 10 more
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127)
        at oracle.net.nt.ConnOption.connect(ConnOption.java:126)
        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)
        ... 15 more
C:\Program Files\ChemAxon\JChem\bin>"

Regards,

Micke

Thank you, Micke!

Just to double check: did you execute this command on the Oracle host?

Thanks

Peter

Hi Peter.

Yes.

Regards,

Micke

Micke,

I am going to test this with Windows 2008 Server.

In the meantime, would it be possible to check, if JDBC connection to your Oracle instance works with one of Oracle's own JDBC client programs?

The simplest would be (in many respects) to try to connect with Oracle SQL Developer from the Oracle server itself, if you are familiar with this tool and it is easy to install it on the Oracle server.

Alternatively, one of the Oracle demo clients could also be used for this purpose. I will describe how to proceed with the demo clients in the following.

You can download the JDBC demo package from here, but I am also attaching one of the demo proglets for your convenience. You can compile the program like this: 

...>"%JAVA_HOME%\bin\javac" -classpath <oracle-home>\jdbc\lib\ojdbc5.jar .\DBChangeNotification.java

C:\Users\pkovacs\Downloads\jdbcsamples>"%JAVA_HOME%\bin\javac" -classpath C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc5.jar .\DBChangeNotification.java

C:\Users\pkovacs\Downloads\jdbcsamples>"%JAVA_HOME%\bin\javac" -classpath C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc5.jar .\DBChangeNotification.java

C:\Users\pkovacs\Downloads\jdbcsamples>echo %ERRORLEVEL%
0

...>"%JAVA_HOME%\bin\java" -classpath .;<oracle-home>\jdbc\lib\ojdbc5.jar DBChangeNotification jdbc:oracle:thin:@localhost:1521:ct15

which would be in my environment:

C:\Users\pkovacs\Downloads\jdbcsamples>"%JAVA_HOME%\bin\java" -classpath .;C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc5.jar DBChangeNotification jdbc:oracle:thin:@localhost:1521:ct15

The program gives me this error message:

java.sql.SQLException: ORA-29972: user does not have privilege to change/ create registration



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

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

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

        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4CTTIokpn.doOKPN(T4CTTIokpn.java:277)

        at oracle.jdbc.driver.T4CConnection.doRegisterDatabaseChangeNotification(T4CConnection.java:4275)

        at oracle.jdbc.driver.PhysicalConnection.registerDatabaseChangeNotification(PhysicalConnection.java:10003)

        at DBChangeNotification.run(DBChangeNotification.java:116)

        at DBChangeNotification.main(DBChangeNotification.java:86)

, but this proves that the JDBC client can connect to the Oracle instance.

Thanks

Peter

Hi Peter.

Thanks for the tip.

I tried to connect with SQL developer, and that didn't work either.

After some digging it turned out that java did not like the Microsoft loopback adapter.

After uninstalling that, everything worked as it should.

Regards,

Micke