HI All,
Please refer to the attached document that you might need for
any future references to build the right Perl (5.6.1) and DBI/DBD on HP UX
11.0(64 BIT)
against Oracle9i .
Thanks
Sanjay
<<installperldbdbdi.txt>>
After days of Frustration her is the Mantra to make DBD Work on HP UX Platforms
BUILDING THE RIGHT PERL
Here are the Steps that needs to be followed . You should be looged in as root .
1) Download the Perl5.6.1 from CPAN . DO NOT USE THE HP VERSION . IT IS NO GOOD.
2) untar the file . It will create a directory perl5.6.1
3) cd perl5.6.1
4) rm -f config.sh Policy.sh
5) sh Configure -Dprefix=/opt/perl5.6.1 -Duse64bitint -Duselargefiles -Uusemymalloc
-Ubincompat5005 -de
6) Open the config.sh file
7) edit the parameter ccflags add a +z . It should look exactly like this
ccflags='+z -D_HPUX_SOURCE +DD64 -Ae -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64'
8) edit the libs parameter . Make sure it starts with -lcl -lpthread . It should not
be at the end.
It should look exactly like this
libs = -lcl -lpthread -lnsl -lnm -ldld -lm -lc -lsec
9) After making these changes to the config.sh run ./configure -de .At one time it may
prompt you
that perl found in other locations . Just hit return .
10) make test
11) make install
Next INSTALL the DBI (DBI-1.20 should be downloaded for CPAN)
Before you install DBI .Make sure to check the following
A) The following ENV variables should be set
$ORACLE_HOME,$ORACLE_SID,$SHLIB_PATH,$PERL5LIB .
B) Check that the listener is running against the version of Oracle against which you
are planning
to install DBI/DBD
C) Do a sqlplus to make you that you are able to connect to the Database to make sure
that the ORACLE_PATH,$PATH Variables etc are set up .
Follow these steps to install DBI .
1) perl makefile.pl
2) make
3) make test . couple of the tests (I think examp) might fail but it is okay . It will
build it as 99.8%.
4) make install
Next after Installing DBI install DBD (DBD-Oracle-1.12 should be downloaded from CPAN)
1) perl Makefile.PL
2) make
3) make test
4) make install
Note: during make test it will try to connect to the database using user scott/tiger
which might failed
if you don't have this user setup . You may simply ignore this.
Also during make you might get some warning messages like (oci pointer not assigned)
which you can ignore.
Also Read all the README files pertaining to PERL,DBI,DBD . I had to read all the
files first before
you start builing PERL. This is because DBD requires Perl to be configured and build
with certain settings
which ultimately makes DBD work . So it is a combination of both that I came up to
successfully build DBI
Next if you have successfully build perl on one machine . You may tar the perl
directory and untar it
on other boxes . This way you may not need to do any installations and go through this
pain .
Thanks
Sanjay
