Prel-5.8.8 DBI and DBD Install on AIX 5.3

2008-09-11T10:27:00.001-07:00

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.

Welcome Techies

2008-07-13T23:25:00.000-07:00

The purpose of this blog is to foray the difficulties a person comes across while learning or developing technologies like

Oracle
Oracle DB interface Drivers like DBD::Oracle
Perl
PHP
Mysql
XAMPP
WAMPP
all open source Development.

and to provide solutions to the same...

Apart from this, a user can search through various topics for System and Database
administration purposes especially for Operating Systems like

Solaris -10 SPARC
UNIX

Right from Installing to developing the softwares on SUN solaris box you get everything in this page ... So navigate through and have fun !!! as there is no end to learning any new stuff ...

Hope this blog helps one and all :)

Please post your queries/opinions/suggestions at fourtechies@gmail.com

Oracle DBA/APPS DBA

Prel-5.8.8 DBI and DBD Install on AIX 5.3

Perl DBI and DBD Install on AIX 5.3

Welcome Techies