DBD::Oracle in 64 bit Linux

DBD::Oracle in 64 bit Linux

am 02.08.2007 20:40:02 von a_arya2000

Hi, I am trying to install DBD::Oracle in a Linux 64
bit machine but facing problem and not sure what i am
doing wrong or if something wrong with oracle client
installation. make looks ok, but when I run make test
I get this.
---------------------------
t/01base................Failed to load Oracle
extension and/or shared libraries:
install_driver(Oracle) failed: Can't load
'/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
for module DBD::Oracle:
/usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
cannot open shared object file: No such file or
directory at
/usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
line 229.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't
installed where expected
..........
..........
-----------------------------------------

For rest of the tests I get almost same output. Also I
checked, Oracle.so in that give directory. I am
wondering what causing this problem? One thing I
should note though, oracle client that is installed in
this machine, is the basic installation not the full
installation. Could it be the reason? Any one else
experience this issue before? I am kind of suck on
that one, any help will be appreciated. Thank you




____________________________________________________________ ________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469

Re: DBD::Oracle in 64 bit Linux

am 03.08.2007 13:12:30 von cbrandt

What version of the Oracle client do you have installed?


a_arya2000 wrote:
> Hi, I am trying to install DBD::Oracle in a Linux 64
> bit machine but facing problem and not sure what i am
> doing wrong or if something wrong with oracle client
> installation. make looks ok, but when I run make test
> I get this.
> ---------------------------
> t/01base................Failed to load Oracle
> extension and/or shared libraries:
> install_driver(Oracle) failed: Can't load
> '/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
> for module DBD::Oracle:
> /usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
> cannot open shared object file: No such file or
> directory at
> /usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
> line 229.
> at (eval 3) line 3
> Compilation failed in require at (eval 3) line 3.
> Perhaps a required shared library or dll isn't
> installed where expected
> .........
> .........
> -----------------------------------------
>
> For rest of the tests I get almost same output. Also I
> checked, Oracle.so in that give directory. I am
> wondering what causing this problem? One thing I
> should note though, oracle client that is installed in
> this machine, is the basic installation not the full
> installation. Could it be the reason? Any one else
> experience this issue before? I am kind of suck on
> that one, any help will be appreciated. Thank you
>
>
>
>
> ____________________________________________________________ ________________________
> Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
> http://answers.yahoo.com/dir/?link=list&sid=396545469

--
Jim Brandt
Administrative Computing Services
University at Buffalo

Re: DBD::Oracle in 64 bit Linux

am 03.08.2007 17:14:48 von a_arya2000

The oracle client version is 10
Thank you,
Arya
--- Jim Brandt wrote:

> What version of the Oracle client do you have
> installed?
>
>
> a_arya2000 wrote:
> > Hi, I am trying to install DBD::Oracle in a Linux
> 64
> > bit machine but facing problem and not sure what i
> am
> > doing wrong or if something wrong with oracle
> client
> > installation. make looks ok, but when I run make
> test
> > I get this.
> > ---------------------------
> > t/01base................Failed to load Oracle
> > extension and/or shared libraries:
> > install_driver(Oracle) failed: Can't load
> >
>
'/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
> > for module DBD::Oracle:
> >
>
/usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
> > cannot open shared object file: No such file or
> > directory at
> >
>
/usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
> > line 229.
> > at (eval 3) line 3
> > Compilation failed in require at (eval 3) line 3.
> > Perhaps a required shared library or dll isn't
> > installed where expected
> > .........
> > .........
> > -----------------------------------------
> >
> > For rest of the tests I get almost same output.
> Also I
> > checked, Oracle.so in that give directory. I am
> > wondering what causing this problem? One thing I
> > should note though, oracle client that is
> installed in
> > this machine, is the basic installation not the
> full
> > installation. Could it be the reason? Any one else
> > experience this issue before? I am kind of suck on
> > that one, any help will be appreciated. Thank you
> >
> >
> >
> >
> >
>
____________________________________________________________ ________________________
> > Be a better Globetrotter. Get better travel
> answers from someone who knows. Yahoo! Answers -
> Check it out.
> >
>
http://answers.yahoo.com/dir/?link=list&sid=396545469
>
> --
> Jim Brandt
> Administrative Computing Services
> University at Buffalo
>
>




____________________________________________________________ ________________________
Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games.
http://sims.yahoo.com/

Re: DBD::Oracle in 64 bit Linux

am 03.08.2007 21:27:38 von cbrandt

