Our Zope 2.4.3 install is running on a SuSE Linux 7.3 server and we want to connect to an Oracle database which is sitting on a different server; a Sun Solaris based machine running OS 5.8 with Oracle Enterprise Edition 8.1.7.0 installed. We have downloaded the DCOracle2 product (for Red Hat Linux 7.1, Python 2.1) but we aren't using Red Hat and we seem unable to get the product to install properly. It complains about the ORACLE_HOME. Also, skimming through the documentation is extremely confusing. As far as we can tell, the docs seem to assume that the Oracle Database is installed (or to be installed) on the same server as the one that runs Zope. In our scenario, this isn't the case. Basically, how can we discover the correct ORACLE_HOME info from the Sun box and what else do we need to do with DCOracle2 to get it connecting to our Oracle database? (We know very little about Oracle if you can't tell already!). Richard H.
Richard Hewison wrote:
Our Zope 2.4.3 install is running on a SuSE Linux 7.3 server and we want to connect to an Oracle database which is sitting on a different server; a Sun Solaris based machine running OS 5.8 with Oracle Enterprise Edition 8.1.7.0 installed.
We have downloaded the DCOracle2 product (for Red Hat Linux 7.1, Python 2.1) but we aren't using Red Hat and we seem unable to get the product to install properly. It complains about the ORACLE_HOME. Also, skimming through the documentation is extremely confusing. As far as we can tell, the docs seem to assume that the Oracle Database is installed (or to be installed) on the same server as the one that runs Zope. In our scenario, this isn't the case.
Hello Richard, DCOracle2 requires that you have the Oracle client libraries installed on your computer. You may download from Oracle corporation the ISO images necessary to do an install of the client libraries, see http://technet.oracle.com. Currently, the Oracle 9i ISO set is three volumes, so I hope you have a good connection. I cannot redistribute Oracle's client libraries; you must obtain them from an authorized Oracle source. Once you have the Oracle client libraries installed you may connect to your remote database server on your Sun system.
Basically, how can we discover the correct ORACLE_HOME info from the Sun box and what else do we need to do with DCOracle2 to get it connecting to our Oracle database? (We know very little about Oracle if you can't tell already!).
If installing Oracle's client libraries is a daunting task, you may also pursue some kind of SQL relay agent. One commercial relay agent is OpenLink (http://www.openlink.com) which you may use with an ODBC database adapter with Zope to connect to your remote databases. I do believe there are also free Python-level remote database adapter modules, but I do not have details on them. -- Matt Kromer Zope Corporation http://www.zope.com/
On 25 Feb 2002, at 12:22, Matthew T. Kromer wrote:
Hello Richard,
DCOracle2 requires that you have the Oracle client libraries installed on your computer. You may download from Oracle corporation the ISO images necessary to do an install of the client libraries, see http://technet.oracle.com. Currently, the Oracle 9i ISO set is three volumes, so I hope you have a good connection.
I cannot redistribute Oracle's client libraries; you must obtain them from an authorized Oracle source.
Okay, so we do have to install Oracle on the Linux server. We were hoping that we wouldn't have to. Our Zope server's a bit on the crappy side and doesn't have that much space left on it.
Once you have the Oracle client libraries installed you may connect to your remote database server on your Sun system.
Sorry for the newbie type question, but what exactly should we be looking for on the technet.oracle site? Oracle client libraries for Linux don't seem to yield any results.
Basically, how can we discover the correct ORACLE_HOME info from the Sun box and what else do we need to do with DCOracle2 to get it connecting to our Oracle database? (We know very little about Oracle if you can't tell already!).
If installing Oracle's client libraries is a daunting task, you may also pursue some kind of SQL relay agent. One commercial relay agent is OpenLink (http://www.openlink.com) which you may use with an ODBC database adapter with Zope to connect to your remote databases.
That sounds a little more interesting. We'll investigate that.
I do believe there are also free Python-level remote database adapter modules, but I do not have details on them.
Does anyone else here have any further info on these? Thanks for the response! Richard H.
Richard Hewison wrote:
On 25 Feb 2002, at 12:22, Matthew T. Kromer wrote:
Hello Richard,
DCOracle2 requires that you have the Oracle client libraries installed on your computer. You may download from Oracle corporation the ISO images necessary to do an install of the client libraries, see http://technet.oracle.com. Currently, the Oracle 9i ISO set is three volumes, so I hope you have a good connection.
I cannot redistribute Oracle's client libraries; you must obtain them from an authorized Oracle source.
Okay, so we do have to install Oracle on the Linux server. We were hoping that we wouldn't have to. Our Zope server's a bit on the crappy side and doesn't have that much space left on it.
Once you have the Oracle client libraries installed you may connect to your remote database server on your Sun system.
Sorry for the newbie type question, but what exactly should we be looking for on the technet.oracle site? Oracle client libraries for Linux don't seem to yield any results.
You have to get either the Oracle 8.1.7.0.1 ISO image (1 CD image) or the Oracle 9i ISO images (3 CD images). Unless you're really in to Oracle, I recommend you investigating the alternatives; I think the minimal client install is going to chew up a LOT of disk space, and on Oracle 8i, the developer install may NOT include the necessary header files you need to rebuild DCOracle2. Note that while I like Oracle, I dont recommend you approach it lightly; if you haven't the time/space commitment available then a proxy solution is the better approach for you. -- Matt Kromer Zope Corporation http://www.zope.com/
Richard Hewison writes:
On 25 Feb 2002, at 12:22, Matthew T. Kromer wrote:
I cannot redistribute Oracle's client libraries; you must obtain them from an authorized Oracle source.
Okay, so we do have to install Oracle on the Linux server. We were hoping that we wouldn't have to. Our Zope server's a bit on the crappy side and doesn't have that much space left on it. You do not install Oracle just the Oracle client libraries...
Dieter
On 26 Feb 2002, at 20:48, Dieter Maurer wrote:
You do not install Oracle just the Oracle client libraries...
That sounds slightly less frightening... we're just a little nervous of the words 'Oracle' and 'install' being in the same sentence! Richard H.
Matthew T. Kromer writes:
... If installing Oracle's client libraries is a daunting task, you may also pursue some kind of SQL relay agent. One commercial relay agent is OpenLink (http://www.openlink.com) which you may use with an ODBC database adapter with Zope to connect to your remote databases.
I do believe there are also free Python-level remote database adapter modules, but I do not have details on them. You find one at <http://www.firstworks.com>. It's called "SQLRelay". Gives a good impression.
I am currently making first experiences with it to bridge the gap between Unix and MS SQL server by means of this product. Has good Python and Zope integration. Is a bit quiet, i.e. it is not easy to see what goes on when something does not work as one hopes. Dieter
On 26 Feb 2002, at 20:13, Dieter Maurer wrote:
You find one at <http://www.firstworks.com>. It's called "SQLRelay". Gives a good impression.
We will investigate this asap. Thanks for the pointer!
I am currently making first experiences with it to bridge the gap between Unix and MS SQL server by means of this product. Has good Python and Zope integration. Is a bit quiet, i.e. it is not easy to see what goes on when something does not work as one hopes.
Okay, we'll bare that in mind. Richard H.
On Monday 2002-02-25 at 12:22:27 -0500, Matthew T. Kromer wrote:
DCOracle2 requires that you have the Oracle client libraries installed on your computer. You may download from Oracle corporation the ISO images necessary to do an install of the client libraries, see http://technet.oracle.com. Currently, the Oracle 9i ISO set is three volumes, so I hope you have a good connection.
Is it the case, then, that DCOracle2 works with Oracle 9i? Thanks. David Trudgett
Yes, DCOracle2 will work with Oracle 9i (although it does not exploit any of Oracle 9i's new features). On Thursday, April 4, 2002, at 02:03 AM, David K. Trudgett wrote:
On Monday 2002-02-25 at 12:22:27 -0500, Matthew T. Kromer wrote:
DCOracle2 requires that you have the Oracle client libraries installed on your computer. You may download from Oracle corporation the ISO images necessary to do an install of the client libraries, see http://technet.oracle.com. Currently, the Oracle 9i ISO set is three volumes, so I hope you have a good connection.
Is it the case, then, that DCOracle2 works with Oracle 9i?
Thanks.
David Trudgett
participants (4)
-
David K. Trudgett -
Dieter Maurer -
Matthew T. Kromer -
Richard Hewison