Error during Cartridge installation, mydb10r2 [linux]

Hello there.

We are experiencing an issue with installing Jchem Cartridge into Oracle 10.2.0.4 on Linux (centos5). We have experienced the same problem with both the latest version of Jchem Cart, 5.6.0.2 and 5.5.1 which we have used in the past on Windows servers.

Running the install shell script, we are asked for all the required details, such as host, SID, user/pass however it does not seem to be using the SID we provide and instead is using "mydb10r2"

INFO:
Setting up schema jchem

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

INFO:
Loading jar file /home/jchem/ChemAxon/JChem/cartridge/jcart.jar into jchem's
schema...

INFO:
Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/jchem_cart.sql_i
into jchem's schema...

INFO:
Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/jchem_util.sql into
jchem's schema...

INFO:
Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/jchem_opti.sql into
jchem's schema...

INFO:
Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/idx_analyse.sql into
jchem's schema...

INFO:
Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/privman.sql into
jchem's schema...

INFO:
Testing with user jchem...

SEVERE:
Problem connecting to the followingJDBC URL:
jdbc:oracle:thin:@localhost:1521:mydb10r2: Listener refused the connection with
the following error:

ORA-12505,
TNS:listener does not currently know of SID given in connect descriptor

 .
Please, check the JDBC connection properties of the JChem Server.

java.sql.SQLException:
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:mydb10r2: Listener refused the connection with
the following error:

ORA-12505,
TNS:listener does not currently know of SID given in connect descriptor

 .
Please, check the JDBC connection properties of the JChem Server.

ORA-06512:
at "JCHEM.JCHEM_CORE_PKG", line 58

ORA-06512:
at "JCHEM.JCHEM_CORE_PKG", line 55

As you can see, it errors out when attempting to connect to the database but cannot find the SID (which is not the one we provided it)

Any information on this would be much appriciated.
Thank you

Hello,

Interesting...mydb10r2 is a name I regularly use for Oracle test instances. I therefore created a new instance (called ZAZIE, a name which I believe I had never used before for Oracle instances) specifically for testing this problem. I could not reproduce it. (I am attaching the output captured during installation for reference.)

Please, could you post (or send me to pkovacs at chemaxon dot com) the full output of the installer as well as the jcart0.log file that was generated in the jchem/cartridge directory during installation?

Thanks

Peter

terminal output

[jchem@LUK-VMCS-LINUX1 cartridge]$ ./install-interact.sh
+ /usr/java/default/bin/java -classpath ../lib/jchem.jar:/u01/app/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc5.jar:/u01/app/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14.jar -Djava.util.logging.config.file=conf/logging.properties chemaxon.jchem.cartridge.install.InstallCmdLine --oracle-home /u01/app/oracle/product/10.2.0/db_1

Name of the Oracle host. [localhost]:

Oracle listener port [1521]:

Name of the Oracle instance [mydb]: viticdb

The host name of the JChem Server [localhost]:

The port at which the JChem Server accepts connections [1099]:

maximum memory allocated to the JChem Server process [700m]:

The structure cache id of this JChem Server instance [JCC1]:
INFO: Checking JChem Server at localhost:1099...

DBA login [SYSTEM]:
DBA password:            

Name of the cartridge owner [jchem]:
Password of the cartridge owner:      

====> Schema jchem doesn't exists. It will be created

Local TNS name of the Oracle instance. [viticdb]: viticdb

Do you want to use a role for basic JChem Cartridge user privileges? (This role will be granted to jchem WITH ADMIN OPTION. DataVault users, please, answer with with "n") (y, n) [n]: y

The role for basic JChem Cartridge user privileges [JCC_BASIC_ROLE]:

====> Role JCC_BASIC_ROLE doesn't exist, it will be created


You have entered the following parameters:
==========================================

Name of the Oracle host.: locahost
Oracle listener port: 1521
Name of the Oracle instance: viticdb
The host name of the JChem Server: localhost
The port at which the JChem Server accepts connections: 1099
maximum memory allocated to the JChem Server process: 700m
The structure cache id of this JChem Server instance: JCC1
DBA login: SYSTEM
Name of the cartridge owner: jchem
Local TNS name of the Oracle instance.: viticdb
Do you want to use a role for basic JChem Cartridge user privileges? (This role will be granted to jchem WITH ADMIN OPTION. DataVault users, please, answer with with "n"): y
The role for basic JChem Cartridge user privileges: JCC_BASIC_ROLE