We've recently been debugging an issue with the Oracle 10g client
install that basically relates back to permissions on the client
libraries. In a nutshell, we found that our normal procedure of:

* run client install
* run oracle permissions repair script

didn't actually fully repair the permissions. We're still looking into
the details, but the solution was to make sure the user trying to run
the DBD::Oracle install has permission to read all of the client
libraries. We did all (or nearly all) files because it was too difficult
to narrow down exactly which ones were wrong on a case by case basis.


a_arya2000 wrote:
> The oracle client version is 10
> Thank you,
> Arya
> --- Jim Brandt wrote:
>
>> What version of the Oracle client do you have
>> installed?
>>
>>
>> a_arya2000 wrote:
>>> Hi, I am trying to install DBD::Oracle in a Linux
>> 64
>>> bit machine but facing problem and not sure what i
>> am
>>> doing wrong or if something wrong with oracle
>> client
>>> installation. make looks ok, but when I run make
>> test
>>> I get this.
>>> ---------------------------
>>> t/01base................Failed to load Oracle
>>> extension and/or shared libraries:
>>> install_driver(Oracle) failed: Can't load
>>>
> '/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
>>> for module DBD::Oracle:
>>>
> /usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
>>> cannot open shared object file: No such file or
>>> directory at
>>>
> /usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
>>> line 229.
>>> at (eval 3) line 3
>>> Compilation failed in require at (eval 3) line 3.
>>> Perhaps a required shared library or dll isn't
>>> installed where expected
>>> .........
>>> .........
>>> -----------------------------------------
>>>
>>> For rest of the tests I get almost same output.
>> Also I
>>> checked, Oracle.so in that give directory. I am
>>> wondering what causing this problem? One thing I
>>> should note though, oracle client that is
>> installed in
>>> this machine, is the basic installation not the
>> full
>>> installation. Could it be the reason? Any one else
>>> experience this issue before? I am kind of suck on
>>> that one, any help will be appreciated. Thank you
>>>
>>>
>>>
>>>
>>>
> ____________________________________________________________ ________________________
>>> Be a better Globetrotter. Get better travel
>> answers from someone who knows. Yahoo! Answers -
>> Check it out.
> http://answers.yahoo.com/dir/?link=list&sid=396545469
>> --
>> Jim Brandt
>> Administrative Computing Services
>> University at Buffalo
>>
>>
>
>
>
>
> ____________________________________________________________ ________________________
> Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games.
> http://sims.yahoo.com/

--
Jim Brandt
Administrative Computing Services
University at Buffalo

Re: DBD::Oracle in 64 bit Linux

am 04.08.2007 01:01:58 von a_arya2000

Hello Jim,
Thank you very much for the information. Actually, I
was unaware of this permission issue. Is the
permission issue a general issue or specific to 64 bit
installation? Because I did compile and installed
DBD::Oracle for oracle 10 client in 32 bit Linux
machine, which looks ok (so far). Though I know, some
people having issue with it. Do you know if
DBD::Oralce was tested for 64 bit machine? and if it
was, then what was the out come?
Thank you,
Partha Dhar

--- Jim Brandt wrote:

