Zope list members, I have been developing a zope site with oracle on linux as a backend. Currently, I run both zope and oracle on the same machine using the ZOracleDA for connectivity. However, for production, I plan to seperate the tiers and run zope and and oracle on different servers. From looking at the build instructions for the DCOracle, it seems as though it will only work when the web server and database server are on the same filesystem/in the same memory space. Is there a way to have my zope server talk to a remote (across the network somewhere) database server? Do I have to move to something like ODBC for this? Thanks for your help! Aaron Bostick Network Architect Exodus Professional Services
Hi, If you are running Zope on 1. Linux: You need to install Oracle client libraries to compile ZOracleDA. As far as I know, Oracle does not give any easy way to install only the clients. So, if you've enough disk space, install Oracle with the minimum DB options, and compile ZOracleDA. You DON'T NEED to run Oracle DB on your Zope machine, to have zope connect to your actual DB machine. 2. Win NT/2000/98 You can install only the client libraries from the Oracle CD, get ZOracleDA compiled and run Zope. I've used it both ways. Somewhere on the net there was a tarred version of client-only-oracle-4-linux. Check freshmeat.net and gnome.org for some GTK apps for accessing Oracle. It was there in the homepage for that suite of apps. ----- Original Message ----- From: Aaron Bostick <Aaron.Bostick@exodus.net> To: <zope@zope.org> Sent: Wednesday, July 26, 2000 4:45 PM Subject: [Zope] ZOracleDA
Zope list members,
I have been developing a zope site with oracle on linux as a backend. Currently, I run both zope and oracle on the same machine using the ZOracleDA for connectivity. However, for production, I plan to seperate the tiers and run zope and and oracle on different servers. From looking at the build instructions for the DCOracle, it seems as though it will only work when the web server and database server are on the same filesystem/in the same memory space.
Is there a way to have my zope server talk to a remote (across the network somewhere) database server? Do I have to move to something like ODBC for this?
Thanks for your help! Aaron Bostick Network Architect Exodus Professional Services
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
On Wed, Jul 26, 2000 at 06:28:55PM -0400, Satheesh Babu wrote:
Hi,
If you are running Zope on 1. Linux: You need to install Oracle client libraries to compile ZOracleDA. As far as I know, Oracle does not give any easy way to install only the clients. So, if you've enough disk space, install Oracle with the minimum DB options, and compile ZOracleDA. You DON'T NEED to run Oracle DB on your Zope machine, to have zope connect to your actual DB machine.
I think that 8.1.5i had an option to install client. stuff (beacuse that is what i did at first). However, you need to compile the ZOracleDA on a machine where the entire oracle is installed, because some crucial haeder files only come with the full install. Then, just remember to set up the tns listener on server and the tnsnames.ora on the client, but that stuff is out of this list's scope. -- Riku Voipio riku.voipio@tietoenator.com 09-862 60764
Aaron Bostick wrote:
Zope list members,
I have been developing a zope site with oracle on linux as a backend. Currently, I run both zope and oracle on the same machine using the ZOracleDA for connectivity. However, for production, I plan to seperate the tiers and run zope and and oracle on different servers. From looking at the build instructions for the DCOracle, it seems as though it will only work when the web server and database server are on the same filesystem/in the same memory space.
Is there a way to have my zope server talk to a remote (across the network somewhere) database server? Do I have to move to something like ODBC for this?
You do not need ODBC. SQL*Net sufficies. I have not done it with Zope but used it succesfully with Perl/DBI and C++ programs. It is enough to copy libclntsh.so and define tnsnames.ora file (and of course your language - in this case Python/Zope - modules for Oracle) to client machine and run TNS listner on server machine. Sample configuration below. * On the server (where database runs) You should have /opt/oracle/8.0.5/network/admin/listener.ora with sth. like (ORA is my SID, gauss is the server TCP name). LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= ORA)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= gauss)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME= /opt/oracle/8.0.5) (SID_NAME = ORA) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF Start tns listener with lsnrctl start (from oracle account) * On the client (where application runs) Define /etc/tnsnames.ora with sth. like (you can place multiple entries if you like) GAUSS = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= gauss)(Port= 1521)) (CONNECT_DATA = (SID = ORA)) ) (sid and host must match settings on server) Define TNS_ADMIN to point to directory the file above lies export TNS_ADMIN=/etc Define TWO_TASK to tnsnames.ora variable export TWO_TASK=GAUSS You can run your application. You can also copy tools like sqlplus and run them. -- Marcin.Kasperski | Working overtime sucks the spirit and motivation out @softax.com.pl | of a team. Projects that require overtime to be Marcin.Kasperski | finished on time will be late no matter what you do. @bigfoot.com | (Wells)
participants (4)
-
Aaron Bostick -
Marcin Kasperski -
Riku Voipio -
Satheesh Babu