Perl DBD::Oracle 'make test' fails: Oracle.dll permission denied

Bob McGowan bob_mcgowan@symantec.com
Wed Mar 6 00:25:00 GMT 2013


Well, I get:

$ ldd Oracle.dll
   ntdll.dll => /cygdrive/c/WINDOWS/system32/ntdll.dll (0x7c900000)
   kernel32.dll => /cygdrive/c/WINDOWS/system32/kernel32.dll (0x7c800000)
   ??? => ??? (0x6f440000)

So I'd think this was my environment, but (edited to protect the ...), 
and I shortened the longer lines, using the traditional UNIX line 
continuation backslash:

$ env
.
.
.
SHELL=/bin/bash
OS=Windows_NT
XTERM_SHELL=/bin/bash
ORACLE_USERID=etrack/*******
PATH=/home/rmcgowan/bin:/usr/local/bin:/usr/bin:\
      /cygdrive/c/WINDOWS/system32:\
      /cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:\
      /home/rmcgowan/work/oracle/instantclient_11_2
LANG=en_US.UTF-8
TZ=America/Los_Angeles
XTERM_LOCALE=en_US.UTF-8
DBI_DSN=dbi:Oracle:host=toolsdb-dev.engba.symantec.com;sid=etrackdv;\
      port=1522
ORACLE_HOME=/home/rmcgowan/work/oracle/instantclient_11_2
NLS_LANG=.WE8ISO8859P15

So, instant client dll's should be accessable, via PATH, I have a DSN 
and USERID that work in other environments, so should be OK here, and 
ORACLE_HOME set.  I've even set NLS_LANG, just in case.

I still get the same permission denied error, and 'ldd .../Oracle.dll' 
shows the same 3 lines of output.

I even took the simple example from the user guide and built the dll 
version of 'hello world', and that worked just fine.

Clearly, I'm missing something here.

But what?

Thanks,

Bob

On 03/05/2013 06:10 AM, Reini Urban wrote:
> On Mon, Mar 4, 2013 at 1:01 PM, Bob McGowan  wrote:
>> I have DBI 1.623 installed, and am attempting to install DBD::Oracle 1.27.
>>
>> I'm using Oracle instant client for Oracle 11.2, and I created my own
>> oci.def file using 'pexports' and 'dlltool', as described in the header of
>> the original oci.def file.
>>
>> The 'perl Makefile.PL' generates no errors.
>>
>> My 'make' creates Oracle.dll without any major issues (a few minor
>> complaints about mismatched types in printf, pointer casts, ...).
>>
>> The 'make test' fails the first test:
>>
>>    Can't load ... Oracle.dll for module DBD::Oracle: Permission denied...
>
> I'm not sure if the Dynaloader fails, or if the connection to the
> oracle db fails with this error.
>
> If it's the Dynaloader be sure that all dependencies can be loaded.
> ldd blib/arch/Oracle/Oracle.dll will tell you that.
>

-- 
Bob McGowan
Principal Software Engineer, SES Software Engineering
Shared Engineering Services
Symantec Corporation

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple



More information about the Cygwin mailing list