X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=-4.4 required=5.0	tests=AWL,BAYES_00,KHOP_RCVD_UNTRUST,KHOP_THREADED,RCVD_IN_HOSTKARMA_W,RCVD_IN_HOSTKARMA_WL,RP_MATCHES_RCVD
X-Spam-Check-By: sourceware.org
Message-ID: <51368D88.7@symantec.com>
Date: Tue, 5 Mar 2013 16:27:52 -0800
From: Bob McGowan <bob_mcgowan AT symantec DOT com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.16) Gecko/20080707 Thunderbird/2.0.0.16 Mnenhy/0.7.6.666
MIME-Version: 1.0
To: Reini Urban <rurban AT x-ray DOT at>
CC: "cygwin AT cygwin DOT com" <cygwin AT cygwin DOT com>
Subject: Re: Perl DBD::Oracle 'make test' fails: Oracle.dll permission denied
References: <5134EFA4 DOT 3010505 AT symantec DOT com> <CAHiT=DG8TLN7_nTRg_8_VHKbJm+PcyM0X3He7M=vKBea=gn27w AT mail DOT gmail DOT com>
In-Reply-To: <CAHiT=DG8TLN7_nTRg_8_VHKbJm+PcyM0X3He7M=vKBea=gn27w@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"; format=flowed
Content-Transfer-Encoding: 7bit
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

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