DBD::Oracle using 64bit oracle libraries

------_=_NextPart_001_01C7BFFB.9F804F52
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

=20

I am trying to use DBD ::Oracle for a software package called OTRS. A =
problem I am running into is that perl seems to be trying to use the 64 =
bit library file called libclntsh.so.10.1 located on my computer in the =
directory /u01/app/oracle/product/10.1.0/db_3/lib/ and I need it to use =
the 32 bit library file located in =
/u01/app/oracle/product/10.1.0/db_3/lib32

=20

Does anyone know how I go about changing where it looks for the =
libclntsh.so file?

=20

Thanks for any help provided.

=20

Dan King
Software Developer
Canadian Resident Matching Service
613.237.0075 ext. 241
(Toll free) 877.CARMS.42
171 Nepean Street, Suite 300
Ottawa, ON, CAN K2P 0B4
www.carms.ca =20

------------------------------------------------------------ -------------=
-----------

This e-mail message, including any attachments, is for the sole use of =
the intended recipients and may contain confidential and or privileged =
information. If you are not the intended recipient or this information =
has been forwarded in error, please contact the sender by reply e-mail =
and destroy copies of the original message. Ce message (incluant toute =
pi=E8ce jointe) s'adresse uniquement au(x) destinataire(s) pr=E9vu(s) ou =
=E0 une personne autoris=E9e =E0 le recevoir en son (leur) nom. Il =
pourrait contenir des renseignements confidentiels ou prot=E9g=E9s. Si =
vous l'avez re=E7u par erreur, nous vous prions d'en informer l'auteur =
dans les meilleurs d=E9lais, de ne pas divulguer son contenu et de le =
supprimer de votre syst=E8me. Merci.

=20


------_=_NextPart_001_01C7BFFB.9F804F52--

Re: DBD::Oracle using 64bit oracle libraries

common problem one I will fix as soon as I get a 64 bit box

here is some readme stuff the might pooint you in the right direction

In general compiling DBD:Oracle for 64 bit machines has been a hit or miss
operation.
The main thing to remember is you will have to compile using 32 bit Perl and
compile DBD::Oracle against a 32bit client
which sort of defeats the purpose of having a 64bit box.
So until 64bit Perl comes out we will be posing in this README any success
stories we have come across


Source:Tom Reinertson
Platform:Amd64
OS:Gentoo-amd64

The following instructions work for dbd::oracle 1.19 on a gentoo-amd64
installation.

1) install the oracle libraries

Strictly speaking you only need dev-db/oracle-instantclient-basic
for dbd::oracle, but i always like to have sql*plus lying around,
which requires the basic package, so i just install sql*plus.

emerge dev-db/oracle-instantclient-sqlplus which also pulls in
dev-db/oracle-instantclient-basic. these packages are fetch
restricted so you will be required to follow the download instructions.
following these instructions, you should have retrieved these packages:

instantclient-basic-linux-x86-64-10.2.0.3-20070103.zip
instantclient-sdk-linux-x86-64-10.2.0.3-20070103.zip
instantclient-sqlplus-linux-x86-64-10.2.0.3-20070103.zip

now move them into the /usr/portage/distfiles directory.

you should now be able to emerge dev-db/oracle-instantclient-sqlplus.

2) install DBD::Oracle

issue the command:

perl -MCPAN -e'install DBD::Oracle'

this fails with the following error:

x86_64-pc-linux-gnu-gcc: unrecognized option '-wchar-stdc++'
x86_64-pc-linux-gnu-gcc: unrecognized option '-cxxlib-gcc'
cc1: error: /ee/dev/bastring.h: No such file or directory

find the offending files in your cpan directory:
{~/.cpan/build/DBD-Oracle-1.19} grep -lr cxxlib *
Makefile
blib/arch/auto/DBD/Oracle/mk.pm
mk.pm

edit these files and remove the two invalid options and the include of
bastring.h.

now build the module:

perl Makefile.PL -l
make
# make test generates lots of errors
make test
make install

you should now be ready to run.



----- Original Message -----
From: "Dan King"
To:
Sent: Friday, July 06, 2007 2:29 PM
Subject: DBD::Oracle using 64bit oracle libraries


Hi,



I am trying to use DBD ::Oracle for a software package called OTRS. A
problem I am running into is that perl seems to be trying to use the 64 bit
library file called libclntsh.so.10.1 located on my computer in the
directory /u01/app/oracle/product/10.1.0/db_3/lib/ and I need it to use the
32 bit library file located in /u01/app/oracle/product/10.1.0/db_3/lib32



Does anyone know how I go about changing where it looks for the libclntsh.so
file?



Thanks for any help provided.



Dan King
Software Developer
Canadian Resident Matching Service
613.237.0075 ext. 241
(Toll free) 877.CARMS.42
171 Nepean Street, Suite 300
Ottawa, ON, CAN K2P 0B4
www.carms.ca

------------------------------------------------------------ ------------------------

This e-mail message, including any attachments, is for the sole use of the
intended recipients and may contain confidential and or privileged
information. If you are not the intended recipient or this information has
been forwarded in error, please contact the sender by reply e-mail and
destroy copies of the original message. Ce message (incluant toute pièce
jointe) s'adresse uniquement au(x) destinataire(s) prévu(s) ou à une
personne autorisée à le recevoir en son (leur) nom. Il pourrait contenir des
renseignements confidentiels ou protégés. Si vous l'avez reçu par erreur,
nous vous prions d'en informer l'auteur dans les meilleurs délais, de ne pas
divulguer son contenu et de le supprimer de votre système. Merci.