Re: Oracle connection error
[email protected] (Richard Dice) Thu, 12 Jan 2023 22:42:06 -0500
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <CAPPqpsqvWrnpAX7wn+QXV4FJnNDA_mzcbU3HA7ff-a2MadQSeQ@mail.gmail.com> |
--0000000000001eeb2f05f21d050f Content-Type: text/plain; charset="UTF-8" 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 > --0000000000001eeb2f05f21d050f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Where is the library installed to?=C2=A0 In what directory= ?<div><br></div><div>Is that directory referenced in the /etc/ld.so.conf fi= le?</div><div><br></div><div>If not, add it and then run "ldconfig&quo= t; command, then re-try.</div><div><br></div><div><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"mailto:[email protected]= om">[email protected]</a>> wrote:<br></div><blockquote class=3D"g= mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204= ,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"l= tr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Tha= nk 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><di= v><b><i># dnf install libnsl.x86_64</i></b></div><div><b><i>Last metadata e= xpiration check: 0:04:34 ago on Thu 12 Jan 2023 04:22:12 PM UTC.</i></b></d= iv><div><b><i>Package libnsl-2.28-189.5.el8_6.x86_64 is already installed.<= /i></b></div><div><b><i>Dependencies resolved.</i></b></div><div><b><i>Noth= ing 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,"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/build/DBD-Oracle-1.83-0</i></b></div><div><b><i>= #perl Makefile.PL</i></b></div><div><br></div><div>I see the below error ag= ain:</div><div><div><b><i>/usr/bin/ld: cannot find -lnsl</i></b></div><div>= <b><i>collect2: error: ld returned 1 exit status</i></b></div><div><b><i>ma= ke: *** [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><div><b><i>Thanks</i></b></div></div></div></div><= /div></div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" clas= s=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>&= gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0= px 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 Abdulla <<a href=3D"mailto:syed.abdulla08@gmail= .com" target=3D"_blank">[email protected]</a>> wrote:</div><br><d= iv><div dir=3D"ltr"><div dir=3D"ltr">Hi,<div><br></div><div><span style=3D"= font-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI"= ,Roboto,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,&quo= t;Oxygen Sans",Cantarell,"Droid Sans","Apple Color Emoj= i","Segoe UI Emoji","Segoe UI Emoji","Segoe U= I Symbol","Lucida Grande",Helvetica,Arial,sans-serif;font-si= ze:14px">While installing Perl DBI module to connect to Oracle 19c on RedHa= t 8 VM, I see the below error and the installation fails.</span><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"><br style=3D"box-sizing= :inherit;font-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe= UI",Roboto,"Helvetica Neue","Fira Sans",Ubuntu,Ox= ygen,"Oxygen Sans",Cantarell,"Droid Sans","Apple C= olor Emoji","Segoe UI Emoji","Segoe UI Emoji",&quo= t;Segoe UI Symbol","Lucida Grande",Helvetica,Arial,sans-seri= f;font-size:14px;line-height:inherit"><span style=3D"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">/usr/bin/ld: = cannot find -lnsl</span><br style=3D"box-sizing:inherit;font-family:-apple-= system,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helve= tica Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans"= ,Cantarell,"Droid Sans","Apple Color Emoji","Segoe= UI Emoji","Segoe UI Emoji","Segoe UI Symbol",&quo= t;Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px;line-height= :inherit"><span style=3D"font-family:-apple-system,system-ui,BlinkMacSystem= Font,"Segoe UI",Roboto,"Helvetica Neue","Fira Sans= ",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans&quo= t;,"Apple Color Emoji","Segoe UI Emoji","Segoe UI = Emoji","Segoe UI Symbol","Lucida Grande",Helvetica= ,Arial,sans-serif;font-size:14px">collect2: error: ld returned 1 exit statu= s</span><br style=3D"box-sizing:inherit;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&= quot;,Helvetica,Arial,sans-serif;font-size:14px;line-height:inherit"><span = style=3D"font-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe= UI",Roboto,"Helvetica Neue","Fira Sans",Ubuntu,Ox= ygen,"Oxygen Sans",Cantarell,"Droid Sans","Apple C= olor Emoji","Segoe UI Emoji","Segoe UI Emoji",&quo= t;Segoe UI Symbol","Lucida Grande",Helvetica,Arial,sans-seri= f;font-size:14px">make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/</span= ><a href=3D"http://oracle.so/" style=3D"box-sizing:inherit;font-size:14px;w= ord-break:normal;font-family:-apple-system,system-ui,BlinkMacSystemFont,&qu= ot;Segoe UI",Roboto,"Helvetica Neue","Fira Sans",U= buntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans","= ;Apple Color Emoji","Segoe UI Emoji","Segoe UI Emoji&qu= ot;,"Segoe UI Symbol","Lucida Grande",Helvetica,Arial,s= ans-serif;line-height:inherit" target=3D"_blank">Oracle.so</a><span style= =3D"font-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI&q= uot;,Roboto,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,= "Oxygen Sans",Cantarell,"Droid Sans","Apple Color = Emoji","Segoe UI Emoji","Segoe UI Emoji","Seg= oe UI Symbol","Lucida Grande",Helvetica,Arial,sans-serif;fon= t-size:14px">] Error 1</span><br style=3D"box-sizing:inherit;font-family:-a= pple-system,system-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"= Helvetica Neue","Fira Sans",Ubuntu,Oxygen,"Oxygen Sans&= quot;,Cantarell,"Droid Sans","Apple Color Emoji","= Segoe UI Emoji","Segoe UI Emoji","Segoe UI Symbol"= ,"Lucida Grande",Helvetica,Arial,sans-serif;font-size:14px;line-h= eight:inherit"><span style=3D"font-family:-apple-system,system-ui,BlinkMacS= ystemFont,"Segoe UI",Roboto,"Helvetica Neue","Fira= Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,"Droid San= s","Apple Color Emoji","Segoe UI Emoji","Sego= e UI Emoji","Segoe UI Symbol","Lucida Grande",Helv= etica,Arial,sans-serif;font-size:14px">=C2=A0ZARQUON/DBD-Oracle-1.83.tar.gz= </span><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">=C2=A0/usr/bin/make -- NOT OK</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"><br style=3D"box-sizing:inherit;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;line-height:inherit"><span style=3D"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&= quot;,Helvetica,Arial,sans-serif;font-size:14px">Has anyone seen this error= . Please help to resolve this issue.</span><br style=3D"box-sizing:inherit;= font-family:-apple-system,system-ui,BlinkMacSystemFont,"Segoe UI"= ,Roboto,"Helvetica Neue","Fira Sans",Ubuntu,Oxygen,&quo= t;Oxygen Sans",Cantarell,"Droid Sans","Apple Color Emoj= i","Segoe UI Emoji","Segoe UI Emoji","Segoe U= I Symbol","Lucida Grande",Helvetica,Arial,sans-serif;font-si= ze:14px;line-height:inherit"><span style=3D"font-family:-apple-system,syste= m-ui,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue&qu= ot;,"Fira Sans",Ubuntu,Oxygen,"Oxygen Sans",Cantarell,&= quot;Droid Sans","Apple Color Emoji","Segoe UI Emoji&qu= ot;,"Segoe UI Emoji","Segoe UI Symbol","Lucida Gra= nde",Helvetica,Arial,sans-serif;font-size:14px"><br></span></div><div>= <span style=3D"font-family:-apple-system,system-ui,BlinkMacSystemFont,"= ;Segoe UI",Roboto,"Helvetica Neue","Fira Sans",Ubu= ntu,Oxygen,"Oxygen Sans",Cantarell,"Droid Sans","A= pple Color Emoji","Segoe UI Emoji","Segoe UI Emoji"= ;,"Segoe UI Symbol","Lucida Grande",Helvetica,Arial,san= s-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 man= kind (and a clear proof against them), in order that they may be warned the= reby, and that they may know that He is the only One God - (The Creator, Su= stainer of all and none has the right to be worshipped but GOD), and that m= en 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"><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> --0000000000001eeb2f05f21d050f--