Proceed with the Install? (y, n) [n]: y
INFO: Setting up schema jchem
INFO: Checking JChem Server at localhost:1099...
INFO: Loading jar file /home/jchem/ChemAxon/JChem/cartridge/jcart.jar into jchem's schema...
INFO: Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/jchem_cart.sql_i into jchem's schema...
INFO: Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/jchem_util.sql into jchem's schema...
INFO: Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/jchem_opti.sql into jchem's schema...
INFO: Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/idx_analyse.sql into jchem's schema...
INFO: Loading PL/SQL script /home/jchem/ChemAxon/JChem/cartridge/privman.sql into jchem's schema...
INFO: Testing with user jchem...
SEVERE: Problem connecting to the followingJDBC URL: jdbc:oracle:thin:@localhost:1521:mydb10r2: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 . Please, check the JDBC connection properties of the JChem Server.
java.sql.SQLException: 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:mydb10r2: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 . Please, check the JDBC connection properties of the JChem Server.
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 61
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 55

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
        at chemaxon.jchem.cartridge.install.schema.Schema.executeSql(Schema.java:450)
        at chemaxon.jchem.cartridge.install.Installer.test(Installer.java:254)
        at chemaxon.jchem.cartridge.install.Installer.install(Installer.java:94)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLine.java:167)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLine.java:86)
        at chemaxon.jchem.cartridge.install.InstallCmdLine.main(InstallCmdLine.java:588)
+ set +x
[jchem@LUK-VMCS-LINUX1 cartridge]$

jcart0.log

