|
|
| Author |
Message |
|
|
| Post subject: Installing JChem Cartridge for Oracle RAC |
 Posted: Thu Mar 01, 2007 9:15 pm |
 |
|
Hi
Sorry to post this again. I posted in a wrong forum earlier.
I have a question on installing JChem Cartridge for Oracle RAC. Since there is a requirement for Apache Tomcat for the installation, I was wondering how to go about.
We have two nodes for Oracle RAC and am wondering how to install Tomcat on the nodes. Do each of the node will have tomcat installed if Tomcat were to be installed on the nodes of the Oracle RAC?
OR can Apache Tomcat live on a different machine and connect as a client for the Oracle RAC using tnsnames file?
Please advice. If you have any other recommendation I would love to hear from you.
Thank you |
|
 |
|
|
| Post subject: |
| Posted: Thu Mar 01, 2007 10:24 pm |
|
|
Hi,
In general, Tomcat doesn't have to be on the same machine as Oracle.
There are basically two requirements:
(1) Oracle (Java) stored procedures must be able to make http requests to Tomcat (through the domain name or IP address of the machine hosting Tomcat);
(2) Tomcat must be able to open database connections to Oracle (not through tnsnames, but through ip address [or domain name], listener port number and SID -- parameters which can be configured using the HTML based admin GUI described in the installation guide).
I've never tested JChem Cartridge in a RAC (and, to be honest, I don't know very much about RAC apart from what this abbreviation stands for).
Tomcat is, in the context of the second condition, a mere database client, so condition (2) is almost certainly met with RACs. I am not so sure about condition (1), but if stored procedures can do the same things in RACs as with stand-alone Oracle installations, I don't see apriori any reason why this condition shouldn't be met.
Let me know how you get on.
Cheers
Peter |
|
|
|
|
| Post subject: Re: Installing JChem Cartridge for Oracle RAC |
| Posted: Wed Aug 01, 2007 10:18 pm |
|
|
| reddygali wrote: | Hi
Sorry to post this again. I posted in a wrong forum earlier.
I have a question on installing JChem Cartridge for Oracle RAC. Since there is a requirement for Apache Tomcat for the installation, I was wondering how to go about.
We have two nodes for Oracle RAC and am wondering how to install Tomcat on the nodes. Do each of the node will have tomcat installed if Tomcat were to be installed on the nodes of the Oracle RAC?
OR can Apache Tomcat live on a different machine and connect as a client for the Oracle RAC using tnsnames file?
Please advice. If you have any other recommendation I would love to hear from you.
Thank you |
I am also interested in testing JChem with an Oracle 10g RAC - did you had any success in setting it up?
I have tested Oracle 10g with JChem 3.1.3 using a database of 50 million molecules which works without any problem (and very fast!) on an 4CPU SGI Altix 330 12GB RAM machine. Now I wanted to compare this with a 3*4GB node cluster... The goal is to find an optimal set-up for very large databases.
best regards
Lutz |
|
|
|
Register (required to post and download)
FAQ
Search
Digests
