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> Sent: Monday, September 5, 2022 3:16 AM To: 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
