Re: Oracle connection error
[email protected] (Syed Abdulla) Fri, 13 Jan 2023 23:28:43 +0530
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <CAGbX+DcvMGB9MiaTWZ9rvy05jvkqwAAJBL7ng+++dSDZ6EEDMg@mail.gmail.com> |
--000000000000d8ec1a05f228fcbf Content-Type: text/plain; charset="UTF-8" Tough luck! That isn't working either. I tried: make realclean perl Makefile.PL LINKTYPE=static make make perl (you'll need to use and install _this_ new perl binary) make test make -f Makefile.aperl inst_perl MAP_TARGET=perl (install new perl) make install and then I see these errors install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /usr/bin/perl /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at (eval 15) line 3. Compilation failed in require at (eval 15) line 3. Perhaps a module that DBD::Oracle requires hasn't been fully installed at /usr/local/share/perl5/Ora2Pg/Oracle.pm line 141. On Fri, Jan 13, 2023 at 9:12 AM Richard Dice <[email protected]> wrote: > Where is the library installed to? In what directory? > > Is that directory referenced in the /etc/ld.so.conf file? > > If not, add it and then run "ldconfig" command, then re-try. > > > > On Thu, Jan 12, 2023 at 11:32 AM Syed Abdulla <[email protected]> > wrote: > >> Thank you Clive. I installed the library libnsl.x86_64. Below I pasted >> outputs from the commands. I logged in as root. >> >> *# dnf install libnsl.x86_64* >> *Last metadata expiration check: 0:04:34 ago on Thu 12 Jan 2023 04:22:12 >> PM UTC.* >> *Package libnsl-2.28-189.5.el8_6.x86_64 is already installed.* >> *Dependencies resolved.* >> *Nothing to do.* >> *Complete!* >> >> *#perl -MCPAN -e shell* >> *CPAN>get DBD::Oracle* >> *CPAN>quit* >> *#cd /root/.cpan/build/DBD-Oracle-1.83-0* >> *#perl Makefile.PL* >> >> I see the below error again: >> */usr/bin/ld: cannot find -lnsl* >> *collect2: error: ld returned 1 exit status* >> *make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so] Error 1* >> >> *Please help to resolve this issue.* >> *Thanks* >> >> On Thu, Jan 12, 2023 at 9:50 PM Clive Eisen <[email protected]> >> wrote: >> >>> dnf install libnsl.x86_64 >>> >>> On 12 Jan 2023, at 14:25, Syed Abdulla <[email protected]> wrote: >>> >>> Hi, >>> >>> While installing Perl DBI module to connect to Oracle 19c on RedHat 8 >>> VM, I see the below error and the installation fails. >>> >>> /usr/bin/ld: cannot find -lnsl >>> collect2: error: ld returned 1 exit status >>> make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so >>> <http://oracle.so/>] Error 1 >>> ZARQUON/DBD-Oracle-1.83.tar.gz >>> /usr/bin/make -- NOT OK >>> >>> Has anyone seen this error. Please help to resolve this issue. >>> >>> Thanks. >>> >>> -- >>> >>> This (Quran) is a Message for mankind (and a clear proof against them), >>> in order that they may be warned thereby, and that they may know that He is >>> the only One God - (The Creator, Sustainer of all and none has the right to >>> be worshipped but GOD), and that men of understanding may take heed. >>> >>> Holy Quran >>> >>> >>> >> >> -- >> >> This (Quran) is a Message for mankind (and a clear proof against them), >> in order that they may be warned thereby, and that they may know that He is >> the only One God - (The Creator, Sustainer of all and none has the right to >> be worshipped but GOD), and that men of understanding may take heed. >> >> Holy Quran >> > -- This (Quran) is a Message for mankind (and a clear proof against them), in order that they may be warned thereby, and that they may know that He is the only One God - (The Creator, Sustainer of all and none has the right to be worshipped but GOD), and that men of understanding may take heed. Holy Quran --000000000000d8ec1a05f228fcbf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"ltr">Tough luck! That isn't working either= . I tried:=C2=A0<div><pre style=3D"white-space:pre-wrap;color:rgb(0,0,0)">m= ake realclean perl Makefile.PL LINKTYPE=3Dstatic make make perl (you'll need to use and install _this_ new perl binar= y) make test make -f Makefile.aperl inst_perl MAP_TARGET=3Dperl (install new perl) make install </pre><pre style=3D"white-space:pre-wrap;color:rgb(0,0,0)= "><span style=3D"color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif= ;white-space:normal">and then I see these errors</span><br></pre><pre style= =3D"white-space:pre-wrap"><font color=3D"#000000">install_driver(Oracle) fa= iled: Can't locate loadable object for module DBD::Oracle in @INC (@INC= contains: /usr/bin/perl /usr/local/lib64/perl5 /usr/local/share/perl5 /usr= /lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr= /share/perl5) at (eval 15) line 3. Compilation failed in require at (eval 15) line 3. Perhaps a module that DBD::Oracle requires hasn't been fully installed at /usr/local/share/perl5/Ora2Pg/Oracle.pm line 141.</font></pre></div></d= iv></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_att= r">On Fri, Jan 13, 2023 at 9:12 AM Richard Dice <<a href=3D"mailto:rdice= @pobox.com">[email protected]</a>> wrote:<br></div><blockquote class=3D"gm= ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,= 204,204);padding-left:1ex"><div dir=3D"ltr">Where is the library installed = to?=C2=A0 In what directory?<div><br></div><div>Is that directory reference= d in the /etc/ld.so.conf file?</div><div><br></div><div>If not, add it and = then run "ldconfig" command, then re-try.</div><div><br></div><di= v><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"= gmail_attr">On Thu, Jan 12, 2023 at 11:32 AM Syed Abdulla <<a href=3D"ma= ilto:[email protected]" target=3D"_blank">[email protected]</= a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p= x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><d= iv dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir= =3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Thank you Clive. I installed the= library libnsl.x86_64. Below I pasted outputs from the commands. I logged = in as root.</div><div dir=3D"ltr"><br><div><div><b><i># dnf install libnsl.= x86_64</i></b></div><div><b><i>Last metadata expiration check: 0:04:34 ago = on Thu 12 Jan 2023 04:22:12 PM UTC.</i></b></div><div><b><i>Package libnsl-= 2.28-189.5.el8_6.x86_64 is already installed.</i></b></div><div><b><i>Depen= dencies resolved.</i></b></div><div><b><i>Nothing to do.</i></b></div><div>= <b><i>Complete!</i></b></div></div><div><br></div><div><b><i>#perl -MCPAN -= e shell</i></b></div><div><b><i>CPAN><span style=3D"background-color:rgb= (245,245,245);color:rgb(51,51,51);font-family:Menlo,Monaco,Consolas,"C= ourier New",monospace;font-size:13px">get DBD::Oracle</span></i></b></= div><div><b><i>CPAN>quit</i></b></div><div><b><i>#cd=C2=A0/root/.cpan/bu= ild/DBD-Oracle-1.83-0</i></b></div><div><b><i>#perl Makefile.PL</i></b></di= v><div><br></div><div>I see the below error again:</div><div><div><b><i>/us= r/bin/ld: cannot find -lnsl</i></b></div><div><b><i>collect2: error: ld ret= urned 1 exit status</i></b></div><div><b><i>make: *** [Makefile:524: blib/a= rch/auto/DBD/Oracle/Oracle.so] Error 1</i></b></div></div><div><b><i><br></= i></b></div><div><b><i>Please help to resolve this issue.</i></b></div><div= ><b><i>Thanks</i></b></div></div></div></div></div></div></div></div><br><d= iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan = 12, 2023 at 9:50 PM Clive Eisen <<a href=3D"mailto:[email protected]= " target=3D"_blank">[email protected]</a>> wrote:<br></div><blockquo= te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px = solid rgb(204,204,204);padding-left:1ex"><div>dnf install libnsl.x86_64<br>= <div><br><blockquote type=3D"cite"><div>On 12 Jan 2023, at 14:25, Syed Abdu= lla <<a href=3D"mailto:[email protected]" target=3D"_blank">syed.= [email protected]</a>> wrote:</div><br><div><div dir=3D"ltr"><div dir= =3D"ltr">Hi,<div><br></div><div><span style=3D"font-family:-apple-system,sy= stem-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue= ","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarel= l,"Droid Sans","Apple Color Emoji","Segoe UI Emoji= ","Segoe UI Emoji","Segoe UI Symbol","Lucida = Grande",Helvetica,Arial,sans-serif;font-size:14px">While installing Pe= rl DBI module to connect to Oracle 19c on RedHat 8 VM, I see the below erro= r and the installation fails.</span><br style=3D"box-sizing:inherit;font-fa= mily:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto= ,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"Oxyge= n Sans",Cantarell,"Droid Sans","Apple Color Emoji"= ,"Segoe UI Emoji","Segoe UI Emoji","Segoe UI Symbo= l","Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px= ;line-height:inherit"><br style=3D"box-sizing:inherit;font-family:-apple-sy= stem,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helveti= ca Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",C= antarell,"Droid Sans","Apple Color Emoji","Segoe U= I Emoji","Segoe UI Emoji","Segoe UI Symbol","= Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px;line-height:i= nherit"><span style=3D"font-family:-apple-system,system-ui,BlinkMacSystemFo= nt,"Segoe UI",Roboto,"Helvetica Neue","Fira Sans&q= uot;,Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans"= ,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Em= oji","Segoe UI Symbol","Lucida Grande",Helvetica,A= rial,sans-serif;font-size:14px">/usr/bin/ld: cannot find -lnsl</span><br st= yle=3D"box-sizing:inherit;font-family:-apple-system,system-ui,BlinkMacSyste= mFont,"Segoe UI",Roboto,"Helvetica Neue","Fira San= s",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans&qu= ot;,"Apple Color Emoji","Segoe UI Emoji","Segoe UI= Emoji","Segoe UI Symbol","Lucida Grande",Helvetic= a,Arial,sans-serif;font-size:14px;line-height:inherit"><span style=3D"font-= family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI",Robo= to,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"Oxy= gen Sans",Cantarell,"Droid Sans","Apple Color Emoji&quo= t;,"Segoe UI Emoji","Segoe UI Emoji","Segoe UI Sym= bol","Lucida Grande",Helvetica,Arial,sans-serif;font-size:14= px">collect2: error: ld returned 1 exit status</span><br style=3D"box-sizin= g:inherit;font-family:-apple-system,system-ui,BlinkMacSystemFont,"Sego= e UI",Roboto,"Helvetica Neue","Fira Sans",Ubuntu,O= xygen,"Oxygen Sans",Cantarell,"Droid Sans","Apple = Color Emoji","Segoe UI Emoji","Segoe UI Emoji",&qu= ot;Segoe UI Symbol","Lucida Grande",Helvetica,Arial,sans-ser= if;font-size:14px;line-height:inherit"><span style=3D"font-family:-apple-sy= stem,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helveti= ca Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",C= antarell,"Droid Sans","Apple Color Emoji","Segoe U= I Emoji","Segoe UI Emoji","Segoe UI Symbol","= Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px">make: *** [M= akefile:524: blib/arch/auto/DBD/Oracle/</span><a href=3D"http://oracle.so/"= style=3D"box-sizing:inherit;font-size:14px;word-break:normal;font-family:-= apple-system,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"= ;Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans= ",Cantarell,"Droid Sans","Apple Color Emoji","= ;Segoe UI Emoji","Segoe UI Emoji","Segoe UI Symbol"= ;,"Lucida Grande",Helvetica,Arial,sans-serif;line-height:inherit"= target=3D"_blank">Oracle.so</a><span style=3D"font-family:-apple-system,sy= stem-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue= ","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarel= l,"Droid Sans","Apple Color Emoji","Segoe UI Emoji= ","Segoe UI Emoji","Segoe UI Symbol","Lucida = Grande",Helvetica,Arial,sans-serif;font-size:14px">] Error 1</span><br= style=3D"box-sizing:inherit;font-family:-apple-system,system-ui,BlinkMacSy= stemFont,"Segoe UI",Roboto,"Helvetica Neue","Fira = Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans= ","Apple Color Emoji","Segoe UI Emoji","Segoe= UI Emoji","Segoe UI Symbol","Lucida Grande",Helve= tica,Arial,sans-serif;font-size:14px;line-height:inherit"><span style=3D"fo= nt-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI",R= oboto,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"= Oxygen Sans",Cantarell,"Droid Sans","Apple Color Emoji&= quot;,"Segoe UI Emoji","Segoe UI Emoji","Segoe UI = Symbol","Lucida Grande",Helvetica,Arial,sans-serif;font-size= :14px">=C2=A0ZARQUON/DBD-Oracle-1.83.tar.gz</span><br style=3D"box-sizing:i= nherit;font-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe U= I",Roboto,"Helvetica Neue","Fira Sans",Ubuntu,Oxyg= en,"Oxygen Sans",Cantarell,"Droid Sans","Apple Col= or Emoji","Segoe UI Emoji","Segoe UI Emoji","= Segoe UI Symbol","Lucida Grande",Helvetica,Arial,sans-serif;= font-size:14px;line-height:inherit"><span style=3D"font-family:-apple-syste= m,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica = Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cant= arell,"Droid Sans","Apple Color Emoji","Segoe UI E= moji","Segoe UI Emoji","Segoe UI Symbol","Luc= ida Grande",Helvetica,Arial,sans-serif;font-size:14px">=C2=A0/usr/bin/= make -- NOT OK</span><br style=3D"box-sizing:inherit;font-family:-apple-sys= tem,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetic= a Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Ca= ntarell,"Droid Sans","Apple Color Emoji","Segoe UI= Emoji","Segoe UI Emoji","Segoe UI Symbol","L= ucida Grande",Helvetica,Arial,sans-serif;font-size:14px;line-height:in= herit"><br style=3D"box-sizing:inherit;font-family:-apple-system,system-ui,= BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",&= quot;Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"= Droid Sans","Apple Color Emoji","Segoe UI Emoji",&= quot;Segoe UI Emoji","Segoe UI Symbol","Lucida Grande&q= uot;,Helvetica,Arial,sans-serif;font-size:14px;line-height:inherit"><span s= tyle=3D"font-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe = UI",Roboto,"Helvetica Neue","Fira Sans",Ubuntu,Oxy= gen,"Oxygen Sans",Cantarell,"Droid Sans","Apple Co= lor Emoji","Segoe UI Emoji","Segoe UI Emoji","= ;Segoe UI Symbol","Lucida Grande",Helvetica,Arial,sans-serif= ;font-size:14px">Has anyone seen this error. Please help to resolve this is= sue.</span><br style=3D"box-sizing:inherit;font-family:-apple-system,system= -ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue&quo= t;,"Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,&q= uot;Droid Sans","Apple Color Emoji","Segoe UI Emoji&quo= t;,"Segoe UI Emoji","Segoe UI Symbol","Lucida Gran= de",Helvetica,Arial,sans-serif;font-size:14px;line-height:inherit"><sp= an style=3D"font-family:-apple-system,system-ui,BlinkMacSystemFont,"Se= goe UI",Roboto,"Helvetica Neue","Fira Sans",Ubuntu= ,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans","Appl= e Color Emoji","Segoe UI Emoji","Segoe UI Emoji",&= quot;Segoe UI Symbol","Lucida Grande",Helvetica,Arial,sans-s= erif;font-size:14px"><br></span></div><div><span style=3D"font-family:-appl= e-system,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Hel= vetica Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans&quo= t;,Cantarell,"Droid Sans","Apple Color Emoji","Seg= oe UI Emoji","Segoe UI Emoji","Segoe UI Symbol",&q= uot;Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px">Thanks.<= /span><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"><div>=C2=A0<= /div><div>This (Quran) is a Message for mankind (and a clear proof against = them), in order that they may be warned thereby, and that they may know tha= t He is the only One God - (The Creator, Sustainer of all and none has the = right to be worshipped but GOD), and that men of understanding may take hee= d. </div><div>=C2=A0</div><div>Holy Quran</div></div></div></div></div> </div></blockquote></div><br></div></blockquote></div><br clear=3D"all"><di= v><br></div>-- <br><div dir=3D"ltr"><div>=C2=A0</div><div>This (Quran) is a= Message for mankind (and a clear proof against them), in order that they m= ay be warned thereby, and that they may know that He is the only One God - = (The Creator, Sustainer of all and none has the right to be worshipped but = GOD), and that men of understanding may take heed. </div><div>=C2=A0</div><= div>Holy Quran</div></div> </blockquote></div> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= class=3D"gmail_signature"><div>=C2=A0</div><div>This (Quran) is a Message = for mankind (and a clear proof against them), in order that they may be war= ned thereby, and that they may know that He is the only One God - (The Crea= tor, Sustainer of all and none has the right to be worshipped but GOD), and= that men of understanding may take heed. </div><div>=C2=A0</div><div>Holy = Quran</div></div> --000000000000d8ec1a05f228fcbf--