Hi,
I have installed DBD::ODBC latest version on 64 bit Linux Machine. One one
machine I am able to make connection to Vertica using DSN but on other machine
I am getting following error message. My odbc.ini, odbcinst.ini files are
matching exactly:-
set_err:State('82') is not a 5 character string, using 's1000' instead at
/usr/local/lib64/perl5/DBD/ODBC.pm line 153. DBI
connect('VertcaiABITPRIM','nbxxxxx',...)failed: 523 80 (SQL-82).
Any pointer would be appreciated.
Regards,
Mr. Singh
From: Michael Nhan <mn...@genome.wustl.edu>
To: Manimegalai Visvanathan <mvisvanat...@wsgc.com>
Cc: "'dbi-users@perl.org'" <dbi-users@perl.org>
Sent: Friday, September 13, 2013 2:46 PM
Subject: RE: DBD::Oracle installation on AIX
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.
