Perl DBI and DBD Install on AIX 5.3
PERL-5.8.8 INSTALL Document on AIX-5.3.0.0
- Download perl-5.8.8.tar.gz from cpan.org(http://cpan.org/src/perl-5.8.8.tar.gz)
- Extract gzip -dc perl-5.8.8.tar.gz tar –xvf –
- cd perl-5.8.8 and read INSTALL and Readme.aix files for ref
- Verify all OS perquisites
- Install OS patches if required build Perl using gcc compiler.
Step1:-Verify OS level-bash-3.00# oslevel
5.3.0.0
Step2:- -bash-3.00# lslpp -l grep 'bos.rte '
bos.rte 5.3.7.0 COMMITTED Base Operating System Runtime
bos.rte 5.3.0.60 COMMITTED Base Operating System Runtime
Step3:- -bash-3.00# lslpp -l egrep "syscallslibm"
bos.adt.libm 5.3.7.0 COMMITTED Base Application Development
bos.adt.syscalls 5.3.7.0 COMMITTED System Calls Application
Note:- Perl cannot be built without bos.adt.syscalls and bos.adt.libm installed
Download and install OS patch if these things are not present also download gcc compiler for AIX 5.3 and install.
Install the OS patch for AIX 5.3 to get bos.adt.syscalls
-bash-3.00# oslevel -r
5300-07
AIX 5.3 and 5300-07 download OS path and install it using smit (1.8 GB package takes time)
http://www.blogger.com/- http://www-01.ibm.com/support/docview.wss?uid=isg1fileset-2143896851
-bash-3.00# gcc -v
Using built-in specs.
Target: powerpc-ibm-aix5.3.0.0
Configured with: ../configure --with-as=/usr/bin/as --with-ld=/usr/bin/ld --enable-languages=c,c++,java --prefix=/opt/freeware --enable-threads --enable-version-specific-runtime-libs --host=powerpc-ibm-aix5.3.0.0 --target=powerpc-ibm-aix5.3.0.0 --build=powerpc-ibm-aix5.3.0.0 --disable-libjava-multilib
Thread model: aix
gcc version 4.2.0
(if GCC not present it can be downloaded from http://www-03.ibm.com/systems/p/os/aix/linux/toolbox/ezinstall.html download and install )
Also download gnu make don’t use make that come with AIX gives lot of errors.
http://ftp.gnu.org/pub/gnu/make/
download (http://ftp.gnu.org/pub/gnu/make/make-3.80.tar.gz)
-bash-3.00# make --version
GNU Make 3.80
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
After getting the required things
Set path for make and gcc to reflect correctly
Extract perl-5.8.8 and follow the install steps:-
General install steps
- rm -f config.sh Policy.sh
- sh Configure -de
- make
- make test
- make install
- If some step fails run #make distclean or #make realclean to clear up the install directory and run the steps again.
Step 1:- rm -f config.sh Policy.sh
Step2:- sh Configure -Dcc=gcc(to configure with gcc compiler)
Step3:- make
-bash-3.00# make
make: 1254-002 Cannot find a rule to create target <command-line> from
dependencies.
Stop.
If u get such err when u run make
Edit the file 'makefile' and manually
delete all the lines that contain the string '<command-line>'. Do the
same for the file x2p/makefile as well.
make is success and make test gives me this output... we are almost
there....
step 4:-make test
t/pod/poderrs.............................ok
t/pod/podselect...........................ok
t/pod/special_seqs........................ok
t/x2p/s2p.................................ok
Failed 1 test script out of 933, 99.89% okay.
Step5:- make install
Fix the path default path perl will be install In /usr/local/bin.
AND WE ARE DONE!!
-bash-3.00# perl -v
This is perl, v5.8.8 built for aix
Copyright 1987-2006, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
AFTER BUILDING PERL BUILD DBI AND DBD TO CONNECT TO DATABASE... ORACLE
DBI-1.607/DBD-Oracle-1.16 Install document forAIX 5.3.
SET ENV
DISPLAY=192.168.1.13:0.0 ; export DISPLAY
## Oracle Environment Setup
ORACLE_BASE=/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.0.2
ORACLE_PATH=$ORACLE_HOME/bin:/opt/bin:/usr/oracle/local:/bin:/usr/ccs/bin:/usr/bin ORACLE_SID=PROD
TMPDIR=/tmp
#ORACLE_DOC=$ORACLE_BASE/doc
#LD_LIBRARY_PATH=$ORACLE_HOME/lib
TNS_ADMIN=$ORACLE_HOME/network/admin
LD_LIBRARY_PATH=/usr/sfw/lib:/usr/local/lib:/opt/sfw/lib:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32;
LD_RUN_PATH=/oracle/product/10.0.2/lib32:/oracle/product/10.0.2/rdbms/lib32
ORACCENV=cc=gcc
export ORACCENV
PATH=/usr/local/bin:/usr/bin:/usr/dt/bin:/usr/openwin/bin:/bin:$ORACLE_HOME/bin:
/etc:/usr/ccs/bin:/usr/ucb:/usr/sbin
export LD_RUN_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME ORACLE_PATH PATH ORAC
LE_SID TMPDIR LD_LIBRARY_PATH NLS_LANG ORA_NLS33 TNS_ADMIN
Download the required DBI and DBD from www.cpan.org
STEPS TO BUILD DBI-1.607
Get DBI-1.607.tar.gz from cpan and ftp to AIX 5.3 box
#gzip -dc DBI-1.607.tar.gz tar –xvf –
cd DBI-1.607
Step1:- perl Makefile.PL
Step2:- make
Step3:- make test
Step4:- make install
STEPS TO BUILD DBI-Oracle-1.16
Get DBD-Oracle-.1.16.tar.gz from cpan and ftp to AIX 5.3 box
#gzip -dc DBD-Oracle-1.16.tar.gz tar –xvf –
cd DBD-Oracle-1.16
Run the steps for install.
Step1:- perl Makefile.PL -l ( use this -l option to make it 64 bit compatable.)
Step2: make
Step3: make test
Step4: make install
Note:- Read Install and README.aix which comes with the software if you run into issues.
