Filewatcher File Search File Search
Content Search
» » » » DBD-Oracle-1.44.tar.gz » Content »
pkg://DBD-Oracle-1.44.tar.gz:466821/DBD-Oracle-1.44/  info  downloads


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

-------- Original Message --------

Subject:   Building 32bit DBD::Oracle against 64bit Oracle
From:  Dennis Reso
Date:   7/9/2008 5:44 PM
Priority:   Normal 

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

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

Tried the following solution, widely posted, without success:

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

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

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

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

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

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

Probably also fixed in some patchset newer than

Dennis Reso <dreso (at)> 

-------- Original Message --------

Subject:   DBD::Oracle 64-bit success story 
From:   H.Merijn Brand
Date:   On Mon, 14 Apr 2008 09:48:41
Priority:   Normal 

I finally got round trying Oracle Instant Client on Linux with no
Oracle installed, connecting to a 64bit Oracle on HP-UX
11.11/64. I had to do some fiddling with Makefile.PL (see bottom).
Sorry for this being long. Feel free to mold it into anything useful.

1. Before you start on DBD::Oracle, make sure DBD::ODBC works. That will
   assure your DSN works. Install unixODBC before anything else.

2. Assuming you've got OIC from the rpm's, you will have it here:


3. for the 64 bit clienat we have these rpm   
      and to add to the confusement, they install to

4. To make DBD::ODBC work, I had to create a tnsnames.ora, and I chose


   /usr/lib/oracle/ > cat sqlnet.ora
   /usr/lib/oracle/ > cat tnsnames.ora
   ODBCO = (
       ( ADDRESS =
     ( PROTOCOL        = TCP           )
     ( PORT            = 1521          )
     ( HOST            = rhost         )
       ( SERVICE_NAME      = odbctest      )
   /usr/lib/oracle/ >

   Real world example changed to hide the obvious. Important bits are
   "ODBCO", which is the ODBC name, and it can be anything, as long as
   you use this in ORACLE_DSN too (please don't use whitespace, colons,
   semicolons and/or slashes. "rhost" is the hostname of where the DB
   is running, and "odbctest" is available on "rhost". To check that,
   run "lsnrctl services" on "rhost".
   Set the environment (TWO_TASK is not needed)
   > setenv LD_LIBRARY_PATH /usr/lib/oracle/
   > setenv TNS_ADMIN       /usr/lib/oracle/
   > setenv ORACLE_HOME     /usr/lib/oracle/
   > setenv ORACLE_DSN      dbi:Oracle:ODBCO

   Check if the connection works:
   > isql -v ODBCO

   And for Oracle:
   > sqlplus ORAUSER/ORAPASS@rhost/odbctest

   should both work

Note by JPS:

Merijn patched the trunk version of Makeifle.PL to account for the above it will be in release 1.22

-------- Original Message --------

Subject:   DBD::Oracle 64-bit success story 
From:   "QiangLi" <> 
Date:   Thu, March 6, 2008 5:25 pm 
Priority:   Normal 


thanks for maintaining DBD::Oracle. I have installed DBD::Oracle against 
  64-bit oracle 10g on a 64-bit solaris machine. maybe worth another 
entry for the README.64bit.txt file.

i am using gcc from sun freesoftware and also SUNWbinutils which 
contains the gas (gnu assembler)

here is the steps with comment:

# set install target
% /usr/perl5/5.8.4/bin/perlgcc Makefile.PL PREFIX=/var/tmp/lib

# since our perl is 32-bit, we can't build it against a 64bit oracle 
# edit Makefile and change reference to oracle's "lib/" to "lib32/"
% perl -pi -e 's/oracle_home\/lib/oracle_home\/lib32/g' Makefile
% perl -pi -e 's/oracle_home\/rdbms\/lib/oracle_home\/rdbms\/lib32/g' 

% make

# ignore error like  ORA-12162: TNS:net service name is incorrectly 
% make test

% make install

# does it work.
% perl -I'/var/tmp/lib/lib/site_perl/5.8.4/sun4-solaris-64int/' 
-MDBD::Oracle -e1



-------- Original Message --------
Subject:     Tip: Compiling 32bit modules against 64bit Oracle 10g on solaris
Date:     Thu, 1 Nov 2007 16:41:28 -0400
From:     Edgecombe, Jason <>
To:     <>
CC:     <>

Hi There,

I just wanted to thank both of you.

The tip from was the trick for getting
DBD::Oracle compiled in 32bit format against the Oracle 10g client on

Here was the command that worked:
  perl Makefile.PL -m $ORACLE_HOME/rdbms/demo/

Even though the tip was for aix, it fixed my build issue on solaris 9

I've been banging my head on this problem for a few days.


Jason Edgecombe
Solaris & Linux Administrator
Mosaic Computing Group, College of Engineering
Phone: (704) 687-3514

Source:Tom Reinertson

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:

	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 *

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

	now build the module:

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

	you should now be ready to run.

Results 1 - 1 of 1
Help - FTP Sites List - Software Dir.
Search over 15 billion files
© 1997-2017