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. > > > > > -- ---//--- 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.