> We've recently been debugging an issue with the
> Oracle 10g client
> install that basically relates back to permissions
> on the client
> libraries. In a nutshell, we found that our normal
> procedure of:
>
> * run client install
> * run oracle permissions repair script
>
> didn't actually fully repair the permissions. We're
> still looking into
> the details, but the solution was to make sure the
> user trying to run
> the DBD::Oracle install has permission to read all
> of the client
> libraries. We did all (or nearly all) files because
> it was too difficult
> to narrow down exactly which ones were wrong on a
> case by case basis.
>
>
> a_arya2000 wrote:
> > The oracle client version is 10
> > Thank you,
> > Arya
> > --- Jim Brandt wrote:
> >
> >> What version of the Oracle client do you have
> >> installed?
> >>
> >>
> >> a_arya2000 wrote:
> >>> Hi, I am trying to install DBD::Oracle in a
> Linux
> >> 64
> >>> bit machine but facing problem and not sure what
> i
> >> am
> >>> doing wrong or if something wrong with oracle
> >> client
> >>> installation. make looks ok, but when I run make
> >> test
> >>> I get this.
> >>> ---------------------------
> >>> t/01base................Failed to load Oracle
> >>> extension and/or shared libraries:
> >>> install_driver(Oracle) failed: Can't load
> >>>
> >
>
'/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
> >>> for module DBD::Oracle:
> >>>
> >
>
/usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
> >>> cannot open shared object file: No such file or
> >>> directory at
> >>>
> >
>
/usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
> >>> line 229.
> >>> at (eval 3) line 3
> >>> Compilation failed in require at (eval 3) line
> 3.
> >>> Perhaps a required shared library or dll isn't
> >>> installed where expected
> >>> .........
> >>> .........
> >>> -----------------------------------------
> >>>
> >>> For rest of the tests I get almost same output.
> >> Also I
> >>> checked, Oracle.so in that give directory. I am
> >>> wondering what causing this problem? One thing I
> >>> should note though, oracle client that is
> >> installed in
> >>> this machine, is the basic installation not the
> >> full
> >>> installation. Could it be the reason? Any one
> else
> >>> experience this issue before? I am kind of suck
> on
> >>> that one, any help will be appreciated. Thank
> you
> >>>
> >>>
> >>>
> >>>
> >>>
> >
>
____________________________________________________________ ________________________
> >>> Be a better Globetrotter. Get better travel
> >> answers from someone who knows. Yahoo! Answers -
> >> Check it out.
> >
>
http://answers.yahoo.com/dir/?link=list&sid=396545469
> >> --
> >> Jim Brandt
> >> Administrative Computing Services
> >> University at Buffalo
> >>
> >>
> >
> >
> >
> >
> >
>
____________________________________________________________ ________________________
> > Moody friends. Drama queens. Your life? Nope! -
> their life, your story. Play Sims Stories at Yahoo!
> Games.
> > http://sims.yahoo.com/
>
> --
> Jim Brandt
> Administrative Computing Services
> University at Buffalo
>
>




____________________________________________________________ ________________________
Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/

RE: DBD::Oracle in 64 bit Linux

am 05.08.2007 21:43:37 von ucantspamthis

I had a similar problem installing DBD::ODBC and DBD::Oracle on 64-bit RedH=
at. My Perl build was a 64-bit. I received the same error as you did. I=
n my case Makefile.PL was writing the path to my 32-bit libraries to my mak=
efile. I had to edit it replacing the ../lib/.. paths with ../lib64/.. =
After that, it built and tested just fine.


Best of luck,
Craig



