Click here to get back home

DBD::Oracle issues
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
DBD::Oracle issues enzo.660 01-23-2007
Posted by enzo.660 on January 23, 2007, 7:16 pm
Please log in for more thread options

Hi..
I am a newbie trying to install DBD::Oracle on a linux box. The
Oracle server is on a remote host.

I read online that I would have to install the Oracle Instantclient to
be able to do so.

I followed the instructions on one site and did the following:

made a directory 'instantclient'
location: /home/ralf/instantclient

'instantclient' directory has the following files.
classes12.jar
libclntsh.so.10.1
libnnz10.so
libocci.so.10.1
libociei.so
libocijdbc10.so
ojdbc14.jar
genezi

I made another directory 'lib' inside 'instantclient' and moved all
the files into 'lib'

Then i created a symbolic link to libclntsh.so by doing the following
on command prompt.
$ ln -s libclntsh.so.10.1 libclntsh.so

Exported the ORACLE_HOME and LD_LIBRARY_PATH variables
$ export ORACLE_HOME=/home/ralf/instantclient
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Then I did the following:
cpan> install DBD::Oracle.

It failed saying:
-----------------------------------------------------------------------------------------------
Trying to find an ORACLE_HOME
Your LD_LIBRARY_PATH env var is set to ''

Warning: No success on command[/usr/bin/perl Makefile.PL]
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
Failed during this command:
PYTHIAN/DBD-Oracle-1.19.tar.gz : writemakefile NO
'/usr/bin/perl Makefile.PL' returned status 512
--------------------------------------------------------------------------------------------

Thanks!
enzo660


Posted by Andy on January 25, 2007, 10:27 am
Please log in for more thread options

The easiest way to install cpan perl modules is to use ppm (whcih comes
with the PERL interpreter). It will automatically download and install
any dependant modules that the module you are interested in needs.


On a computer with an internet connection, open a command line
interpreter window and key:

ppm

you should see:

PPM - Programmer's Package Manager version 3.4.
Copyright (c) 2001 ActiveState Software Inc. All Rights Reserved.

Entering interactive shell. Using Term::ReadLine::Perl as readline
library.

Type 'help' to get started.



At the ppm prompt, key "search" followed by the first part of the
module name you are looking for (do NOT include ::)

search dbd

ppm> search dbd
Searching in Active Repositories
1. DBD-ADO [2.96] DBD-ADO
2. DBD-AnyData [0.08] DBD-AnyData
3. DBD-Chart [0.80] DBD-Chart
4. DBD-CSV [0.22] DBD-CSV
5. DBD-Excel [0.06] DBD-Excel
6. DBD-File [0.35] DBD-File
7. DBD-LDAP [0.09] DBD-LDAP
8. DBD-Log [0.21] DBD-Log
9. DBD-Mimer [1.00] DBD-Mimer
10. DBD-Mock [1.34] DBD-Mock
11. DBD-Multiplex [1.99-1] DBD-Multiplex
12. DBD-mysql [3.0002] DBD-mysql
13. DBD-mysql-SimpleMySQL [0.5] DBD-mysql-SimpleMySQL
14. DBD-mysqlPP [0.04] DBD-mysqlPP
15. DBD-ODBC [1.13] DBD-ODBC
16. DBD-Oracle [1.17] DBD-Oracle
17. DBD-Ovrimos [0.12] DBD-Ovrimos
18. DBD-PgPP [0.05] DBD-PgPP
19. DBD-Redbase [0.21] DBD-Redbase
20. DBD-Sprite [0.59] DBD-Sprite
21. DBD-SQLite [1.13] DBD-SQLite
22. DBD-SQLite2 [0.33] DBD-SQLite2
23. DBD-SQLrelay [0.1] DBD-SQLrelay
24. DBD-Template [0.01] DBD-Template
---line 24/27 (any key for more, or q to quit)---

Look for the module you are interested in.
In this case, it is item 16 in the list.
The name that appears is the name you should use to install the module.

At the ppm prompt, key "install DBD-Oracle"

ppm install DBD-Oracle


To quit ppm, type "exit" at the ppm prompt.


