Now I am trying to install DBD::Oracle 1.16 version to Oracle 10.2.0.1.0_64 db
server.
Since I am using Perl 32 bit version 5.61 and I do not have permissions to
upgrade it to 64 bit,
IS THERE A WORKAROUND to get this installed with 32 bit perl?
Initially I got the following error while running 'make'
-------------------------------
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/opt/oracle/product/10.2.0.1.0_64/lib32:/opt/oracle/product/10.2.0.1.0_64/rdbms/lib32"
cc -G Oracle.o dbdimp.o oci8.o -xarch=v9
-L/opt/oracle/product/10.2.0.1.0_64/lib/
-L/opt/oracle/product/10.2.0.1.0_64/rdbms/lib/ -lclntsh `cat
/opt/oracle/product/10.2.0.1.0_64/lib/sysliblist`
-R/opt/oracle/product/10.2.0.1.0_64/lib -laio -lposix4 -lkstat -lm -lthread
-lpthread -o blib/arch/auto/DBD/Oracle/Oracle.so
ld: fatal: file Oracle.o: wrong ELF class: ELFCLASS32
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
*** Error code 1
make: Fatal error: Command failed for target
`blib/arch/auto/DBD/Oracle/Oracle.so'
-------------------------------
I got around the above problem by removing -xrach=v9 from all make files. It
continued few steps further and is now giving
-------------------------------
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/opt/oracle/product/10.2.0.1.0_64/lib32:/opt/oracle/product/10.2.0.1.0_64/rdbms/lib32"
cc -G Oracle.o dbdimp.o oci8.o -L/opt/oracle/product/10.2.0.1.0_64/lib/
-L/opt/oracle/product/10.2.0.1.0_64/rdbms/lib/ -lclntsh `cat
/opt/oracle/product/10.2.0.1.0_64/lib/sysliblist`
-R/opt/oracle/product/10.2.0.1.0_64/lib -laio -lposix4 -lkstat -lm -lthread
-lpthread -o blib/arch/auto/DBD/Oracle/Oracle.so
ld: fatal: file /opt/oracle/product/10.2.0.1.0_64/lib//libclntsh.so: wrong ELF
class: ELFCLASS64
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
*** Error code 1
make: Fatal error: Command failed for target
`blib/arch/auto/DBD/Oracle/Oracle.so'
-------------------------------
On Fri, 06 Jan 2006 Matthew Dougerty wrote :
>You need Oracle DBD. If it's there there will be per5~/DBD/Oracle.pm and an
>Oracle directory.
>
>On 5 Jan 2006 19:01:35 -0000, Sunil A V wrote
> >
> > Hi,
> >
> > I am trying this combination:
> > perl: v5.61
> > DBI: 1.25
> > Oracle: 10g
> > OS: Solaris Unix
> > The directory /home/me/perlmods contains DBI.pm, DBI dir, DBD dir,
> > Bundle, etc
> >
> > In my perl program I am using
> > BEGIN {unshift(@INC,'/home/me/perlmods')}
> > use DBI;
> >
> > my $dbh = DBI->connect('DBI:Oracle','sid','user','pass') || die
> > "msg"; ...
> >
> > The program terminates at the connect line and does not even print
> > the msg in the die statement.
> >
> > Is version a problem here OR is perl not able to find DBI OR should
> > i install DBD:Oracle as well? I am just using DBI for basic sql
> > fetch in preparedstatements.
> >
> > Thanks,
> > Sunil
>
>
>Matthew Dougherty
>[EMAIL PROTECTED]
>973-325-8556
>AIM: mattsei
>