----------------------------------------
> Date: Fri, 3 Aug 2007 16:01:58 -0700
> From: a_arya2000@yahoo.com
> Subject: Re: DBD::Oracle in 64 bit Linux
> To: cbrandt@buffalo.edu
> CC: dbi-users@perl.org
>=20
> Hello Jim,
> Thank you very much for the information. Actually, I
> was unaware of this permission issue. Is the
> permission issue a general issue or specific to 64 bit
> installation? Because I did compile and installed
> DBD::Oracle for oracle 10 client in 32 bit Linux
> machine, which looks ok (so far). Though I know, some
> people having issue with it. Do you know if
> DBD::Oralce was tested for 64 bit machine? and if it
> was, then what was the out come?
> Thank you,
> Partha Dhar
>=20
> --- Jim Brandt wrote:
>=20
> > We've recently been debugging an issue with the
> > Oracle 10g client=20
> > install that basically relates back to permissions
> > on the client=20
> > libraries. In a nutshell, we found that our normal
> > procedure of:
> >=20
> > * run client install
> > * run oracle permissions repair script
> >=20
> > didn't actually fully repair the permissions. We're
> > still looking into=20
> > the details, but the solution was to make sure the
> > user trying to run=20
> > the DBD::Oracle install has permission to read all
> > of the client=20
> > libraries. We did all (or nearly all) files because
> > it was too difficult=20
> > to narrow down exactly which ones were wrong on a
> > case by case basis.
> >=20
> >=20
> > a_arya2000 wrote:
> > > The oracle client version is 10
> > > Thank you,
> > > Arya
> > > --- Jim Brandt wrote:
> > >=20
> > >> What version of the Oracle client do you have
> > >> installed?
> > >>
> > >>
> > >> a_arya2000 wrote:
> > >>> Hi, I am trying to install DBD::Oracle in a
> > Linux
> > >> 64
> > >>> bit machine but facing problem and not sure what
> > i
> > >> am
> > >>> doing wrong or if something wrong with oracle
> > >> client
> > >>> installation. make looks ok, but when I run make
> > >> test
> > >>> I get this.=20
> > >>> ---------------------------
> > >>> t/01base................Failed to load Oracle
> > >>> extension and/or shared libraries:
> > >>> install_driver(Oracle) failed: Can't load
> > >>>
> > >
> >
> '/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
> > >>> for module DBD::Oracle:
> > >>>
> > >
> >
> /usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.=
so:
> > >>> cannot open shared object file: No such file or
> > >>> directory at
> > >>>
> > >
> >
> /usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
> > >>> line 229.
> > >>> at (eval 3) line 3
> > >>> Compilation failed in require at (eval 3) line
> > 3.
> > >>> Perhaps a required shared library or dll isn't
> > >>> installed where expected
> > >>> .........
> > >>> .........
> > >>> -----------------------------------------
> > >>>
> > >>> For rest of the tests I get almost same output.
> > >> Also I
> > >>> checked, Oracle.so in that give directory. I am
> > >>> wondering what causing this problem? One thing I
> > >>> should note though, oracle client that is
> > >> installed in
> > >>> this machine, is the basic installation not the
> > >> full
> > >>> installation. Could it be the reason? Any one
> > else
> > >>> experience this issue before? I am kind of suck
> > on
> > >>> that one, any help will be appreciated. Thank
> > you
> > >>>
> > >>>
> > >>>
> > >>> =20
> > >>>
> > >
> >
> ____________________________________________________________ _____________=
___________
> > >>> Be a better Globetrotter. Get better travel
> > >> answers from someone who knows. Yahoo! Answers -
> > >> Check it out.
> > >
> >
> http://answers.yahoo.com/dir/?link=3Dlist&sid=3D396545469
> > >> --=20
> > >> Jim Brandt
> > >> Administrative Computing Services
> > >> University at Buffalo
> > >>
> > >>
> > >=20
> > >=20
> > >=20
> > > =20
> > >
> >
> ____________________________________________________________ _____________=
___________
> > > Moody friends. Drama queens. Your life? Nope! -
> > their life, your story. Play Sims Stories at Yahoo!
> > Games.
> > > http://sims.yahoo.com/ =20
> >=20
> > --=20
> > Jim Brandt
> > Administrative Computing Services
> > University at Buffalo
> >=20
> >=20
>=20
>=20
>=20
> =20
> ____________________________________________________________ _____________=
___________
> Pinpoint customers who are looking for what you sell.=20
> http://searchmarketing.yahoo.com/

____________________________________________________________ _____
See what you=92re getting into=85before you go there
http://newlivehotmail.com/?ocid=3DTXT_TAGHM_migration_HM_vir al_preview_0507=

Re: DBD::Oracle in 64 bit Linux

am 06.08.2007 14:21:04 von cbrandt

We just did 32-bit, so I'm not sure about 64-bit. I was editing my
Makefile as well until someone on the list pointed out that:

perl Makefile.PL -r=build32

generated the correct Makefile for 32-bit. Maybe there is a similar flag
for 64? Although it was my impression that 64 was now the default WRT to
the Oracle client libraries since they are 'lib' and the 32-bit are 'lib32'.

The last bit that we're still looking into, and that caused quite a bit
of confusion for us, is that it appears Oracle patched the permissions
repair script (changePerm.sh) between version 10.2.0.1 and 10.2.0.3 to
fix some bugs. The original version, which we had on one machine,
relaxed permissions on rdbms/lib32, but on another machine that was
patched, it didn't. So I could get things running on one machine, but
not another. We ended up modifying permissions manually while we looking
into these issues with Oracle.

Jim

