Building 32bit DBD::Oracle against 64bit Oracle




Building DBD::Oracle v1.21 against Perl 5.8.5 Oracle 9.2.0.4 Solaris 8

Got the dreaded "wrong ELF class" when the Oracle.so ends up built
against the 64bit library instead of the one in $ORACLE_HOME/lib32.
Use 'dump -vL Oracle.so' to see the internalized RPATH definition.

Tried the following solution, widely posted, without success:

perl Makefile.PL -m $ORACLE_HOME/rdbms/demo/demo_rdbms32.mk

What worked for me (pass the LIBDIR to the Oracle make process):

export ORACLE_HOME=/apps/Oracle9.2.0.4
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32
perl -pi -e 's/CC=true/CC=true LIBDIR=lib32/' Makefile.PL
perl Makefile.PL -m $ORACLE_HOME/rdbms/demo/demo_rdbms32.mk
make

The LIBDIR= is defined in $ORACLE_HOME/rdbms/lib/env_rdbms.mk which
also includes a REDEFINES32= that overrides it, but is only used by
the $ORACLE_HOME/rdbms/lib/ins_rdbms.mk. Oracle bug?

Also repeated the same failure and success with
Oracle 9.2.0.8 Solaris 10
Oracle 10.2.0.3 Solaris 10

Seems fixed in demo_rdbms32.mk (no Makefile.PL edit needed ) as of
Oracle 10.2.0.4 Solaris 10

Probably also fixed in some patchset newer than 9.2.0.4.

--
Dennis Reso <dreso@xxxxxxxxxxx>

.



Relevant Pages

  • DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
    ... I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core ... Configuring DBD::Oracle for perl 5.008008 on solaris ... Oracle version 10.2.0.1 ... Failed 13/14 tests, 7.14% okay ...
    (perl.dbi.users)
  • Re: Future direction of Solaris?
    ... lead to an "enterprise OS", but to an outdated relic for stagnating ... Why Oracle Wants Solaris ... Well Dan Woods loves Solaris:) ...
    (comp.unix.solaris)
  • Warning: Do not use DISM on Solaris 8 or Solaris 9 pre-update 2
    ... The infodoc goes on to recommend that DISM not ... be used at all with Solaris 8, or Solaris 9 prior to update 2. ... this bug since it can be such a silent performance killer. ... If you see ora_dism_then Oracle 9i is making use of DISM ...
    (SunManagers)
  • Re: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
    ... Seems Solaris has been a problem for a while. ... Configuring DBD::Oracle for perl 5.008008 on solaris ... Oracle version 10.2.0.1 ... Failed 13/14 tests, 7.14% okay ...
    (perl.dbi.users)
  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... Thanks John, if you need me to run any debugging on Solaris or anything let ... the status after having connected to Oracle ... It is only suppose to run on solaris if the oci is gt 9. ... Database character set is not Unicode ...
    (perl.dbi.users)