RE: please help with DBD-Oracle-1.76

<[email protected]> Mon, 5 Sep 2022 06:43:13 -0700
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]>
------=_NextPart_000_0197_01D8C0F2.C77E6E40
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi Daniel,

=20

I have three questions.

=20

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

=20

Regards,

Kevin

=20

From: Tim Bunce <[email protected]>=20
Sent: Monday, September 5, 2022 3:16 AM
To: [email protected]
Subject: Fwd: please help with DBD-Oracle-1.76

=20

=20





Begin forwarded message:

=20

From: Daniel Chmielewski <[email protected] =
<mailto:[email protected]> >

Subject: Fwd: please help with DBD-Oracle-1.76

Date: 5 September 2022 at 10:03:15 IST

To: [email protected] <mailto:[email protected]>=20

=20

Tim, please help.=20

Regards,

Daniel

=20

---------- Forwarded message ---------
Od: Daniel Chmielewski <[email protected] =
<mailto:[email protected]> >
Date: =C5=9Br., 31 sie 2022 o 15:10
Subject: please help with DBD-Oracle-1.76
To: <[email protected] <mailto:[email protected]> >

=20

Hi TIm,

Can you help me.=20

I have problem with installing DBD-Oracle-1.76.=20


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.=20

Have you ever made any test with this ?  Please help. Do you have any =
suggestions?
Regards,

Daniel


=3D=3D=3D=3D
Short description:
1.
DBD-Oracle-1.76 requires DBI, and all the tests of DBI works fine.=20

2.
DBI-1.63 (all tests are successful, make, make test, make install =3D> =
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=3D/root/ora2pg/instantclient_21_7

export LD_LIBRARY_PATH=3D/root/ora2pg/instantclient_21_7

export PATH=3D$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.=20



But with DBD-Oracle-1.76 installed on it I get the following error:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

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)

=20

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').

=20

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

=20

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.

=20

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.

=20

client_version=3D9.2

=20

=20

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

=20

=20

Checking for functioning wait.ph <http://wait.ph/>=20

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

=20

=20

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=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 =
-Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong =
-grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 =
-specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric =
-fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection =
-fwrapv -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE =
-D_FILE_OFFSET_BITS=3D64

Linker:     /usr/bin/ld

Sysliblist:

Linking with -lclntsh.

=20

LD_RUN_PATH=3D/root/ora2pg/instantclient_21_7

Using DBD::Oracle 1.76.

Using DBD::Oracle 1.76.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D

=3D=3D=3D=3D

Please help,

Daniel




=20

--=20

Daniel Chmielewski




=20

--=20

Daniel Chmielewski

=20