Craig Metzer wrote:
>
> I had a similar problem installing DBD::ODBC and DBD::Oracle on
> 64-bit RedHat. My Perl build was a 64-bit. I received the same
> error as you did. In my case Makefile.PL was writing the path to my
> 32-bit libraries to my makefile. I had to edit it replacing the
> ../lib/.. paths with ../lib64/.. After that, it built and tested
> just fine.
>
>
> Best of luck, Craig
>
>
>
> ----------------------------------------
>> Date: Fri, 3 Aug 2007 16:01:58 -0700 From: a_arya2000@yahoo.com
>> Subject: Re: DBD::Oracle in 64 bit Linux To: cbrandt@buffalo.edu
>> CC: dbi-users@perl.org
>>
>> Hello Jim, Thank you very much for the information. Actually, I was
>> unaware of this permission issue. Is the permission issue a
>> general issue or specific to 64 bit installation? Because I did
>> compile and installed DBD::Oracle for oracle 10 client in 32 bit
>> Linux machine, which looks ok (so far). Though I know, some people
>> having issue with it. Do you know if DBD::Oralce was tested for
>> 64 bit machine? and if it was, then what was the out come? Thank
>> you, Partha Dhar
>>
>> --- Jim Brandt wrote:
>>
>>> We've recently been debugging an issue with the Oracle 10g client
>>> install that basically relates back to permissions on the client
>>> libraries. In a nutshell, we found that our normal procedure of:
>>>
>>>
>>> * run client install * run oracle permissions repair script
>>>
>>> didn't actually fully repair the permissions. We're still looking
>>> into the details, but the solution was to make sure the user
>>> trying to run the DBD::Oracle install has permission to read all
>>> of the client libraries. We did all (or nearly all) files because
>>> it was too difficult to narrow down exactly which ones were
>>> wrong on a case by case basis.
>>>
>>>
>>> a_arya2000 wrote:
>>>> The oracle client version is 10 Thank you, Arya --- Jim Brandt
>>>> wrote:
>>>>
>>>>> What version of the Oracle client do you have installed?
>>>>>
>>>>>
>>>>> a_arya2000 wrote:
>>>>>> Hi, I am trying to install DBD::Oracle in a
>>> Linux
>>>>> 64
>>>>>> bit machine but facing problem and not sure what
>>> i
>>>>> am
>>>>>> doing wrong or if something wrong with oracle
>>>>> client
>>>>>> installation. make looks ok, but when I run make
>>>>> test
>>>>>> I get this. ---------------------------
>>>>>> t/01base................Failed to load Oracle extension
>>>>>> and/or shared libraries: install_driver(Oracle) failed:
>>>>>> Can't load
>>>>>>
>> '/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
>>
>>>>>> for module DBD::Oracle:
>>>>>>
>> /usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
>>
>>>>>> cannot open shared object file: No such file or directory
>>>>>> at
>>>>>>
>> /usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
>>
>>>>>> line 229. at (eval 3) line 3 Compilation failed in require
>>>>>> at (eval 3) line
>>> 3.
>>>>>> Perhaps a required shared library or dll isn't installed
>>>>>> where expected ......... .........
>>>>>> -----------------------------------------
>>>>>>
>>>>>> For rest of the tests I get almost same output.
>>>>> Also I
>>>>>> checked, Oracle.so in that give directory. I am wondering
>>>>>> what causing this problem? One thing I should note though,
>>>>>> oracle client that is
>>>>> installed in
>>>>>> this machine, is the basic installation not the
>>>>> full
>>>>>> installation. Could it be the reason? Any one
>>> else
>>>>>> experience this issue before? I am kind of suck
>>> on
>>>>>> that one, any help will be appreciated. Thank
>>> you
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>> ____________________________________________________________ ________________________
>>
>>>>>> Be a better Globetrotter. Get better travel
>>>>> answers from someone who knows. Yahoo! Answers - Check it
>>>>> out.
>> http://answers.yahoo.com/dir/?link=list&sid=396545469
>>>>> -- Jim Brandt Administrative Computing Services University at
>>>>> Buffalo
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>> ____________________________________________________________ ________________________
>>
>>>> Moody friends. Drama queens. Your life? Nope! -
>>> their life, your story. Play Sims Stories at Yahoo! Games.
>>>> http://sims.yahoo.com/
>>> -- Jim Brandt Administrative Computing Services University at
>>> Buffalo
>>>
>>>
>>
>>
>>
>> ____________________________________________________________ ________________________
>> Pinpoint customers who are looking for what you sell.
>> http://searchmarketing.yahoo.com/
>
> ____________________________________________________________ _____ See
> what you’re getting into…before you go there
> http://newlivehotmail.com/?ocid=TXT_TAGHM_migration_HM_viral _preview_0507
>
--
Jim Brandt
Administrative Computing Services
University at Buffalo

Re: DBD::Oracle in 64 bit Linux

am 07.08.2007 19:04:43 von a_arya2000

Hello Jim,
There is indeed an option –r=build64. However, when I
used this option, DBD::Oracle doesn’t compline
properly, I got something like “lclntsh file not found
(if I remember it correctly).

Hi Craig, I edited the Makefile and replaced it with
lib64 path, in fact without this change, it won’t even
compile. However, I have 32-bit perl. So I am
wondering, if this could the reason. Do I need to have
64 bit perl to compile DBD::Oracle in 64 bit machine?.
Thanks,
Arya

--- Jim Brandt wrote:

