PERL Modules - Problem building DBD::Oracle on 64 bit solaris

Author

Problem building DBD::Oracle on 64 bit solaris

Yuri Shtil

2005-04-13, 8:55 pm

I've tried to build this module using Oracle 10 for solaris 64 bit. The
problem is that the perl I have is 32 bit, so it does not like 64 bit shared
libraries. I could not find 32 bit libraries in the Oracle distribution.
There are some, but not all. To be honest, I have not installed Oracle, I
just perused the cpio file I downloaded and extracted files needed to build
the module.
I find it odd, that in order to build the module I need to install the whole
thing. I only need to access a DB from the host in question, not use the DB
on the host.
Am I doing something wrong? Do I need to build 64 bit perl?

Sybrand Bakker

2005-04-13, 8:55 pm

On Wed, 13 Apr 2005 13:51:22 -0700, "Yuri Shtil" <yshtil@synopsys.com>
wrote:

>Am I doing something wrong? Do I need to build 64 bit perl?

Oracle comes with perl. And what's more: it actually works!

--
Sybrand Bakker, Senior Oracle DBA

Andy Hassall

2005-04-13, 8:55 pm

On Wed, 13 Apr 2005 22:57:01 +0200, Sybrand Bakker <postbus@sybrandb.demon.nl>
wrote:

>On Wed, 13 Apr 2005 13:51:22 -0700, "Yuri Shtil" <yshtil@synopsys.com>
>wrote:
>
>
>Oracle comes with perl. And what's more: it actually works!

Although it's a 4-year old version of Perl (5.6.1, current is 5.8.6) and a
similarly old DBD-Oracle (1.12 vs 1.16 - lots of improvements since then).

--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Yuri Shtil

2005-04-13, 8:55 pm

"Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message
news:6s1r5156eloa2r9m3i9pag0q4mvbphl85t@
4ax.com...
> On Wed, 13 Apr 2005 13:51:22 -0700, "Yuri Shtil" <yshtil@synopsys.com>
> wrote:
>
>
> Oracle comes with perl. And what's more: it actually works!
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Well, I'd like to believe you, however you did not answer my questions. Do
I have to install Oracle in order to use DBD::Oracle to access DB on other
hosts?
I already have a perl with a lot of modules I need for other reasons. Do I
have to replace my perl with the one that comes with Oracle?

Andy Hassall

2005-04-13, 8:55 pm

On Wed, 13 Apr 2005 13:51:22 -0700, "Yuri Shtil" <yshtil@synopsys.com> wrote:

>I've tried to build this module using Oracle 10 for solaris 64 bit. The
>problem is that the perl I have is 32 bit, so it does not like 64 bit shared
>libraries. I could not find 32 bit libraries in the Oracle distribution.
>There are some, but not all. To be honest, I have not installed Oracle, I
>just perused the cpio file I downloaded and extracted files needed to build
>the module.
>I find it odd, that in order to build the module I need to install the whole
>thing. I only need to access a DB from the host in question, not use the DB
>on the host.

Recent versions of DBD::Oracle (well - just the very latest - 1.16) can be
built against the Oracle Instant Client (SDK version).

>Am I doing something wrong? Do I need to build 64 bit perl?

Not sure - but there is a 32-bit Oracle Instant Client for Solaris.

http://www.oracle.com/technology/so...ient/index.html

Given that there isn't a full Oracle installer for Solaris 32-bit this is
probably the best bet.

Search for "dbi-users" on Google or subscribe to; there have definitely been
some posts on the mailing list on how to build against Instant Client - I don't
recall if it works out-of-the-box yet.

--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Sybrand Bakker

2005-04-20, 3:56 pm

Andy Hassall

2005-04-20, 3:56 pm

Sponsored Links