Jchem Instalation issue - Oracle 11.2.0.1.0

User 352c4d4814

02-01-2013 11:38:13

Having just installed Oracle (which maybe where my problem lies) I am unable to install the JCHEM cartridge onto a Windows 2008R2.


The Oracle passwords are correct, as is the instance name. 


The command prompt feedback is as follows:


 


D:\chemaxon\jchem\cartridge>install.bat

Name of the Oracle host. [localhost]:

Oracle listener port [1521]:

Name of the Oracle instance [mydb]: ELNSID

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: D:\chemaxon\jchem\lib\jchem.jar
INFO: Server process start-ed.
INFO: Cache id set to JCC1
INFO: Listening at 1099

DBA login [SYSTEM]:
DBA password:
 INFO: Using classpath: D:\chemaxon\jchem\lib\jchem.jar
INFO: Connecting to localhost:1099
AdminImpl: shutdown called...
INFO: shutdown called
Exiting...
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(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        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(PlainSocketImpl.java:351)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:529)
        at java.net.Socket.connect(Socket.java:478)
        at java.net.Socket.<init>(Socket.java:375)
        at java.net.Socket.<init>(Socket.java:189)
        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
D:\chemaxon\jchem\cartridge>


 


Please help. 


 


Happy New Year!!

ChemAxon aa7c50abf8

02-01-2013 12:14:33

Happy New Year!


Is Microsoft Loopback Adapter installed?

User 352c4d4814

02-01-2013 14:27:09

HI,


I am sure I am correct at saying that there is no loopback adapter installed:


 



 


Do I need it?


 

ChemAxon aa7c50abf8

02-01-2013 16:14:46

No, you don't. I was asking to make sure you don't have it.


What JChem version is this?

User 352c4d4814

02-01-2013 16:32:12

OK - firstly, definitely no loopback adapter installed:



The file name of my JCHEM zip file is: jchem-5.4.0.1


Does this tell you what you need to know?

ChemAxon aa7c50abf8

03-01-2013 10:50:07

It does, thanks.


I think you are likely to have run into the timing related JChem Cartridge installer bug which goes by "Installer and upgrader command line user interface may have been garbled (due to excessive delay in JChem Server start-up)." in the history of changes (http://www.chemaxon.com/jchem/changes.html) and which was fixed in JChem version 5.10. If multiple attempts at installing fail with this same problem (it is worthwhile retrying multiple times), I suggest to use the latest JChem version (which includes many bugfixes and improvements anyway).