Installing DBD::Oracle for 9i on Cygwin

dragonchild has asked for the wisdom of the Perl Monks concerning the following question:

I'm having serious issues. I've installed the Oracle 9i Personal edition Run-time Client libraries and pointed ORACLE_HOME to /cygdrive/c/oracle/dev_suite, but DBD::Oracle is complaining that there's no OCI directory (which, there isn't).

Does anyone have any suggestions?

I'm running the latest cygwin (on WinXP), perl 5.8.0, the latest Oracle 9i clients, and the latest Perl modules. (The install happened yesterday for most items, today for the Oracle-specific ones.)

Update: For those wondering, you have to set the ORACLE_HOME in the WinXP system properties, then specify the SID in the connect string. (e.g., scott/tiger@some_sid) You can't just specify ORACLE_SID (for some reason).

------
We are the carpenters and bricklayers of the Information Age.

The idea is a little like C++ templates, except not quite so brain-meltingly complicated. -- TheDamian, Exegesis 6

... strings and arrays will suffice. As they are easily available as native data types in any sane language, ... - blokhead, speaking on evolutionary algorithms

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

Comment on Installing DBD::Oracle for 9i on Cygwin

Replies are listed 'Best First'.
Re: Installing DBD::Oracle for 9i on Cygwin by rdfield (Priest) on Nov 06, 2003 at 11:43 UTC
I seriously doubt that the Oracle Client software will understand Cygwin paths, and it certainly won't be certified (so don't expect any help from Oracle). The path to the Oracle EXEs isn't generally set in the ORACLE_HOME env var on Windows boxes (maybe that's not with XP, but certainly for W2K & NT4), but in the PATH. Try putting the WinXP path to your Oracle software in the %PATH% and then fire up Cygwin's Perl installer, eg `set PATH=c:\Oracle\dev_suite\bin;%PATH%` [download] (remember the "bin" at the end of the Oracle PATH) rdfield	[reply] [d/l]

Replies are listed 'Best First'.

Re: Installing DBD::Oracle for 9i on Cygwin
by rdfield (Priest) on Nov 06, 2003 at 11:43 UTC

set PATH=c:\Oracle\dev_suite\bin;%PATH%
[download]

rdfield

[reply]
[d/l]