[main/10]: 2011-10-07 07:11:27.734 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: # property name | description | prompt | accepted input | default value | is value to be saved...
[main/10]: 2011-10-07 07:11:27.962 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.962 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=oracle.home, promptMessage=Oracle's home, description=The directory where Oracle's "bin" directory can be found containing the Oracle executables, allowedValues=null, defaultValue=/opt/oracle/product/10.2.0/db_1, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.962 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: oracle.server.host | The name of the Oracle host. | Name of the Oracle host. | | localhost | y...
[main/10]: 2011-10-07 07:11:27.962 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=oracle.server.host, promptMessage=Name of the Oracle host., description=The name of the Oracle host., allowedValues=null, defaultValue=localhost, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.962 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: oracle.server.port | The port where the Oracle listener accepts connections | Oracle listener port | | 1521 | y...
[main/10]: 2011-10-07 07:11:27.963 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=oracle.server.port, promptMessage=Oracle listener port, description=The port where the Oracle listener accepts connections, allowedValues=null, defaultValue=1521, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.963 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: oracle.server.instance | Name of the Oracle instance | Name of the Oracle instance | |mydb|y...
[main/10]: 2011-10-07 07:11:27.965 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=oracle.server.instance, promptMessage=Name of the Oracle instance, description=Name of the Oracle instance, allowedValues=null, defaultValue=mydb, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.965 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: tns.name | The local TNS name of the Oracle instance. | Local TNS name of the Oracle instance. | | XXXX | y  ...
[main/10]: 2011-10-07 07:11:27.966 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=tns.name, promptMessage=Local TNS name of the Oracle instance., description=The local TNS name of the Oracle instance., allowedValues=null, defaultValue=XXXX, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.966 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: jcart.owner.login | The name of schema where JChem Cartridge has to be installed | Name of the cartridge owner | | jchem | y...
[main/10]: 2011-10-07 07:11:27.966 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jcart.owner.login, promptMessage=Name of the cartridge owner, description=The name of schema where JChem Cartridge has to be installed, allowedValues=null, defaultValue=jchem, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.966 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.966 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jcart.owner.password, promptMessage=Password of the cartridge owner, description=The password of the Oracle user in whose schema JChem Cartridge has been installed, allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.966 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: dba.login| DBA login is required to create the JChem Cartridge owner's schema, granting the JChem Cartridge owner the required system privileges, creating public synonyms and optionally creating a basic role for JChem Cartridge users. If you don't wish to specify a DBA login, please enter '!'. The SQL statements to be executed with elevated privileges can be listed by executing the 'config-util.{sh,bat} list-dba-sqls' command in the jchem/cartridge directory. | DBA login | | SYSTEM |y...
[main/10]: 2011-10-07 07:11:27.966 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=dba.login, promptMessage=DBA login, description=DBA login is required to create the JChem Cartridge owner's schema, granting the JChem Cartridge owner the required system privileges, creating public synonyms and optionally creating a basic role for JChem Cartridge users. If you don't wish to specify a DBA login, please enter '!'. The SQL statements to be executed with elevated privileges can be listed by executing the 'config-util.{sh,bat} list-dba-sqls' command in the jchem/cartridge directory., allowedValues=null, defaultValue=SYSTEM, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.967 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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 unspecified as well. | DBA password | | |n...
[main/10]: 2011-10-07 07:11:27.967 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=dba.password, promptMessage=DBA password, description=The password of the DBA with create schema privileges. If the DBA password is not specified, the dba login is considered unspecified as well., allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.967 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.967 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jchem.server.host, promptMessage=The host name of the JChem Server, description=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., allowedValues=null, defaultValue=localhost, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.967 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.967 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jchem.server.port, promptMessage=The port at which the JChem Server accepts connections, description=The port at which the JChem Server accepts connections, allowedValues=null, defaultValue=1099, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.967 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.968 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=basic.jcc.role, promptMessage=The role for basic JChem Cartridge user privileges, description=The role for basic JChem Cartridge user privileges, allowedValues=null, defaultValue=JCC_BASIC_ROLE, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.968 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.968 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=oracle.server.login, promptMessage=Oracle "super user" login used by JChem Server to connect back to Oracle, description=Oracle "super user" login used by JChem Server to connect back to Oracle, allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.968 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.968 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=oracle.server.password, promptMessage=Password for the Oracle "super user" login used by JChem Server to connect back to Oracle, description=Password for the Oracle "super user" used by JChem Server to connect back to Oracle, allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.968 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: license.dir | The directory containing the license files | The directory containing the license files  | | | y  ...
[main/10]: 2011-10-07 07:11:27.968 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=license.dir, promptMessage=The directory containing the license files, description=The directory containing the license files, allowedValues=null, defaultValue=, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.969 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: logging.config.file | Configuration file for logging | Configuration file for logging | | conf/logging.properties | y...
[main/10]: 2011-10-07 07:11:27.969 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=logging.config.file, promptMessage=Configuration file for logging, description=Configuration file for logging, allowedValues=null, defaultValue=conf/logging.properties, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.969 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: logging.output.dir | Directory to store the log files | Directory to store the log files | | logs | y...
[main/10]: 2011-10-07 07:11:27.969 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=logging.output.dir, promptMessage=Directory to store the log files, description=Directory to store the log files, allowedValues=null, defaultValue=logs, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.969 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: jcserver.maxmem | The maximum heap memory allocated to Java process in which the JChem Server is running. 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 the JChem Server process | | 700m |y...
[main/10]: 2011-10-07 07:11:27.969 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jcserver.maxmem, promptMessage=maximum memory allocated to the JChem Server process, description=The maximum heap memory allocated to Java process in which the JChem Server is running. See http://www.chemaxon.com/jchem/doc/admin/cartridge.html#server_memory for details on how to calculate the required amount., allowedValues=null, defaultValue=700m, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.969 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.970 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=structure.cache.id, promptMessage=The structure cache id of this JChem Server instance, description=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., allowedValues=null, defaultValue=JCC1, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.970 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.970 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jdbc.driver.path, promptMessage=The path to the JDBC driver to be used by JChem Server, description=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., allowedValues=null, defaultValue=, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.970 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.970 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=reservedMemory, promptMessage=The size of memory (in megabytes) which should not be used by the JChem Structure Cache, description=The size of memory (in megabytes) which should not be used by the JChem Structure Cache, allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.970 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.971 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=indexingThreadsPerCall, promptMessage=Number of threads per index operations, description=One index operation will be executed in this many concurrent threads. The default is the number of processing CPU cores., allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.971 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.971 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jcSearchThreadsPerCall, promptMessage=Number of threads per search requests, description=One search operation will be executed in this many concurrent threads. The default is the number of processing CPU cores., allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.971 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.972 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=jcReactThreadsPerCall, promptMessage=Number of threads per jc_react requests, description=One jc_react operation will be executed in this many concurrent threads. The default is the number of processing CPU cores., allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.972 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.972 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=connection.cached.pool.impl, promptMessage=Connection pool implementation to use, description=Connection pool implementation to use. See http://www.chemaxon.com/forum/viewpost17530.html#17530, allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.972 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Processing line: service.name | Name of the JChem Server service. | Name of the JChem Server service | | JChemCartridgeService |y...
[main/10]: 2011-10-07 07:11:27.972 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=service.name, promptMessage=Name of the JChem Server service, description=Name of the JChem Server service., allowedValues=null, defaultValue=JChemCartridgeService, password=false, valueToBeSaved=true, userInput=null]...
[main/10]: 2011-10-07 07:11:27.972 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
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]: 2011-10-07 07:11:27.973 chemaxon.jchem.cartridge.install.params.ConfigurationParameter createConfigurationParameter
FINEST: Returning ConfigurationParameter [name=service.display.name, promptMessage=Display name of the JChem Server service, description=Display name of the JChem Server service., allowedValues=null, defaultValue=JChem Cartridge Service, password=false, valueToBeSaved=false, userInput=null]...
[main/10]: 2011-10-07 07:11:27.975 chemaxon.jchem.cartridge.install.params.ConfigurationParameter loadFrom
FINEST: Returning {service.name=ConfigurationParameter [name=service.name, promptMessage=Name of the JChem Server service, description=Name of the JChem Server service., allowedValues=null, defaultValue=JChemCartridgeService, password=false, valueToBeSaved=true, userInput=null], dba.password=ConfigurationParameter [name=dba.password, promptMessage=DBA password, description=The password of the DBA with create schema privileges. If the DBA password is not specified, the dba login is considered unspecified as well., allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null], oracle.server.host=ConfigurationParameter [name=oracle.server.host, promptMessage=Name of the Oracle host., description=The name of the Oracle host., allowedValues=null, defaultValue=localhost, password=false, valueToBeSaved=true, userInput=null], jchem.server.port=ConfigurationParameter [name=jchem.server.port, promptMessage=The port at which the JChem Server accepts connections, description=The port at which the JChem Server accepts connections, allowedValues=null, defaultValue=1099, password=false, valueToBeSaved=true, userInput=null], jchem.server.host=ConfigurationParameter [name=jchem.server.host, promptMessage=The host name of the JChem Server, description=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., allowedValues=null, defaultValue=localhost, password=false, valueToBeSaved=true, userInput=null], service.display.name=ConfigurationParameter [name=service.display.name, promptMessage=Display name of the JChem Server service, description=Display name of the JChem Server service., allowedValues=null, defaultValue=JChem Cartridge Service, password=false, valueToBeSaved=false, userInput=null], oracle.server.login=ConfigurationParameter [name=oracle.server.login, promptMessage=Oracle "super user" login used by JChem Server to connect back to Oracle, description=Oracle "super user" login used by JChem Server to connect back to Oracle, allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null], jcart.owner.password=ConfigurationParameter [name=jcart.owner.password, promptMessage=Password of the cartridge owner, description=The password of the Oracle user in whose schema JChem Cartridge has been installed, allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null], jcReactThreadsPerCall=ConfigurationParameter [name=jcReactThreadsPerCall, promptMessage=Number of threads per jc_react requests, description=One jc_react operation will be executed in this many concurrent threads. The default is the number of processing CPU cores., allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null], oracle.home=ConfigurationParameter [name=oracle.home, promptMessage=Oracle's home, description=The directory where Oracle's "bin" directory can be found containing the Oracle executables, allowedValues=null, defaultValue=/opt/oracle/product/10.2.0/db_1, password=false, valueToBeSaved=true, userInput=null], oracle.server.password=ConfigurationParameter [name=oracle.server.password, promptMessage=Password for the Oracle "super user" login used by JChem Server to connect back to Oracle, description=Password for the Oracle "super user" used by JChem Server to connect back to Oracle, allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null], jdbc.driver.path=ConfigurationParameter [name=jdbc.driver.path, promptMessage=The path to the JDBC driver to be used by JChem Server, description=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., allowedValues=null, defaultValue=, password=false, valueToBeSaved=true, userInput=null], jcserver.maxmem=ConfigurationParameter [name=jcserver.maxmem, promptMessage=maximum memory allocated to the JChem Server process, description=The maximum heap memory allocated to Java process in which the JChem Server is running. See http://www.chemaxon.com/jchem/doc/admin/cartridge.html#server_memory for details on how to calculate the required amount., allowedValues=null, defaultValue=700m, password=false, valueToBeSaved=true, userInput=null], indexingThreadsPerCall=ConfigurationParameter [name=indexingThreadsPerCall, promptMessage=Number of threads per index operations, description=One index operation will be executed in this many concurrent threads. The default is the number of processing CPU cores., allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null], logging.config.file=ConfigurationParameter [name=logging.config.file, promptMessage=Configuration file for logging, description=Configuration file for logging, allowedValues=null, defaultValue=conf/logging.properties, password=false, valueToBeSaved=true, userInput=null], basic.jcc.role=ConfigurationParameter [name=basic.jcc.role, promptMessage=The role for basic JChem Cartridge user privileges, description=The role for basic JChem Cartridge user privileges, allowedValues=null, defaultValue=JCC_BASIC_ROLE, password=false, valueToBeSaved=true, userInput=null], oracle.server.instance=ConfigurationParameter [name=oracle.server.instance, promptMessage=Name of the Oracle instance, description=Name of the Oracle instance, allowedValues=null, defaultValue=mydb, password=false, valueToBeSaved=true, userInput=null], tns.name=ConfigurationParameter [name=tns.name, promptMessage=Local TNS name of the Oracle instance., description=The local TNS name of the Oracle instance., allowedValues=null, defaultValue=XXXX, password=false, valueToBeSaved=true, userInput=null], logging.output.dir=ConfigurationParameter [name=logging.output.dir, promptMessage=Directory to store the log files, description=Directory to store the log files, allowedValues=null, defaultValue=logs, password=false, valueToBeSaved=true, userInput=null], reservedMemory=ConfigurationParameter [name=reservedMemory, promptMessage=The size of memory (in megabytes) which should not be used by the JChem Structure Cache, description=The size of memory (in megabytes) which should not be used by the JChem Structure Cache, allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null], dba.login=ConfigurationParameter [name=dba.login, promptMessage=DBA login, description=DBA login is required to create the JChem Cartridge owner's schema, granting the JChem Cartridge owner the required system privileges, creating public synonyms and optionally creating a basic role for JChem Cartridge users. If you don't wish to specify a DBA login, please enter '!'. The SQL statements to be executed with elevated privileges can be listed by executing the 'config-util.{sh,bat} list-dba-sqls' command in the jchem/cartridge directory., allowedValues=null, defaultValue=SYSTEM, password=false, valueToBeSaved=true, userInput=null], jcart.owner.login=ConfigurationParameter [name=jcart.owner.login, promptMessage=Name of the cartridge owner, description=The name of schema where JChem Cartridge has to be installed, allowedValues=null, defaultValue=jchem, password=false, valueToBeSaved=true, userInput=null], jcSearchThreadsPerCall=ConfigurationParameter [name=jcSearchThreadsPerCall, promptMessage=Number of threads per search requests, description=One search operation will be executed in this many concurrent threads. The default is the number of processing CPU cores., allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null], oracle.server.port=ConfigurationParameter [name=oracle.server.port, promptMessage=Oracle listener port, description=The port where the Oracle listener accepts connections, allowedValues=null, defaultValue=1521, password=false, valueToBeSaved=true, userInput=null], connection.cached.pool.impl=ConfigurationParameter [name=connection.cached.pool.impl, promptMessage=Connection pool implementation to use, description=Connection pool implementation to use. See http://www.chemaxon.com/forum/viewpost17530.html#17530, allowedValues=null, defaultValue=, password=false, valueToBeSaved=false, userInput=null], license.dir=ConfigurationParameter [name=license.dir, promptMessage=The directory containing the license files, description=The directory containing the license files, allowedValues=null, defaultValue=, password=false, valueToBeSaved=true, userInput=null], structure.cache.id=ConfigurationParameter [name=structure.cache.id, promptMessage=The structure cache id of this JChem Server instance, description=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., allowedValues=null, defaultValue=JCC1, password=false, valueToBeSaved=true, userInput=null]}...
[main/10]: 2011-10-07 07:11:27.976 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=oracle.home, promptMessage=Oracle's home, description=The directory where Oracle's "bin" directory can be found containing the Oracle executables, allowedValues=null, defaultValue=/opt/oracle/product/10.2.0/db_1, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.976 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=oracle.server.host, promptMessage=Name of the Oracle host., description=The name of the Oracle host., allowedValues=null, defaultValue=localhost, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.976 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=oracle.server.port, promptMessage=Oracle listener port, description=The port where the Oracle listener accepts connections, allowedValues=null, defaultValue=1521, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.977 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=oracle.server.instance, promptMessage=Name of the Oracle instance, description=Name of the Oracle instance, allowedValues=null, defaultValue=mydb, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.977 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=tns.name, promptMessage=Local TNS name of the Oracle instance., description=The local TNS name of the Oracle instance., allowedValues=null, defaultValue=XXXX, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.977 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=jdbc.driver.path, promptMessage=The path to the JDBC driver to be used by JChem Server, description=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., allowedValues=null, defaultValue=, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.977 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=jcart.owner.login, promptMessage=Name of the cartridge owner, description=The name of schema where JChem Cartridge has to be installed, allowedValues=null, defaultValue=jchem, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.977 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=jcart.owner.password, promptMessage=Password of the cartridge owner, description=The password of the Oracle user in whose schema JChem Cartridge has been installed, allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.977 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=dba.login, promptMessage=DBA login, description=DBA login is required to create the JChem Cartridge owner's schema, granting the JChem Cartridge owner the required system privileges, creating public synonyms and optionally creating a basic role for JChem Cartridge users. If you don't wish to specify a DBA login, please enter '!'. The SQL statements to be executed with elevated privileges can be listed by executing the 'config-util.{sh,bat} list-dba-sqls' command in the jchem/cartridge directory., allowedValues=null, defaultValue=SYSTEM, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.978 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=dba.password, promptMessage=DBA password, description=The password of the DBA with create schema privileges. If the DBA password is not specified, the dba login is considered unspecified as well., allowedValues=null, defaultValue=, password=true, valueToBeSaved=false, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.978 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=jchem.server.host, promptMessage=The host name of the JChem Server, description=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., allowedValues=null, defaultValue=localhost, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.978 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=jchem.server.port, promptMessage=The port at which the JChem Server accepts connections, description=The port at which the JChem Server accepts connections, allowedValues=null, defaultValue=1099, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.978 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=jcserver.maxmem, promptMessage=maximum memory allocated to the JChem Server process, description=The maximum heap memory allocated to Java process in which the JChem Server is running. See http://www.chemaxon.com/jchem/doc/admin/cartridge.html#server_memory for details on how to calculate the required amount., allowedValues=null, defaultValue=700m, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.978 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=logging.config.file, promptMessage=Configuration file for logging, description=Configuration file for logging, allowedValues=null, defaultValue=conf/logging.properties, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.978 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=logging.output.dir, promptMessage=Directory to store the log files, description=Directory to store the log files, allowedValues=null, defaultValue=logs, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.978 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=structure.cache.id, promptMessage=The structure cache id of this JChem Server instance, description=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., allowedValues=null, defaultValue=JCC1, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.979 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=basic.jcc.role, promptMessage=The role for basic JChem Cartridge user privileges, description=The role for basic JChem Cartridge user privileges, allowedValues=null, defaultValue=JCC_BASIC_ROLE, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.979 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=service.name, promptMessage=Name of the JChem Server service, description=Name of the JChem Server service., allowedValues=null, defaultValue=JChemCartridgeService, password=false, valueToBeSaved=true, userInput=null] copied
[main/10]: 2011-10-07 07:11:27.979 chemaxon.jchem.cartridge.install.params.ConfigurationParameter copyTo
FINEST: ConfigurationParameter [name=service.display.name, promptMessage=Display name of the JChem Server service, description=Display name of the JChem Server service., allowedValues=null, defaultValue=JChem Cartridge Service, password=false, valueToBeSaved=false, userInput=null] copied

The following is missing from the terminal output:

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

Hi, Apologies for a late reply. Yes, that was the problem, the server was not running.

We now have another issue but I feel it probably needs it's own topic.

Thank you