I've attached some notes that I made when I did the DBD::Oracle here. The
install was a bit of a pain.
The file is plain text (UNIX format, i.e. LF delimited). The names have been
changed to protect the guilty.
Hope this helps.
cn
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David
Sawyer
Sent: Friday, October 21, 2005 8:00 AM
To: Brian Raven; [email protected]
Subject: RE: :Oracle Module install failure
Thanks for the reply.
Yes. I went through the readme files and yes the directory paths are
correct.
Regards,
David Sawyer
Senior Customer Support Engineer
Ceon Corporation
650-817-6334 (office)
650-238-8078 (Blackberry Wireless)
408-832-4354 (mobile)
www.Ceon.com
-.- .---- -.. .-. ...
-----Original Message-----
From: Brian Raven [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 2:01 AM
To: David Sawyer; [email protected]
Subject: RE: :Oracle Module install failure
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David
Sawyer
Sent: 20 October 2005 20:02
To: [email protected]
Subject: DBD::Oracle Module install failure
> I am hopeful that someone on this list has experienced this and can
point me in the correct direction to
> resolve it.
> I am trying to install the DBD::Oracle in my perl on UNIX. I am
getting errors that I am not able to decipher
> to correct.
>
> The errors are telling me that perhaps I am missing some oracle files
but it's not clear which files I am
> missing. Can anyone assist me helping me understand the error and
perhaps tell me what files I am missing and
> or why this module will not install properly?
> Configuring DBD::Oracle ...
> >>> Remember to actually *READ* the README file!
> Especially if you have any problems.
Have you done that?
You seem to be using CPAN to install this module, but unlike most of
them DBD::Oracle requires some additional steps prior to building and
testing to ensure that they are successful, and installation can
proceed. This is described in the README file.
> Using Oracle in /opt/dbms/ceon3/oracle/product/ora9205_64
For example, is that the correct directory?
HTH
--
Brian Raven
=================================
Atos Euronext Market Solutions Disclaimer
=================================
The information contained in this e-mail is confidential and solely for
the intended addressee(s). Unauthorised reproduction, disclosure,
modification, and/or distribution of this email may be unlawful.
If you have received this email in error, please notify the sender
immediately and delete it from your system. The views expressed in this
message do not necessarily reflect those of Atos Euronext Market
Solutions.
L'information contenue dans cet e-mail est confidentielle et uniquement
destinee a la (aux) personnes a laquelle (auxquelle(s)) elle est
adressee. Toute copie, publication ou diffusion de cet email est
interdite. Si cet e-mail vous parvient par erreur, nous vous prions de
bien vouloir prevenir l'expediteur immediatement et d'effacer le e-mail
et annexes jointes de votre systeme. Le contenu de ce message
electronique ne represente pas necessairement la position ou le point de
vue d'Atos Euronext Market Solutions.
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
********************************************************************************
Perl DBI/Oracle DBD install and test notes - Chris N. 1-28-2004
********************************************************************************
Overview...
We are using Perl in a UNIX environment, along with the Perl DBI and
DBD::Oracle
packages to access Oracle database servers.
The DBI is the Database Independent Layer. This is the package that allows you
to
write portable SQL code.
The DBD is the Database Dependent Layer, i.e. the "driver" that is database
implementation specific. There are Perl DBD packages for Oracle, MySQL, ODBC,
etc.
Here's what the calling stack looks like...
DBI
DBD::Oracle
Oracle client libraries <-------> Oracle Database Server
The DBI loads the DBD driver, which connects through the dynamically loaded
client
libraries to talk to the server.
--------------------------------------------------------------------------------
Software choices...
Platform: Solaris 8 (SunOS 5.8)
Software used to build DBI and DBD...
GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.8
Perl, v5.8.0 built for sun4-solaris
DBI-1.40
DBD-Oracle-1.14
Oracle for Solaris - 32-bit version of 9.0.1
Build was performed by John Doe on somehost at /cad/build/gnu/perl
--------------------------------------------------------------------------------
Rational behind the choices made for particular versions of the software...
Solaris 8 (SunOS 5.8) - campus default for Engineering
GNU Make version 3.79.1 - campus default for Engineering
Perl, v5.8.0 - v5.6.1 is campus default, but we opted for a newer version,
mainly
to get an upgrade to Perl and secondarily because it was known to work with
Josh Bellamy's DBI/DBD::Oracle install.
DBI-1.40 - latest version available
DBD-Oracle-1.14 - latest version available
Oracle for Solaris - 32-bit version of 9.0.1 - first of all, the 32-bit version
was known to work in John's install (John had trouble building the DBD against
the 64-bit version). Also, we want to use the newest Oracle client library
possible that would still talk to the old 7.3.4 servers. Oracle client version
9.2 and newer is known not to talk to a 7.3.4 server, i.e. you can't even use
sqlplus to connect and issue queries (per Oracle DBA's). There are only a
couple
of old 7.3.4 server instances running on campus at this time which are of no
concern to us in Engineering.
--------------------------------------------------------------------------------
************ WARNINGS regarding software choices
***************************
Multiple people (myself included) have been down multiple dead-end trails with
incompatible versions of the Oracle client and server, DBD build problems,
incomplete/incompatible client installations laying about in the UNIX filesystem
(there are several of them), and multiple other issues. The software set and
build procedures detailed in this document are known to work. There are other
working configurations and build procedures, but there are also plenty of
dead-ends and eye-pokes as well. You have been warned.
********************************************************************************
--------------------------------------------------------------------------------
General install order (assuming each isn't already installed)...
Oracle client libraries
Perl
DBI
DBD
--------------------------------------------------------------------------------
Oracle client install notes...
Joe Blow installed 32-bit client from CD to /apps/oracle/product/9.0.1
Per Jack S. (Oracle DBA), the absence of a lib32 directory indicates that
it is indeed the 32-bit version of the library that was installed under lib.
When a 64-bit version is installed, the install script puts the 64-bit libraries
under "lib" and the 32-bit libraries under "lib32".
Simple Client Test notes:
Used /apps/oracle/product/9.0.1/bin/sqlplus to connect to...
OUR MES DB: ourschema, i.e. ouruser/<enter_password_here>@ourschema
--------------------------------------------------------------------------------
DBI Notes...
DBI-1.40 - source is stored at /users/me/Downloads/perl/DBI/DBI-1.40.tar.gz
- logfiles are stored at /users/me/work/Oracle/install_and_test/DBI
Build procedure is as follows...
gunzip DBI-1.40.tar.gz
tar -xvf DBI-1.40.tar
cd DBI-1.40
/usr/local/bin/perl5.8.0 Makefile.PL
make | tee make.txt
make test | tee test.txt
sudo su -
make install | tee install.txt
Results of each operation are captured in *.txt files
--------------------------------------------------------------------------------
DBD Notes...
DBD-Oracle-1.14 - source is at
/users/me/Downloads/perl/DBD/DBD-Oracle-1.14.tar.gz
- logfiles are stored at
/users/me/work/Oracle/install_and_test/DBD
Build procedure is as follows...
setenv ORAENV_ASK NO
setenv ORACLE_SID ouruser
setenv ORACLE_HOME /apps/oracle/product/9.0.1
setenv ORACLE_USERID me/<enter_password_here>@ourschema
gunzip DBD-Oracle-1.14.tar.gz
tar -xvf DBD-Oracle-1.14.tar
cd DBD-Oracle-1.14
/usr/local/bin/perl5.8.0 Makefile.PL | tee perlmake.txt
make | tee make.txt
make test | tee test.txt
sudo su -
make install | tee install.txt
Results of each operation are captured in *.txt files
When testing the DBI-1.40/Oracle DBD-1.14 build against the dev1 database
(server version 8.1.5),
all of the tests passed.
When testing the same build against the OUR MES database (server version
8.0.5), most of
the plsql tests failed. This is not an issue since we don't plan to use the
plsql interface
from Perl. All of the basic functionality exists (and then some).
--------------------------------------------------------------------------------
Usage issues...
In order to use the new DBI/DBD interface, you will have to explicitly use
perl5.8.0
so that the correct DBI and DBD modules will be included. There may be other
work-arounds,
but this is the most straightforward way to get it done.
For example, the first line of your perl script should read...
#!/usr/local/bin/perl5.8.0
Currently perl v5.6.1 is the default.
Using the default (#!/usr/local/bin/perl) will pull up on older version of the
DBI
and will fail to find the DBD::Oracle at all.
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