------=_NextPart_000_0197_01D8C0F2.C77E6E40
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta =
name=3DGenerator content=3D"Microsoft Word 15 (filtered =
medium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:Helvetica;
	panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"ING Me";
	panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
	{mso-style-priority:34;
	margin-top:0in;
	margin-right:0in;
	margin-bottom:0in;
	margin-left:.5in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
/* List Definitions */
@list l0
	{mso-list-id:539318093;
	mso-list-type:hybrid;
	mso-list-template-ids:-267222764 -1181575326 67698713 67698715 67698703 =
67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
	{mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-.25in;}
@list l0:level2
	{mso-level-number-format:alpha-lower;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-.25in;}
@list l0:level3
	{mso-level-number-format:roman-lower;
	mso-level-tab-stop:none;
	mso-level-number-position:right;
	text-indent:-9.0pt;}
@list l0:level4
	{mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-.25in;}
@list l0:level5
	{mso-level-number-format:alpha-lower;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-.25in;}
@list l0:level6
	{mso-level-number-format:roman-lower;
	mso-level-tab-stop:none;
	mso-level-number-position:right;
	text-indent:-9.0pt;}
@list l0:level7
	{mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-.25in;}
@list l0:level8
	{mso-level-number-format:alpha-lower;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-.25in;}
@list l0:level9
	{mso-level-number-format:roman-lower;
	mso-level-tab-stop:none;
	mso-level-number-position:right;
	text-indent:-9.0pt;}
ol
	{margin-bottom:0in;}
ul
	{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue =
vlink=3Dpurple style=3D'word-wrap:break-word'><div =
class=3DWordSection1><p class=3DMsoNormal>Hi Daniel,<o:p></o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>I have three =
questions.<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><ol =
style=3D'margin-top:0in' start=3D1 type=3D1><li class=3DMsoListParagraph =
style=3D'margin-left:0in;mso-list:l0 level1 lfo1'>Did you install the =
instant client as root? I always install it as =
Oracle.<o:p></o:p></li><li class=3DMsoListParagraph =
style=3D'margin-left:0in;mso-list:l0 level1 lfo1'>LD_LIBRARY_PATH should =
be set as <span lang=3DEN-GB style=3D'font-size:10.5pt;font-family:"ING =
Me",serif;color:#333333'>=3D/root/ora2pg/instantclient_21_7</span>/lib =
in your case<o:p></o:p></li><li class=3DMsoListParagraph =
style=3D'margin-left:0in;mso-list:l0 level1 lfo1'>The link you provided =
has a download to sqlplus, I=E2=80=99d suggest you download and install =
it to satisfy what is in your post<o:p></o:p></li></ol><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal>Regards,<o:p></o:p></p><p =
class=3DMsoNormal>Kevin<o:p></o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><div =
style=3D'border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in =
0in 0in'><p class=3DMsoNormal><b>From:</b> Tim Bunce =
&lt;[email protected]&gt; <br><b>Sent:</b> Monday, September 5, 2022 =
3:16 AM<br><b>To:</b> [email protected]<br><b>Subject:</b> Fwd: please =
help with DBD-Oracle-1.76<o:p></o:p></p></div></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><p =
class=3DMsoNormal><br><br><o:p></o:p></p><blockquote =
style=3D'margin-top:5.0pt;margin-bottom:5.0pt'><div><p =
class=3DMsoNormal>Begin forwarded message:<o:p></o:p></p></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><p =
class=3DMsoNormal><b><span =
style=3D'font-family:"Helvetica",sans-serif'>From: </span></b><span =
style=3D'font-family:"Helvetica",sans-serif'>Daniel Chmielewski &lt;<a =
href=3D"mailto:[email protected]">[email protected]=
</a>&gt;</span><o:p></o:p></p></div><div><p class=3DMsoNormal><b><span =
style=3D'font-family:"Helvetica",sans-serif'>Subject: Fwd: please help =
with DBD-Oracle-1.76</span></b><o:p></o:p></p></div><div><p =
class=3DMsoNormal><b><span =
style=3D'font-family:"Helvetica",sans-serif'>Date: </span></b><span =
style=3D'font-family:"Helvetica",sans-serif'>5 September 2022 at =
10:03:15 IST</span><o:p></o:p></p></div><div><p =
class=3DMsoNormal><b><span =
style=3D'font-family:"Helvetica",sans-serif'>To: </span></b><span =
style=3D'font-family:"Helvetica",sans-serif'><a =
href=3D"mailto:[email protected]">[email protected]</a></span><o:p></o:p></p></di=
v><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><div><p =
class=3DMsoNormal>Tim, please help.&nbsp;<o:p></o:p></p><div><p =
class=3DMsoNormal>Regards,<o:p></o:p></p></div><div><p =
class=3DMsoNormal>Daniel<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><o:p>&nbsp;</o:p></p><div><div><p =
class=3DMsoNormal>---------- Forwarded message ---------<br>Od: =
<strong><span style=3D'font-family:"Calibri",sans-serif'>Daniel =
Chmielewski</span></strong> &lt;<a =
href=3D"mailto:[email protected]">[email protected]=
</a>&gt;<br>Date: =C5=9Br., 31 sie 2022 o 15:10<br>Subject: please help =
with DBD-Oracle-1.76<br>To: &lt;<a =
href=3D"mailto:[email protected]">[email protected]</a>&gt;<o:p></o:p></p></div><=
p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><o:p>&nbsp;</o:p></p><div><p =
class=3DMsoNormal>Hi TIm,<o:p></o:p></p><div><p class=3DMsoNormal>Can =
you help me.&nbsp;<o:p></o:p></p></div><div><p class=3DMsoNormal>I have =
problem with installing =
DBD-Oracle-1.76.&nbsp;<o:p></o:p></p></div><div><p =
class=3DMsoNormal><br>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.&nbsp;<o:p></o:p></p></div><div><p =
class=3DMsoNormal>Have you ever made any test with this ?&nbsp; Please =
help. Do you have any =
suggestions?<br>Regards,<o:p></o:p></p></div><div><p =
class=3DMsoNormal>Daniel<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'><br>=3D=3D=3D=3D<br>Short =
description:<br>1.<br>DBD-Oracle-1.76 requires DBI, and all the tests of =
DBI works fine.&nbsp;<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>2.<br>DBI-1.63 (all tests are successful, =
make, make test, make install =3D&gt; no error at =
all).<o:p></o:p></p></div><div><p =
class=3DMsoNormal>3.<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>I also install instant client from =
oracle:<br><a =
href=3D"https://www.oracle.com/pl/database/technologies/instant-client/li=
nux-x86-64-downloads.html" =
target=3D"_blank">https://www.oracle.com/pl/database/technologies/instant=
-client/linux-x86-64-downloads.html</a><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB style=3D'font-size:10.5pt;font-family:"ING =
Me",serif;color:#333333'>export =
ORACLE_HOME=3D/root/ora2pg/instantclient_21_7</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB style=3D'font-size:10.5pt;font-family:"ING =
Me",serif;color:#333333'>export =
LD_LIBRARY_PATH=3D/root/ora2pg/instantclient_21_7</span><o:p></o:p></p><p=
 class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB style=3D'font-size:10.5pt;font-family:"ING =
Me",serif;color:#333333'>export =
PATH=3D$ORACLE_HOME/bin:$PATH</span><o:p></o:p></p><p =
class=3DMsoNormal><br>4.<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'margin-bottom:12.0pt'>and set env. variable (all at root =
users), database is located on other server, not on this on which is =
perl installed.&nbsp;<br><br><o:p></o:p></p></div><div><p =
class=3DMsoNormal>But with DBD-Oracle-1.76 installed on it I get the =
following =
error:<br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<o:p=
></o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>r=
oot@stlx0000 DBD-Oracle-1.76]# perl Makefile.PL</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>U=
sing DBI 1.643 (for perl 5.026003 on x86_64-linux-thread-multi) =
installed in /usr/local/lib64/perl5/auto/DBI/</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>C=
onfiguring DBD::Oracle for perl 5.026003 on linux =
(x86_64-linux-thread-multi)</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>I=
f you encounter any problem, a collection of =
troubleshooting</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>g=
uides are available under =
lib/DBD/Oracle/Troubleshooting.</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>'=
DBD::Oracle::Troubleshooting' is the general =
troubleshooting</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>g=
uide, while platform-specific troubleshooting =
hints</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>l=
ive in their labelled sub-document (e.g., Win32</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>h=
ints are gathered in =
'lib/DBD/Oracle/Troubleshooting/Win32.pod').</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>I=
nstalling on a linux, Ver#4.18</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>U=
sing Oracle in /root/ora2pg/instantclient_21_7</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>C=
an't find sqlplus. Pity, it would have helped.</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>I=
'm having trouble finding your Oracle version number... trying =
harder</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>W=
ARNING: Could not determine Oracle client version, defaulting =
to</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>v=
ersion 9.2.0.4.0. Some features of DBD::Oracle may not =
work.</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>O=
racle version-based logic in Makefile.PL may produce =
erroneous</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>r=
esults. You can use &quot;perl Makefile.PL -V X.Y.Z&quot; to specify =
your</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>c=
lient version.</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>O=
racle Version 9.2.0.4.0 (9.2)</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>L=
ooks like an Instant Client installation, okay</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>Y=
our LD_LIBRARY_PATH env var is set to =
'/root/ora2pg/instantclient_21_7'</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>O=
racle sysliblist:</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>F=
ound header files in =
/root/ora2pg/instantclient_21_7/sdk/include.</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>c=
lient_version=3D9.2</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>D=
EFINE=3D -Wall -Wno-comment -DUTF8_SUPPORT =
-DORA_OCI_VERSION=3D\&quot;9.2.0.4.0\&quot;</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>C=
hecking for functioning&nbsp;<a href=3D"http://wait.ph/" =
target=3D"_blank">wait.ph</a></span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>_=
FORTIFY_SOURCE requires compiling with optimization (-O) at =
/usr/lib64/perl5/<a href=3D"http://features.ph/" =
target=3D"_blank">features.ph</a>&nbsp;line 207.</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>S=
ystem: perl5.026003 linux&nbsp;<a =
href=3D"http://x86-038.build.eng.bos.redhat.com/" =
target=3D"_blank">x86-038.build.eng.bos.redhat.com</a>&nbsp;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</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>C=
ompiler:&nbsp;&nbsp; gcc&nbsp;&nbsp; -g -D_REENTRANT -D_GNU_SOURCE -O2 =
-g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 =
-Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong =
-grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 =
-specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric =
-fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection =
-fwrapv -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE =
-D_FILE_OFFSET_BITS=3D64</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>L=
inker:&nbsp;&nbsp;&nbsp;&nbsp; /usr/bin/ld</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>S=
ysliblist:</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>L=
inking with -lclntsh.</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>&=
nbsp;</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>L=
D_RUN_PATH=3D/root/ora2pg/instantclient_21_7</span><o:p></o:p></p><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>U=
sing DBD::Oracle 1.76.</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:"Tahoma",sans-serif;color:#333333'>U=
sing DBD::Oracle 1.76.</span><o:p></o:p></p><p =
class=3DMsoNormal>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<o:p></o:p></p></div><div><p =
class=3DMsoNormal>=3D=3D=3D=3D<o:p></o:p></p></div><div><p =
class=3DMsoNormal>Please help,<o:p></o:p></p></div><div><p =
class=3DMsoNormal>Daniel<o:p></o:p></p></div><div><p =
class=3DMsoNormal><br clear=3Dall><o:p></o:p></p><div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p></div><p class=3DMsoNormal>-- =
<o:p></o:p></p><div><p class=3DMsoNormal>Daniel =
Chmielewski<o:p></o:p></p></div></div></div></div><p =
class=3DMsoNormal><br clear=3Dall><o:p></o:p></p><div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p></div><p class=3DMsoNormal>-- =
<o:p></o:p></p><div><p class=3DMsoNormal>Daniel =
Chmielewski<o:p></o:p></p></div></div></div></div></blockquote></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p></div></body></html>
------=_NextPart_000_0197_01D8C0F2.C77E6E40--