[Zope] something missing in my Oracle setup?
I'm having the same kind of problem. This is my environment: RedHat Linux 6.1 Stronghold 2.4.2/Apache1.3.6 Zope 2.1.6 (running as PCGI) DCOracle 1.3.0 ZOracleDA 2.1.0 Oracle 8.1.6 (client with C-Pro environment installed) The environment is properly set: LD_LIBRARY_PATH is correct, ld.so.conf was properly modified and I've already run ldconfig. I've successfully compiled the DCOracle product and tested it with success. But when I try to create a ZOracle connection object, the server gives me the following answer: "Internal Server Error - The server encountered an internal error or misconfiguration and was unable to complete your request". And here is the message I've found in the error log file: "[error] PCGI Error: [503 Service Unavailable] ((116) unable to connect, fd=4) Success". Does anybody know what is happening and how to solve this? TIA, Alexandre. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 10:44 AM To: [EMAIL PROTECTED] Subject: Re: [Zope] something missing in my Oracle setup? I wanted to thank Jens and Anthony for the pointers. I ended up doing the full server install. The only other thing required was to put $ORACLE_HOME/lib in my ld.so.conf and run ldconfig. Things seem to work fine now, though I haven't really hammered on DCOracle yet. Thanks again, -Justin ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] something missing in my Oracle setup?
I'm having the same kind of problem. This is my environment: RedHat Linux 6.1 Stronghold 2.4.2/Apache1.3.6 Zope 2.1.6 (running as PCGI) DCOracle 1.3.0 ZOracleDA 2.1.0 Oracle 8.1.6 (client with C-Pro environment installed) The environment is properly set: LD_LIBRARY_PATH is correct, ld.so.conf was properly midified and I've already run ldconfig. I've successfuly compiled the DCOracle product and tested it with success. But when I try to create a ZOracle connection object, the server gives me the following answer: "Internal Server Error - The server encountered an internal error or misconfiguration and was unable to complete your request". And here is the message I've found in the error log file: "[error] PCGI Error: [503 Service Unavailable] ((116) unable to connect, fd=4) Success". Does anybody know what is happening and how to solve this? TIA, Alexandre. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 31, 2000 10:44 AM To: [EMAIL PROTECTED] Subject: Re: [Zope] something missing in my Oracle setup? I wanted to thank Jens and Anthony for the pointers. I ended up doing the full server install. The only other thing required was to put $ORACLE_HOME/lib in my ld.so.conf and run ldconfig. Things seem to work fine now, though I haven't really hammered on DCOracle yet. Thanks again, -Justin ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] something missing in my Oracle setup?
I wanted to thank Jens and Anthony for the pointers. I ended up doing the full server install. The only other thing required was to put $ORACLE_HOME/lib in my ld.so.conf and run ldconfig. Things seem to work fine now, though I haven't really hammered on DCOracle yet. Thanks again, -Justin ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] something missing in my Oracle setup?
>>> Justin Sheehy wrote > Hello, > > I am trying to build the DCOracle module and having trouble right off > the bat. I have tried both 1.3.0 and 1.3.1 b1 with the same results. > > The file src/oci_8.c does an #include "oci.h", but I don't seem to > have a file named oci.h in my oracle install: It normally lives in rdbms/demo/oci.h Under some Oracle installation modes, rdbms/ is only accessible to user 'oracle'. I'm not sure what options you'll need to specify to get that particular directory installed. (if someone was to destroy the oracle installer and replace it with something that worked, I think a lot of people would be very very happy.) On a related note - make sure you link with libclntsh, not libnjni8 - at least one version of a Setup file for DCOracle specified njni8. As far as we can tell, libnjni8 is not properly threadsafe on solaris/ sparc. Anthony ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] something missing in my Oracle setup?
hi justin, it is your oracle install. i have had bad experiences with the fancy shmancy 8.1.x java installer myself. oci.h is in a subdirectory of $ORACLE_HOME called 'rdbms'. i remember doing the client setup did not give me the stuff i needed so i basically copied everything it was missing from a second pretty much identical box with a full server install. it would be easiest if you had a machine with a full server install. jens Jens Vagelpohl[EMAIL PROTECTED] Software Engineer www.digicool.com Digital Creations (888) 344-4332 Got Zope? on 5/29/00 18:04, Justin Sheehy at [EMAIL PROTECTED] wrote: > Hello, > > I am trying to build the DCOracle module and having trouble right off > the bat. I have tried both 1.3.0 and 1.3.1 b1 with the same results. > > The file src/oci_8.c does an #include "oci.h", but I don't seem to > have a file named oci.h in my oracle install: > > $ find $ORACLE_HOME -name '*.h' > /opt/orahome1/network/public/tnsapi.h > /opt/orahome1/network/public/nzerror.h > /opt/orahome1/network/public/nzt.h > /opt/orahome1/otrace/public/epc.h > /opt/orahome1/plsql/public/ociextp.h > /opt/orahome1/precomp/public/sql2oci.h > /opt/orahome1/precomp/public/sqlucs2.h > /opt/orahome1/precomp/public/oraca.h > /opt/orahome1/precomp/public/sqlapr.h > /opt/orahome1/precomp/public/sqlca.h > /opt/orahome1/precomp/public/sqlcpr.h > /opt/orahome1/precomp/public/sqlda.h > /opt/orahome1/precomp/public/sqlkpr.h > /opt/orahome1/precomp/public/a.out.h > /opt/orahome1/precomp/public/limits.h > /opt/orahome1/precomp/public/bits/mathcalls.h > /opt/orahome1/precomp/public/sys/ipc.h > > My Oracle install is the 'Programmer' distribution from Oracle 8.1.5. > > Do I need the full install, not just the Programmer install, or am I > missing something else? > > I tried using the Setup file for Oracle 8i on Linux that was sent to > this list by Laurent Chane-Chuen-Kee, but that does not have any > effect on the problem. > > Thanks, > > -Justin Sheehy > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 ) > > ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] something missing in my Oracle setup?
Hello, I am trying to build the DCOracle module and having trouble right off the bat. I have tried both 1.3.0 and 1.3.1 b1 with the same results. The file src/oci_8.c does an #include "oci.h", but I don't seem to have a file named oci.h in my oracle install: $ find $ORACLE_HOME -name '*.h' /opt/orahome1/network/public/tnsapi.h /opt/orahome1/network/public/nzerror.h /opt/orahome1/network/public/nzt.h /opt/orahome1/otrace/public/epc.h /opt/orahome1/plsql/public/ociextp.h /opt/orahome1/precomp/public/sql2oci.h /opt/orahome1/precomp/public/sqlucs2.h /opt/orahome1/precomp/public/oraca.h /opt/orahome1/precomp/public/sqlapr.h /opt/orahome1/precomp/public/sqlca.h /opt/orahome1/precomp/public/sqlcpr.h /opt/orahome1/precomp/public/sqlda.h /opt/orahome1/precomp/public/sqlkpr.h /opt/orahome1/precomp/public/a.out.h /opt/orahome1/precomp/public/limits.h /opt/orahome1/precomp/public/bits/mathcalls.h /opt/orahome1/precomp/public/sys/ipc.h My Oracle install is the 'Programmer' distribution from Oracle 8.1.5. Do I need the full install, not just the Programmer install, or am I missing something else? I tried using the Setup file for Oracle 8i on Linux that was sent to this list by Laurent Chane-Chuen-Kee, but that does not have any effect on the problem. Thanks, -Justin Sheehy ___ Zope maillist - [EMAIL PROTECTED] 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 )
