Re: Oracle connection error
[email protected] (Syed Abdulla) Thu, 12 Jan 2023 22:02:26 +0530
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <CAGbX+DcwTkBuT4HTtBm_iXLexwoh_FWpMLmefMsuCtD31hrzHQ@mail.gmail.com> |
--00000000000060a55b05f213aa5c Content-Type: text/plain; charset="UTF-8" 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 --00000000000060a55b05f213aa5c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di= r=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Thank you Clive. I installed th= e 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>Depe= ndencies 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:rg= b(245,245,245);color:rgb(51,51,51);font-family:Menlo,Monaco,Consolas,"= Courier 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/b= uild/DBD-Oracle-1.83-0</i></b></div><div><b><i>#perl Makefile.PL</i></b></d= iv><div><br></div><div>I see the below error again:</div><div><div><b><i>/u= sr/bin/ld: cannot find -lnsl</i></b></div><div><b><i>collect2: error: ld re= turned 1 exit status</i></b></div><div><b><i>make: *** [Makefile:524: blib/= arch/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><di= v><b><i>Thanks</i></b></div></div></div></div></div></div></div></div><br><= div 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]= m">[email protected]</a>> wrote:<br></div><blockquote 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><blockqu= ote type=3D"cite"><div>On 12 Jan 2023, at 14:25, Syed Abdulla <<a href= =3D"mailto:[email protected]" target=3D"_blank">syed.abdulla08@gmail= .com</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,system-ui,BlinkMac= SystemFont,"Segoe UI",Roboto,"Helvetica Neue","Fir= a Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sa= ns","Apple Color Emoji","Segoe UI Emoji","Seg= oe UI Emoji","Segoe UI Symbol","Lucida Grande",Hel= vetica,Arial,sans-serif;font-size:14px">While installing Perl DBI module to= connect to Oracle 19c on RedHat 8 VM, I see the below error and the instal= lation fails.</span><br style=3D"box-sizing:inherit;font-family:-apple-syst= em,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica= Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Can= tarell,"Droid Sans","Apple Color Emoji","Segoe UI = Emoji","Segoe UI Emoji","Segoe UI Symbol","Lu= cida Grande",Helvetica,Arial,sans-serif;font-size:14px;line-height:inh= erit"><br style=3D"box-sizing:inherit;font-family:-apple-system,system-ui,B= linkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",&q= uot;Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"D= roid Sans","Apple Color Emoji","Segoe UI Emoji",&q= uot;Segoe UI Emoji","Segoe UI Symbol","Lucida Grande&qu= ot;,Helvetica,Arial,sans-serif;font-size:14px;line-height:inherit"><span st= yle=3D"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">/usr/bin/ld: cannot find -lnsl</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">collect2: er= ror: ld returned 1 exit status</span><br style=3D"box-sizing:inherit;font-f= amily:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI",Robot= o,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"Oxyg= en Sans",Cantarell,"Droid Sans","Apple Color Emoji"= ;,"Segoe UI Emoji","Segoe UI Emoji","Segoe UI Symb= ol","Lucida Grande",Helvetica,Arial,sans-serif;font-size:14p= x;line-height:inherit"><span style=3D"font-family:-apple-system,system-ui,B= linkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",&q= uot;Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"D= roid Sans","Apple Color Emoji","Segoe UI Emoji",&q= uot;Segoe UI Emoji","Segoe UI Symbol","Lucida Grande&qu= ot;,Helvetica,Arial,sans-serif;font-size:14px">make: *** [Makefile:524: bli= b/arch/auto/DBD/Oracle/</span><a href=3D"http://oracle.so/" style=3D"box-si= zing:inherit;font-size:14px;word-break:normal;font-family:-apple-system,sys= tem-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 G= rande",Helvetica,Arial,sans-serif;line-height:inherit" target=3D"_blan= k">Oracle.so</a><span style=3D"font-family:-apple-system,system-ui,BlinkMac= SystemFont,"Segoe UI",Roboto,"Helvetica Neue","Fir= a Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sa= ns","Apple Color Emoji","Segoe UI Emoji","Seg= oe UI Emoji","Segoe UI Symbol","Lucida Grande",Hel= vetica,Arial,sans-serif;font-size:14px">] Error 1</span><br style=3D"box-si= zing:inherit;font-family:-apple-system,system-ui,BlinkMacSystemFont,"S= egoe UI",Roboto,"Helvetica Neue","Fira Sans",Ubunt= u,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans","App= le Color 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= -system,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helv= etica Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans"= ;,Cantarell,"Droid Sans","Apple Color Emoji","Sego= e UI Emoji","Segoe UI Emoji","Segoe UI Symbol",&qu= ot;Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px">=C2=A0ZAR= QUON/DBD-Oracle-1.83.tar.gz</span><br style=3D"box-sizing:inherit;font-fami= ly:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,&= quot;Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen = Sans",Cantarell,"Droid Sans","Apple Color Emoji",&= quot;Segoe UI Emoji","Segoe UI Emoji","Segoe UI Symbol&= quot;,"Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px;l= ine-height:inherit"><span style=3D"font-family:-apple-system,system-ui,Blin= kMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue","= ;Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droi= d Sans","Apple Color Emoji","Segoe UI Emoji","= ;Segoe UI Emoji","Segoe UI Symbol","Lucida 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-system,system-ui,Bl= inkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",&qu= ot;Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Dr= oid Sans","Apple Color Emoji","Segoe UI Emoji",&qu= ot;Segoe UI Emoji","Segoe UI Symbol","Lucida Grande&quo= t;,Helvetica,Arial,sans-serif;font-size:14px;line-height:inherit"><br style= =3D"box-sizing:inherit;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;line-height:inherit"><span style=3D"font-fam= ily:-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;font-size:14px"= >Has anyone seen this error. Please help to resolve this issue.</span><br s= tyle=3D"box-sizing:inherit;font-family:-apple-system,system-ui,BlinkMacSyst= emFont,"Segoe UI",Roboto,"Helvetica Neue","Fira Sa= ns",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans&q= uot;,"Apple Color Emoji","Segoe UI Emoji","Segoe U= I Emoji","Segoe UI Symbol","Lucida Grande",Helveti= ca,Arial,sans-serif;font-size:14px;line-height:inherit"><span style=3D"font= -family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI",Rob= oto,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"Ox= ygen Sans",Cantarell,"Droid Sans","Apple Color Emoji&qu= ot;,"Segoe UI Emoji","Segoe UI Emoji","Segoe UI Sy= mbol","Lucida Grande",Helvetica,Arial,sans-serif;font-size:1= 4px"><br></span></div><div><span style=3D"font-family:-apple-system,system-= ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue"= ;,"Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,&qu= ot;Droid Sans","Apple Color Emoji","Segoe UI Emoji"= ;,"Segoe UI Emoji","Segoe UI Symbol","Lucida Grand= e",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 that He is the onl= y One God - (The Creator, Sustainer of all and none has the right to be wor= shipped but GOD), and that men of understanding may take heed. </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" class=3D"gmail_signature"><div>=C2=A0</= div><div>This (Quran) is a Message for mankind (and a clear proof against t= hem), 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 r= ight to be worshipped but GOD), and that men of understanding may take heed= . </div><div>=C2=A0</div><div>Holy Quran</div></div> --00000000000060a55b05f213aa5c--