> We just did 32-bit, so I'm not sure about 64-bit. I
> was editing my
> Makefile as well until someone on the list pointed
> out that:
>
> perl Makefile.PL -r=build32
>
> generated the correct Makefile for 32-bit. Maybe
> there is a similar flag
> for 64? Although it was my impression that 64 was
> now the default WRT to
> the Oracle client libraries since they are 'lib' and
> the 32-bit are 'lib32'.
>
> The last bit that we're still looking into, and that
> caused quite a bit
> of confusion for us, is that it appears Oracle
> patched the permissions
> repair script (changePerm.sh) between version
> 10.2.0.1 and 10.2.0.3 to
> fix some bugs. The original version, which we had on
> one machine,
> relaxed permissions on rdbms/lib32, but on another
> machine that was
> patched, it didn't. So I could get things running on
> one machine, but
> not another. We ended up modifying permissions
> manually while we looking
> into these issues with Oracle.
>
> Jim
>
> Craig Metzer wrote:
> >
> > I had a similar problem installing DBD::ODBC and
> DBD::Oracle on
> > 64-bit RedHat. My Perl build was a 64-bit. I
> received the same
> > error as you did. In my case Makefile.PL was
> writing the path to my
> > 32-bit libraries to my makefile. I had to edit it
> replacing the
> > ../lib/.. paths with ../lib64/.. After that, it
> built and tested
> > just fine.
> >
> >
> > Best of luck, Craig
> >
> >
> >
> > ----------------------------------------
> >> Date: Fri, 3 Aug 2007 16:01:58 -0700 From:
> a_arya2000@yahoo.com
> >> Subject: Re: DBD::Oracle in 64 bit Linux To:
> cbrandt@buffalo.edu
> >> CC: dbi-users@perl.org
> >>
> >> Hello Jim, Thank you very much for the
> information. Actually, I was
> >> unaware of this permission issue. Is the
> permission issue a
> >> general issue or specific to 64 bit installation?
> Because I did
> >> compile and installed DBD::Oracle for oracle 10
> client in 32 bit
> >> Linux machine, which looks ok (so far). Though I
> know, some people
> >> having issue with it. Do you know if
> DBD::Oralce was tested for
> >> 64 bit machine? and if it was, then what was the
> out come? Thank
> >> you, Partha Dhar
> >>
> >> --- Jim Brandt wrote:
> >>
> >>> We've recently been debugging an issue with the
> Oracle 10g client
> >>> install that basically relates back to
> permissions on the client
> >>> libraries. In a nutshell, we found that our
> normal procedure of:
> >>>
> >>>
> >>> * run client install * run oracle permissions
> repair script
> >>>
> >>> didn't actually fully repair the permissions.
> We're still looking
> >>> into the details, but the solution was to make
> sure the user
> >>> trying to run the DBD::Oracle install has
> permission to read all
> >>> of the client libraries. We did all (or nearly
> all) files because
> >>> it was too difficult to narrow down exactly
> which ones were
> >>> wrong on a case by case basis.
> >>>
> >>>
> >>> a_arya2000 wrote:
> >>>> The oracle client version is 10 Thank you, Arya
> --- Jim Brandt
> >>>> wrote:
> >>>>
> >>>>> What version of the Oracle client do you have
> installed?
> >>>>>
> >>>>>
> >>>>> a_arya2000 wrote:
> >>>>>> Hi, I am trying to install DBD::Oracle in a
> >>> Linux
> >>>>> 64
> >>>>>> bit machine but facing problem and not sure
> what
> >>> i
> >>>>> am
> >>>>>> doing wrong or if something wrong with oracle
> >>>>> client
> >>>>>> installation. make looks ok, but when I run
> make
> >>>>> test
> >>>>>> I get this. ---------------------------
> >>>>>> t/01base................Failed to load Oracle
> extension
> >>>>>> and/or shared libraries:
> install_driver(Oracle) failed:
> >>>>>> Can't load
> >>>>>>
> >>
>
'/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
> >>
> >>>>>> for module DBD::Oracle:
> >>>>>>
> >>
>
/usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
> >>
> >>>>>> cannot open shared object file: No such file
> or directory
> >>>>>> at
> >>>>>>
> >>
>
/usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
> >>
> >>>>>> line 229. at (eval 3) line 3 Compilation
> failed in require
> >>>>>> at (eval 3) line
> >>> 3.
> >>>>>> Perhaps a required shared library or dll
> isn't installed
> >>>>>> where expected ......... .........
> >>>>>> -----------------------------------------
> >>>>>>
> >>>>>> For rest of the tests I get almost same
> output.
> >>>>> Also I
> >>>>>> checked, Oracle.so in that give directory. I
> am wondering
> >>>>>> what causing this problem? One thing I should
> note though,
> >>>>>> oracle client that is
> >>>>> installed in
> >>>>>> this machine, is the basic installation not
> the
> >>>>> full
> >>>>>> installation. Could it be the reason? Any one
> >>> else
> >>>>>> experience this issue before? I am kind of
> suck
> >>> on
> >>>>>> that one, any help will be appreciated. Thank
> >>> you
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>
>
____________________________________________________________ ________________________
> >>
> >>>>>> Be a better Globetrotter. Get better travel
> >>>>> answers from someone who knows. Yahoo! Answers
> - Check it
> >>>>> out.
> >>
>
http://answers.yahoo.com/dir/?link=list&sid=396545469
> >>>>> -- Jim Brandt Administrative Computing
> Services University at
> >>>>> Buffalo
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>
>
____________________________________________________________ ________________________
> >>
> >>>> Moody friends. Drama queens. Your life? Nope! -
> >>> their life, your story. Play Sims Stories at
> Yahoo! Games.
> >>>> http://sims.yahoo.com/
>
=== message truncated ===




