Also the SDK package needs to be installed or the build fails.

Minimum for DBD::Oracle are the Basic and SDK packages.

On Sep 5, 2022, at 6:43 AM, kmo...@esntech.com<mailto:kmo...@esntech.com> wrote:

Hi Daniel,

I have three questions.


  1.  Did you install the instant client as root? I always install it as Oracle.
  2.  LD_LIBRARY_PATH should be set as =/root/ora2pg/instantclient_21_7/lib in 
your case
  3.  The link you provided has a download to sqlplus, I’d suggest you download 
and install it to satisfy what is in your post


Regards,
Kevin

From: Tim Bunce <tim.bu...@pobox.com<mailto:tim.bu...@pobox.com>>
Sent: Monday, September 5, 2022 3:16 AM
To: dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: Fwd: please help with DBD-Oracle-1.76




Begin forwarded message:

From: Daniel Chmielewski 
<daniel.chmielew...@gmail.com<mailto:daniel.chmielew...@gmail.com>>
Subject: Fwd: please help with DBD-Oracle-1.76
Date: 5 September 2022 at 10:03:15 IST
To: t...@cpan.org<mailto:t...@cpan.org>

Tim, please help.
Regards,
Daniel

---------- Forwarded message ---------
Od: Daniel Chmielewski 
<daniel.chmielew...@gmail.com<mailto:daniel.chmielew...@gmail.com>>
Date: śr., 31 sie 2022 o 15:10
Subject: please help with DBD-Oracle-1.76
To: <t...@cpan.org<mailto:t...@cpan.org>>

Hi TIm,
Can you help me.
I have problem with installing DBD-Oracle-1.76.

At all it works (make install), but tests fail (make tests). It seems that the 
software does not recognized oracle instant client version 21.7. This is a 
'portable' version with only requires unpack in place.
Have you ever made any test with this ?  Please help. Do you have any 
suggestions?
Regards,
Daniel

====
Short description:
1.
DBD-Oracle-1.76 requires DBI, and all the tests of DBI works fine.
2.
DBI-1.63 (all tests are successful, make, make test, make install => no error 
at all).
3.
I also install instant client from oracle:
https://www.oracle.com/pl/database/technologies/instant-client/linux-x86-64-downloads.html
export ORACLE_HOME=/root/ora2pg/instantclient_21_7
export LD_LIBRARY_PATH=/root/ora2pg/instantclient_21_7
export PATH=$ORACLE_HOME/bin:$PATH

4.
and set env. variable (all at root users), database is located on other server, 
not on this on which is perl installed.

But with DBD-Oracle-1.76 installed on it I get the following error:
============================================
root@stlx0000 DBD-Oracle-1.76]# perl Makefile.PL
Using DBI 1.643 (for perl 5.026003 on x86_64-linux-thread-multi) installed in 
/usr/local/lib64/perl5/auto/DBI/
Configuring DBD::Oracle for perl 5.026003 on linux (x86_64-linux-thread-multi)

If you encounter any problem, a collection of troubleshooting
guides are available under lib/DBD/Oracle/Troubleshooting.
'DBD::Oracle::Troubleshooting' is the general troubleshooting
guide, while platform-specific troubleshooting hints
live in their labelled sub-document (e.g., Win32
hints are gathered in 'lib/DBD/Oracle/Troubleshooting/Win32.pod').

Installing on a linux, Ver#4.18
Using Oracle in /root/ora2pg/instantclient_21_7
Can't find sqlplus. Pity, it would have helped.
I'm having trouble finding your Oracle version number... trying harder

WARNING: Could not determine Oracle client version, defaulting to
version 9.2.0.4.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 your
client version.

Oracle Version 9.2.0.4.0 (9.2)
Looks like an Instant Client installation, okay
Your LD_LIBRARY_PATH env var is set to '/root/ora2pg/instantclient_21_7'
Oracle sysliblist:
Found header files in /root/ora2pg/instantclient_21_7/sdk/include.

client_version=9.2


DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"9.2.0.4.0\"


Checking for functioning wait.ph<http://wait.ph/>
_FORTIFY_SOURCE requires compiling with optimization (-O) at 
/usr/lib64/perl5/features.ph<http://features.ph/> line 207.


System: perl5.026003 linux 
x86-038.build.eng.bos.redhat.com<http://x86-038.build.eng.bos.redhat.com/> 
4.18.0-305.17.1.el8_4.x86_64 #1 smp mon aug 30 07:26:31 edt 2021 x86_64 x86_64 
x86_64 gnulinux
Compiler:   gcc   -g -D_REENTRANT -D_GNU_SOURCE -O2 -g -pipe -Wall 
-Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS 
-fexceptions -fstack-protector-strong -grecord-gcc-switches 
-specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 
-specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic 
-fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection -fwrapv 
-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE 
-D_FILE_OFFSET_BITS=64
Linker:     /usr/bin/ld
Sysliblist:
Linking with -lclntsh.

LD_RUN_PATH=/root/ora2pg/instantclient_21_7
Using DBD::Oracle 1.76.
Using DBD::Oracle 1.76.
=========================================================
====
Please help,
Daniel


--
Daniel Chmielewski


--
Daniel Chmielewski


--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs

Reply via email to