Hi,
I'm trying to build DBD::Oracle 1.27, with DBI 1.623 (installed via
Cygwin setup), on a Windows XP Pro SP 2 guest running in a VirtualBox
OSE VM.
I've done this with both InstantClient 11.2 and the full 11.2 DB. I can
connect to the database using SQLPlus, no problem.
'perl Makefile.PL' and 'make' run without major issues (build errors
relating to invalid 'type' for some printf statements).
'make test' fails the first test, 'install_driver', reporting "Can't
load '/.../Oracle.dll' ...: Permission denied".
My environment, based on README file content, and some experimentation, is:
export ORACLE_BASE=/cygdrive/c/app/rmcgowan/product
export ORACLE_HOME=$ORACLE_BASE/11.2.0
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_USERID=etrack/********
export LD_RUN_PATH=/cygdrive/c/app/rmcgowan/product/11.2.0/lib:\
/cygdrive/c/app/rmcgowan/product/11.2.0/rdbms/lib
export DBI_DSN=DBI:Oracle:host=engtrack.engba.symantec.com;\
sid=etrackpd;port=1522
export NLS_LANG=.WE8ISO8859P15
The above was for the full DB install, essentially the same with
different path elements for Instant Client.
An ldd of Oracle.dll, built with Instant Client, printed only three
lines, the third with multiple question marks. This in spite of the
PATH including the Instant Client directory. I tried adding
LD_LIBRARY_PATH and LD_RUN_PATH variables, pointing there, with no change.
With the DBD built using the full DB install, and with the
$ORACLE_HOME/bin in the path, ldd at least shows a large number of
object files, 13 to be exact, and no lines with question marks.
But the test still fails, in the same place and with the same error.
I have tried duplicating permissions on files and directories, based on
permissions, groups and users associated with the Oracle install, same
result.
Does anyone have any suggestions? I hope I'm missing something that
will be obvious to more experienced people. ;)
Thanks,
Bob
--
Bob McGowan
Principal Software Engineer, SES Software Engineering
Shared Engineering Services
Symantec Corporation