____________________________________________________________ ________________________
Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/

Re: DBD::Oracle in 64 bit Linux

am 08.08.2007 14:00:03 von cbrandt

a_arya2000 wrote:
> Hello Jim,
> There is indeed an option –r=build64. However, when I
> used this option, DBD::Oracle doesn’t compline
> properly, I got something like “lclntsh file not found
> (if I remember it correctly).
>

Probably libclntsh.so. That's one of the libraries that pops up when you
have permission issues (reported as file not found). It sounds like you
need to look at the directories you're pointing to with ORACLE_HOME and
make sure you have at least read access to all of them.

> Hi Craig, I edited the Makefile and replaced it with
> lib64 path, in fact without this change, it won’t even
> compile. However, I have 32-bit perl. So I am
> wondering, if this could the reason. Do I need to have
> 64 bit perl to compile DBD::Oracle in 64 bit machine?.
> Thanks,
> Arya
>
> --- Jim Brandt wrote:
>
>> We just did 32-bit, so I'm not sure about 64-bit. I
>> was editing my
>> Makefile as well until someone on the list pointed
>> out that:
>>
>> perl Makefile.PL -r=build32
>>
>> generated the correct Makefile for 32-bit. Maybe
>> there is a similar flag
>> for 64? Although it was my impression that 64 was
>> now the default WRT to
>> the Oracle client libraries since they are 'lib' and
>> the 32-bit are 'lib32'.
>>
>> The last bit that we're still looking into, and that
>> caused quite a bit
>> of confusion for us, is that it appears Oracle
>> patched the permissions
>> repair script (changePerm.sh) between version
>> 10.2.0.1 and 10.2.0.3 to
>> fix some bugs. The original version, which we had on
>> one machine,
>> relaxed permissions on rdbms/lib32, but on another
>> machine that was
>> patched, it didn't. So I could get things running on
>> one machine, but
>> not another. We ended up modifying permissions
>> manually while we looking
>> into these issues with Oracle.
>>
>> Jim
>>
>> Craig Metzer wrote:
>>> I had a similar problem installing DBD::ODBC and
>> DBD::Oracle on
>>> 64-bit RedHat. My Perl build was a 64-bit. I
>> received the same
>>> error as you did. In my case Makefile.PL was
>> writing the path to my
>>> 32-bit libraries to my makefile. I had to edit it
>> replacing the
>>> ../lib/.. paths with ../lib64/.. After that, it
>> built and tested
>>> just fine.
>>>
>>>
>>> Best of luck, Craig
>>>
>>>
>>>
>>> ----------------------------------------
>>>> Date: Fri, 3 Aug 2007 16:01:58 -0700 From:
>> a_arya2000@yahoo.com
>>>> Subject: Re: DBD::Oracle in 64 bit Linux To:
>> cbrandt@buffalo.edu
>>>> CC: dbi-users@perl.org
>>>>
>>>> Hello Jim, Thank you very much for the
>> information. Actually, I was
>>>> unaware of this permission issue. Is the
>> permission issue a
>>>> general issue or specific to 64 bit installation?
>> Because I did
>>>> compile and installed DBD::Oracle for oracle 10
>> client in 32 bit
>>>> Linux machine, which looks ok (so far). Though I
>> know, some people
>>>> having issue with it. Do you know if
>> DBD::Oralce was tested for
>>>> 64 bit machine? and if it was, then what was the
>> out come? Thank
>>>> you, Partha Dhar
>>>>
>>>> --- Jim Brandt wrote:
>>>>
>>>>> We've recently been debugging an issue with the
>> Oracle 10g client
>>>>> install that basically relates back to
>> permissions on the client
>>>>> libraries. In a nutshell, we found that our
>> normal procedure of:
>>>>>
>>>>> * run client install * run oracle permissions
>> repair script
>>>>> didn't actually fully repair the permissions.
>> We're still looking
>>>>> into the details, but the solution was to make
>> sure the user
>>>>> trying to run the DBD::Oracle install has
>> permission to read all
>>>>> of the client libraries. We did all (or nearly
>> all) files because
>>>>> it was too difficult to narrow down exactly
>> which ones were
>>>>> wrong on a case by case basis.
>>>>>
>>>>>
>>>>> a_arya2000 wrote:
>>>>>> The oracle client version is 10 Thank you, Arya
>> --- Jim Brandt
>>>>>> wrote:
>>>>>>
>>>>>>> What version of the Oracle client do you have
>> installed?
>>>>>>>
>>>>>>> a_arya2000 wrote:
>>>>>>>> Hi, I am trying to install DBD::Oracle in a
>>>>> Linux
>>>>>>> 64
>>>>>>>> bit machine but facing problem and not sure
>> what
>>>>> i
>>>>>>> am
>>>>>>>> doing wrong or if something wrong with oracle
>>>>>>> client
>>>>>>>> installation. make looks ok, but when I run
>> make
>>>>>>> test
>>>>>>>> I get this. ---------------------------
>>>>>>>> t/01base................Failed to load Oracle
>> extension
>>>>>>>> and/or shared libraries:
>> install_driver(Oracle) failed:
>>>>>>>> Can't load
>>>>>>>>
> '/usr/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle /Oracle.so'
>>>>>>>> for module DBD::Oracle:
>>>>>>>>
> /usr/Linux/perl/src/src/DBD-Oracle-1.19/blib/arch/auto/DBD/O racle/Oracle.so:
>>>>>>>> cannot open shared object file: No such file
>> or directory
>>>>>>>> at
>>>>>>>>
> /usr/perl/perl-5.8.3/lib/5.8.3/i386-linux-thread-multi/DynaL oader.pm
>>>>>>>> line 229. at (eval 3) line 3 Compilation
>> failed in require
>>>>>>>> at (eval 3) line
>>>>> 3.
>>>>>>>> Perhaps a required shared library or dll
>> isn't installed
>>>>>>>> where expected ......... .........
>>>>>>>> -----------------------------------------
>>>>>>>>
>>>>>>>> For rest of the tests I get almost same
>> output.
>>>>>>> Also I
>>>>>>>> checked, Oracle.so in that give directory. I
>> am wondering
>>>>>>>> what causing this problem? One thing I should
>> note though,
>>>>>>>> oracle client that is
>>>>>>> installed in
>>>>>>>> this machine, is the basic installation not
>> the
>>>>>>> full
>>>>>>>> installation. Could it be the reason? Any one
>>>>> else
>>>>>>>> experience this issue before? I am kind of
>> suck
>>>>> on
>>>>>>>> that one, any help will be appreciated. Thank
>>>>> you
>>>>>>>>
>>>>>>>>
>>>>>>>>
> ____________________________________________________________ ________________________
>>>>>>>> Be a better Globetrotter. Get better travel
>>>>>>> answers from someone who knows. Yahoo! Answers
>> - Check it
>>>>>>> out.
> http://answers.yahoo.com/dir/?link=list&sid=396545469
>>>>>>> -- Jim Brandt Administrative Computing
>> Services University at
>>>>>>> Buffalo
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
> ____________________________________________________________ ________________________
>>>>>> Moody friends. Drama queens. Your life? Nope! -
>>>>> their life, your story. Play Sims Stories at
>> Yahoo! Games.
>>>>>> http://sims.yahoo.com/
> === message truncated ===
>
>
>
>
> ____________________________________________________________ ________________________
> Need a vacation? Get great deals
> to amazing places on Yahoo! Travel.
> http://travel.yahoo.com/

--
Jim Brandt
Administrative Computing Services
University at Buffalo