Re: DBD::Oracle installation on AIX

is oracle libraries and installation really in /app/oracle/client/jdk/jre? 
oracle library is needed for DBD-Oracle.  Oracle binary is not the same as 
the Java from oracle.  Just making sure you were not confusing the 2.

Michael



On Thu, 12 Sep 2013, Manimegalai Visvanathan wrote:

> Date: Thu, 12 Sep 2013 15:13:11 -0700
> From: Manimegalai Visvanathan <[email protected]>
> To: "'[email protected]'" <[email protected]>
> Subject: DBD::Oracle installation on AIX
> 
> 
> Hi Team,
> 
>  
> 
> I need one help from you…
> 
>  
> 
> While installing in DBD::Oracle perl module am facing some challenges. Can you please help me to fix that issue.
> 
>  
> 
> Server OS: AIX
> 
>  
> 
> Am not able to run the make command:
> 
>  
> 
>  
> 
> $ perl -V
> 
> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
> 
>   Platform:
> 
>     osname=aix, osvers=5.3.0.0, archname=aix-thread-multi
> 
>     uname='aix akash79 3 5 00011a85d600 '
> 
>     config_args='-desr -Dinstallprefix=/usr/opt/perl5 -Dprefix=/usr/opt/perl5 -Dcc=xlc_r -Duseshrplib -Dusethreads'
> 
>     hint=recommended, useposix=true, d_sigaction=define
> 
>     usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
> 
>     useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> 
>     use64bitint=undef use64bitall=undef uselongdouble=undef
> 
>     usemymalloc=n, bincompat5005=undef
> 
>   Compiler:
> 
>     cc='cc_r', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN
> -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong',
> 
>     optimize='-O',
> 
>     cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT'
> 
>     ccversion='9.0.0.2', gccversion='', gccosandvers=''
> 
>     intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
> 
>     d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
> 
>     ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
> 
>     alignbytes=8, prototype=define
> 
>   Linker and Libraries:
> 
>     ld='ld', ldflags =' -brtl -bdynamic -b32'
> 
>     libpth=/lib /usr/lib /usr/ccs/lib
> 
>     libs=-lbind -lnsl -lgdbm -ldbm -ldb -ldl -lld -lm -lcrypt -lpthreads -lc -lbsd
> 
>     perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lpthreads -lc -lbsd
> 
>     libc=, so=a, useshrplib=true, libperl=libperl.a
> 
>     gnulibc_version=''
> 
>   Dynamic Linking:
> 
>     dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='  -bE:/usr/opt/perl5/lib/5.8.8/aix-thread-multi/CORE/perl.exp'
> 
>     cccdlflags=' ', lddlflags='-bhalt:4 -bexpall -G -bnoentry -lpthreads -lc'
> 
>  
> 
>  
> 
> Characteristics of this binary (from libperl):
> 
>   Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
> 
>                         PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES
> 
>                         USE_PERLIO USE_REENTRANT_API
> 
>   Built under aix
> 
>   Compiled at Jun  2 2009 16:11:40
> 
>   @INC:
> 
>     /usr/opt/perl5/lib/5.8.8/aix-thread-multi
> 
>     /usr/opt/perl5/lib/5.8.8
> 
>     /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi
> 
>     /usr/opt/perl5/lib/site_perl/5.8.8
> 
>     /usr/opt/perl5/lib/site_perl
> 
>     .
> 
>  
> 
> export ORACLE_HOME=/app/oracle/client/jdk/jre
> 
> $ sudo perl Makefile.PL
> 
> Using DBI 1.628 (for perl 5.008008 on aix-thread-multi) installed in
> /usr/opt/perl5/lib/site_perl/5.8.8/aix-thread-multi/auto/DBI/
> 
>  
> 
> Configuring DBD::Oracle for perl 5.008008 on aix (aix-thread-multi)
> 
>  
> 
> Remember to actually *READ* the README file! Especially if you have any problems.
> 
>  
> 
> Installing on a aix, Ver#5.3
> 
> Using Oracle in /app/oracle/client/jdk/jre
> 
> Can't find sqlplus. Pity, it would have helped.
> 
> I'm having trouble finding your Oracle version number... trying harder
> 
>  
> 
> WARNING: I could not determine Oracle client version so I'll just
> 
> default to version 8.0.0.0. Some features of DBD::Oracle may not work.
> 
> Oracle version based logic in Makefile.PL may produce erroneous results.
> 
> You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.
> 
>  
> 
> Oracle version 8.0.0.0 (8.0)
> 
> DBD::Oracle no longer supports Oracle client versions before 9.2
> 
> Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.
> 
> $ sudo make
> 
> make: There must be an existing description file or specify a target.
> 
> $ sudo make install
> 
> make: Cannot find a rule to create target install from dependencies.
> 
> Stop.
> 
>  
> 
> Please help me to fix this issue.
> 
>  
> 
> Regards,
> 
> Manimegalai V
> 
> WSI - Unix Support
> 
> Williams- Sonoma, Inc.
> 
>  
> 
> 
>

-- 
 		---//---
Time flies like the wind. Fruit flies like bananas.
 	--- Groucho Marx

Either write something worth reading or do something worth writing.
 	--- Benjamin Franklin

A meeting is an event at which the minutes are kept and the hours are lost

____
This email message is a private communication. The information transmitted, including attachments, is intended only for the person or entity to which it is addressed and may contain confidential, privileged, and/or proprietary material. Any review, duplication, retransmission, distribution, or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is unauthorized by the sender and is prohibited. If you have received this message in error, please contact the sender immediately by return email and delete the original message from all computer systems. Thank you.