Hi,
Where does your oracle installation reside? Did you install the oracle
aix client/aix-instant client? Is there a libclntsh.so somewhere in
those paths you listed. What kind of oracle installation exists on this
aix box?
regards,
Michael
On Fri, 13 Sep 2013, Manimegalai Visvanathan wrote:
Date: Fri, 13 Sep 2013 12:34:53 -0700
From: Manimegalai Visvanathan <mvisvanat...@wsgc.com>
To: 'Michael Nhan' <mn...@genome.wustl.edu>
Cc: "'dbi-users@perl.org'" <dbi-users@perl.org>
Subject: RE: DBD::Oracle installation on AIX
Hi Michael,
Thanks for your reply :)
Can you please let me know, which path I have to export to get the oracle
libraries? I have tried with /app/oracle/product/11.1.0 but its not accepted.
Please find the error:
$ 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.
The ORACLE_HOME environment variable value
(/app/oracle/6362104/files/jdbc/lib/ojdbc5.jar/oracle) is not valid.
It must be set to hold the path to an Oracle installation directory
on this machine (or a machine with a compatible architecture).
For an Instant Client install, the directory should include an sdk
subdirectory.
See the README.clients.txt file for more information.
ABORTED!
/app/lawson/WebSphere/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/AppServer/etc/wim/setup/lookaside/oracle
/app/lawson/WebSphere/hrfindev/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/hrfindev/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/hrfindev/AppServer/etc/wim/setup/lookaside/oracle
/app/lawson/WebSphere/hrfintst/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/hrfintst/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/hrfintst/AppServer/etc/wim/setup/lookaside/oracle
/app/lawson/WebSphere/hrfinuat/AppServer/etc/wim/setup/database/oracle
/app/lawson/WebSphere/hrfinuat/AppServer/etc/wim/setup/federation/oracle
/app/lawson/WebSphere/hrfinuat/AppServer/etc/wim/setup/lookaside/oracle
/app/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc5.jar/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc5_g.jar/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc6.jar/oracle
/app/oracle/6362104/files/jdbc/lib/ojdbc6_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc5.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc5_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc6.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/files/jdbc/lib/ojdbc6_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc5.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc5_g.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc6.jar/oracle
/app/oracle/product/11.1.0/.patch_storage/6362104_Dec_20_2007_01_56_03/original_patch/files/jdbc/lib/ojdbc6_g.jar/oracle
/app/oracle/product/11.1.0/sqlj/doc/runtime/javadoc/oracle
/app/oracle/product/11.2.0/sqlj/doc/runtime/javadoc/oracle
/home/oracle
/p00b/devgen/oracle
Thanks in Advance :)
Regards,
Manimegalai V
WSI - Unix Support
Williams- Sonoma, Inc.
[Please include itunix24x7supp...@wsgc.com in cc for all your communications]
Please consider the impact to the environment before printing this email
-----Original Message-----
From: Michael Nhan [mailto:mn...@genome.wustl.edu]
Sent: Friday, September 13, 2013 12:29 PM
To: Manimegalai Visvanathan
Cc: 'dbi-users@perl.org'
Subject: 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 <mvisvanat...@wsgc.com>
To: "'dbi-users@perl.org'" <dbi-users@perl.org>
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.
____
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.
