OK, I have the solution (thanks David !). The answer is to set ORACLE_HOME to what it would be on the XP side of the world (i.e. in my case f:\oracle\ora92). I incorrectly assumed I needed to set it to the cygwin equivalent (/cygdrive/f/oracle/ora92). Once I set it correctly, all tests ran through OK. Maybe this could go into the README.wingcc in some future release. The thing is, Oracle now seems to frown on having an ORACLE_HOME environment variable set in the Windows environment. I did have this, but when I re-ran the Oracle installer, it told me it was removing it, because it limited my ability to have multiple Oracle Home's.
Thanks, Steve -----Original Message----- From: Steve Baldwin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 November 2002 6:53 AM To: 'Michael A Chase'; [EMAIL PROTECTED] Subject: RE: Building DBD::Oracle on cygwin Thanks for that Michael. My LD_LIBRARY_PATH env var was not set, so I set it to /usr/lib, and copied liboci.a to /usr/lib. This enabled me to successfully do a 'make'. However, on doing a 'make test', I was getting this sort of thing ... [DBD-Oracle-1.12]$ make test /usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/base.......ok t/general....DBI->connect() failed: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc. at t/general.t line 20 Unable to connect to Oracle ((UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc.) Tests skiped. This was with ORACLE_HOME set to "/cygdrive/f/oracle/ora92". I then tried sqlplus in this config, and got the following ... [DBD-Oracle-1.12]$ export ORACLE_USERID="sbdev/sbdev@sb9i" [DBD-Oracle-1.12]$ sqlplus $ORACLE_USERID Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory So, I unset ORACLE_HOME, and tried sqlplus again ... [DBD-Oracle-1.12]$ unset ORACLE_HOME [DBD-Oracle-1.12]$ sqlplus $ORACLE_USERID SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 19 06:26:40 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production I then tried 'make test', and it sort of worked, but I got all these messages about ORACLE_HOME not set ... [DBD-Oracle-1.12]$ make test /usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/base.......ok t/general....ORACLE_HOME environment variable not set! t/general....ok t/long.......ORACLE_HOME environment variable not set! t/long.......ok t/ph_type....ORACLE_HOME environment variable not set! t/ph_type....ok t/plsql......ORACLE_HOME environment variable not set! t/plsql......ok t/reauth.....skipped all skipped: no reason given All tests successful, 1 test skipped. Files=6, Tests=281, 21 wallclock secs ( 1.07 cusr + 0.74 csys = 1.81 CPU) : I then wrote my own tiny test script ... use strict ; use DBI ; my $dbh = DBI->connect('dbi:Oracle:', 'sbdev/sbdev@sb9i', '', {'RaiseError'=>1}) ; my $sth = $dbh->prepare("select 'hello' from dual") ; $sth->execute ; my $row = $sth->fetchrow_arrayref() ; print ">>> $row->[0] <<<\n" ; $sth->finish ; $dbh->disconnect ; On running it, if ORACLE_HOME is set, I get this ... [DBD-Oracle-1.12]$ export ORACLE_HOME=/cygdrive/f/oracle/ora92 [DBD-Oracle-1.12]$ perl sbtest.pl DBI->connect() failed: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc. at sbtest.pl line 3 If I unset it, I get this ... [DBD-Oracle-1.12]$ ORACLE_HOME= perl sbtest.pl ORACLE_HOME environment variable not set! >>> hello <<< So, it sort of works, but I get these annoying "ORACLE_HOME environment variable not set!" messages. What have I stuffed up now ??? Thanks, Steve -----Original Message----- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 November 2002 2:30 AM To: [EMAIL PROTECTED]; Steve Baldwin Subject: Re: Building DBD::Oracle on cygwin On Mon, 18 Nov 2002 20:26:05 +1100 Steve Baldwin <[EMAIL PROTECTED]> wrote: > I'm trying to build DBD::Oracle 1.12 on the latest cygwin, and perl > 5.8 > - without much success. I have Oracle 9.2 installed on the XP side of > my machine, and have verified it is functional. I can run sql*plus from > cygwin (if that proves anything). Every other Perl module (including > DBI) has installed and worked flawlessly. As you will see from the > output below, my $ORACLE_HOME is set to /cygdrive/f/oracle/ora92 (which > translates to f:\oracle\ora92 in the XP world). > > I followed the instructions in README.wingcc to build liboci.a. > > Here is the output from Makefile.PL ... > > [DBD-Oracle-1.12]$ perl Makefile.PL > Using DBI 1.30 installed in > /usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/auto/DBI > Using liboci.a (did you build it?) > !!! Note (probably harmless): No library found for -loci > Is this do-able, or am I bashing my head against a brick wall ? Any > hints much appreciated. Where did you save the liboci.a? It should probably be in DBD-Oracle-1.12/, but it needs to be somewhere in the library search path used by Makefile.PL before you run Makefile.PL. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
