Question for those who have used Oracle/Zope : which OS works best ? best ?
I usually work on FreeBSD or NT but now have to set up a Zope-based site that will be powered by an Oracle8 DB. The Oracle8 DB is already running on an AIX box and now I have to choose an Operating System for the boxes that will run the Zope/Apache front ends. It seems that the DCOracle connector needs SQLNet (from the Oracle client) to be installed. Since Oracle has not been ported to FreeBSD, this means I have to look for a new OS for this project. In addition, I have noticed a lot of posts from people having problems integrating Oracle/DCOracle/Zope. I really want to concentrate on the web application and not waste days/weeks fiddling with Oracle connectors or SQLNet (with Oracle 7.x on NT I remember this could be troublesome to set up). ie. Ideally, it'd work right "out the box". Which OS would you recommend as the Zope webserver in this case ? Thank you very much, chas
Hello. You could use Linux or Solaris Sparc. There are Oracle Clients for both platforms. It depends then on your budget. We are using Sun UltraSparc machines (Netra t1's and Ultra5) as Zope servers and another big Sun UltraEnterprise class machine to host the Oracle database. We are having some strange behavior on the DCOracle adapter (I presume) but it's surely due to the fact that we are using Oracle8i and the Net8 libs are somewhat different to the Oracle8 libs. We are not using LOB records in this project but I have read about them been not supported, but anyway, I am not really sure about this. So, resuming, it depends on your budget and of course the scalabilty you need. If you expect lots of hits you should even consider to look at ZEO. Just my 0.02 cents. /B Bruno Mattarollo <brunomadv@ciudad.com.ar> --- Python Powered <http://www.python.org/psa/> ----- Original Message ----- From: chas <panda@skinnyhippo.com> To: <zope@zope.org> Sent: Sunday, November 21, 1999 8:26 PM Subject: [Zope] Question for those who have used Oracle/Zope : which OS worksbest ? best ?
I usually work on FreeBSD or NT but now have to set up a Zope-based site that will be powered by an Oracle8 DB. The Oracle8 DB is already running on an AIX box and now I have to choose an Operating System for the boxes that will run the Zope/Apache front ends.
It seems that the DCOracle connector needs SQLNet (from the Oracle client) to be installed. Since Oracle has not been ported to FreeBSD, this means I have to look for a new OS for this project. In addition, I have noticed a lot of posts from people having problems integrating Oracle/DCOracle/Zope.
I really want to concentrate on the web application and not waste days/weeks fiddling with Oracle connectors or SQLNet (with Oracle 7.x on NT I remember this could be troublesome to set up). ie. Ideally, it'd work right "out the box".
Which OS would you recommend as the Zope webserver in this case ?
Thank you very much,
chas
_______________________________________________ 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 )
chas wrote:
It seems that the DCOracle connector needs SQLNet (from the Oracle client) to be installed. Since Oracle has not been ported to FreeBSD, this means I have to look for a new OS for this project. In addition, I have noticed a lot of posts from people having problems integrating Oracle/DCOracle/Zope.
Really? We've not had any major complaints that weren't do to the infinate variations that Oracle introduces into each platform... you have to figure out the libraries anew each time. And 8i is totally different than 8.0.5 which we use for development. Alas. We do our best to keep up with it. As a "FreeBSD advocate" you might try using the 3.3 Linux emulation to get the libraries working, it *should* work, and I can provide some pointers at least. I've heard tell of Oracle working under 3.3 with emulations, so I'm sure just the libraries will work.
I really want to concentrate on the web application and not waste days/weeks fiddling with Oracle connectors or SQLNet (with Oracle 7.x on NT I remember this could be troublesome to set up). ie. Ideally, it'd work right "out the box".
Well, um, then get rid of Oracle :-)
Which OS would you recommend as the Zope webserver in this case ?
This should be a corporate decision. You have to support it. FreeBSD runs rock solid with Zope, so does Linux, Solaris and others. Chris
+----[ Christopher Petrilli ]--------------------------------------------- | | As a "FreeBSD advocate" you might try using the 3.3 Linux emulation to | get the libraries working, it *should* work, and I can provide some | pointers at least. I've heard tell of Oracle working under 3.3 with | emulations, so I'm sure just the libraries will work. Are you sure? How can you link to the Linux libraries if you're not running a Linux binary? I don't fancy having to run a Linux Python to run Zope so I can use Oracle under FreeBSD. I'd be fairly impressed with a How-To for getting Zope to talk to Oracle using FreeBSD. I'm thinking of trying to get the Sybase Adapater up using FreeTDS under FreeBSD. It will solve a few of my legacy data woes (MS SQLServer *ugh* ). That's for another day though. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
participants (4)
-
Andrew Kenneth Milton -
Bruno Mattarollo -
chas -
Christopher Petrilli