Posted by enzo.660 on January 25, 2007, 1:40 pm
Please log in for more thread options


Thanks Andy!
I don't have ppm. but it is equally easy using cpan. All i gotta do
is "install DBD::Oracle".
The problem however seems to be with the installation of
'InstantClient' and not finding the appropriate ENV variables. Do you
have any ideas on that?

-enzo660

> The easiest way to install cpan perl modules is to use ppm (whcih comes
> with the PERL interpreter). It will automatically download and install
> any dependant modules that the module you are interested in needs.
>
> On a computer with an internet connection, open a command line
> interpreter window and key:
>
> ppm
>
> you should see:
>
> PPM - Programmer's Package Manager version 3.4.
> Copyright (c) 2001 ActiveState Software Inc. All Rights Reserved.
>
> Entering interactive shell. Using Term::ReadLine::Perl as readline
> library.
>
> Type 'help' to get started.
>
> At the ppm prompt, key "search" followed by the first part of the
> module name you are looking for (do NOT include ::)
>
> search dbd
>
> ppm> search dbd
> Searching in Active Repositories
> 1. DBD-ADO [2.96] DBD-ADO
> 2. DBD-AnyData [0.08] DBD-AnyData
> 3. DBD-Chart [0.80] DBD-Chart
> 4. DBD-CSV [0.22] DBD-CSV
> 5. DBD-Excel [0.06] DBD-Excel
> 6. DBD-File [0.35] DBD-File
> 7. DBD-LDAP [0.09] DBD-LDAP
> 8. DBD-Log [0.21] DBD-Log
> 9. DBD-Mimer [1.00] DBD-Mimer
> 10. DBD-Mock [1.34] DBD-Mock
> 11. DBD-Multiplex [1.99-1] DBD-Multiplex
> 12. DBD-mysql [3.0002] DBD-mysql
> 13. DBD-mysql-SimpleMySQL [0.5] DBD-mysql-SimpleMySQL
> 14. DBD-mysqlPP [0.04] DBD-mysqlPP
> 15. DBD-ODBC [1.13] DBD-ODBC
> 16. DBD-Oracle [1.17] DBD-Oracle
> 17. DBD-Ovrimos [0.12] DBD-Ovrimos
> 18. DBD-PgPP [0.05] DBD-PgPP
> 19. DBD-Redbase [0.21] DBD-Redbase
> 20. DBD-Sprite [0.59] DBD-Sprite
> 21. DBD-SQLite [1.13] DBD-SQLite
> 22. DBD-SQLite2 [0.33] DBD-SQLite2
> 23. DBD-SQLrelay [0.1] DBD-SQLrelay
> 24. DBD-Template [0.01] DBD-Template
> ---line 24/27 (any key for more, or q to quit)---
>
> Look for the module you are interested in.
> In this case, it is item 16 in the list.
> The name that appears is the name you should use to install the module.
>
> At the ppm prompt, key "install DBD-Oracle"
>
> ppm install DBD-Oracle
>
> To quit ppm, type "exit" at the ppm prompt.


Posted by Andy on January 30, 2007, 2:56 pm
Please log in for more thread options


I went onto cpan and looked at the DBD::Oracle module. Its
documentation indicates it is dependant upon DBI, found at the
following link:

http://search.cpan.org/~timb/DBI-1.53/DBI.pm

Have you tried to install DBI?

Andy


Similar ThreadsPosted
DBD::Oracle and various oracle clients August 1, 2006, 9:23 am
Tie::Persistent issues May 11, 2005, 10:11 am
ISpell Issues January 22, 2006, 4:54 pm
ASE 12.5 UTF-8 issues with Sybase::DBLib April 5, 2006, 5:05 am
CPAN install issues February 21, 2007, 6:48 pm
Net::SNMP snmpv3 inform issues May 17, 2005, 10:18 am
Apache::Request installation issues March 1, 2005, 9:00 am
Installing mod-perl on Tiger (OSX) issues May 31, 2006, 12:06 am
Install ing GD Active Perl issues July 25, 2006, 1:55 pm
Any daylight saving time issues lately? March 13, 2007, 9:12 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap