My script attaches to the database then does a query of sysdate from dual.
Error shl_load failed for: libclntsh.sl.10.1, [errno 2: No such file or directory] /usr/lib/dld.sl: Can't open shared library: libclntsh.sl.10.1 /usr/lib/dld.sl: No such file or directory Error shl_load failed for: libclntsh.sl.10.1, [errno 2: No such file or directory] /usr/lib/dld.sl: Can't open shared library: libclntsh.sl.10.1 /usr/lib/dld.sl: No such file or directory 21-APR-2010 As you can see, it complains a lot but actually does perform. I haven't tried your SHLIB_PATH ideas yet.. will do that. Chris > -----Original Message----- > From: John Scoles [mailto:sco...@pythian.com] > Sent: Wednesday, April 21, 2010 12:59 PM > To: Howard, Chris > Cc: John Scoles; dbi-users@perl.org > Subject: Re: Problems with external password store. > > Howard, Chris wrote: > > Can you send the error message just for fun. > > Cheers > John > > I wasn't too clear. > > > > The scripts give error message complaints, but they > > actually do work. > > > > Chris > > > > > > > >> -----Original Message----- > >> From: Howard, Chris [mailto:howa...@prpa.org] > >> Sent: Wednesday, April 21, 2010 12:39 PM > >> To: John Scoles > >> Cc: John Scoles; dbi-users@perl.org > >> Subject: RE: Problems with external password store. > >> > >> I am rebuilding my DBD installation on server A (the one > >> where Oracle Wallet didn't work) > >> > >> I set my environment for oracle 10g, then did the > >> install again. > >> > >> I have wallet working, but every time I run a script I > >> get two copies of a dld.sl error for libclntsh.sl.10.1 > >> > >> I think I can live with that for awhile and try to > >> clean it up on a scheduled maintenance day. I'll do > >> a $ORACLE_HOME/bin/genclntsh and see if that helps. > >> > >> I have to tell you all, I love DBI/DBD and use it a lot. > >> But the installation has always seemed to be difficult, > >> and it keeps me from being enthusiastic to throw on the > >> latest releases. When I get it working I just leave > >> it alone. Not that I don't sympathize with the difficulty > >> of building an install that works against Oracle, particularly > >> in the pre-8 days. And I'm on HP-UX which also has > >> it's quirks. > >> > >> > >> > >> > >>> -----Original Message----- > >>> From: John Scoles [mailto:sco...@pythian.com] > >>> Sent: Tuesday, April 20, 2010 8:38 AM > >>> To: Howard, Chris > >>> Cc: John Scoles; dbi-users@perl.org > >>> Subject: Re: Problems with external password store. > >>> > >>> > >>>> Yes you can find out with ORA_OCI > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> use DBD::Oracle qw(:ora_types); > >>>> > >>>> print DBD::Oracle::ORA_OCI > >>>> > >>>> > >>>> > >>>> I think will work > >>>> > >>>> Cheers > >>>> > >>>> John > >>>> > >>>> > >>>> > >>>> Only one wallet is involved, and one connection. > >>>> > >>>> The Oracle Client issue might be in play. I think > >>>> the case where wallet is not working right may > >>>> have been compiled against an Oracle 8 client. > >>>> It is a pretty old installation. > >>>> > >>>> Is there any way to tell which client is in use? > >>>> > >>>> > >>>> > >>>> > >>>> > >>>>> -----Original Message----- > >>>>> From: John Scoles [mailto:byter...@hotmail.com] > >>>>> Sent: Tuesday, April 20, 2010 6:51 AM > >>>>> To: Howard, Chris; dbi-users@perl.org > >>>>> Subject: RE: Problems with external password store. > >>>>> > >>>>> If you are trying to connect to both at the same time using two > >>>>> different wallets I am afraid you are out of luck. > >>>>> > >>>>> Seems once a SQLNET.ORA file is read it is 'READ' and cannot be > >>>>> reloaded so only one wallet can be used at a time. > >>>>> > >>>>> It will take the first valid one it finds and use that. > >>>>> > >>>>> Are you using two wallets and are you trying to connect to both > >>>>> > > at > > > >>> the > >>> > >>>>> same time?? > >>>>> > >>>>> Your DBD::Oracle is rather old but there is no differance in the > >>>>> > >> way > >> > >>>>> 1.24 and 1.16 connect using wallet. > >>>>> > >>>>> That being said your DBD::Oracle might of been compiled against > >>>>> > > or > > > >>> is > >>> > >>>>> using an older Oracle client. Do you know which Oracle client > >>>>> > > you > > > >>> are > >>> > >>>>> using?? > >>>>> > >>>>> > >>>>> Cheers > >>>>> John Scoles > >>>>> > >>>>> > >>>>> > >>>>> > >>>>>> Subject: Problems with external password store. > >>>>>> Date: Mon, 19 Apr 2010 10:42:16 -0600 > >>>>>> From: howa...@prpa.org > >>>>>> To: dbi-users@perl.org > >>>>>> > >>>>>> I have two database servers, there are some differences > >>>>>> between the way that perl dbd/dbi is installed on these > >>>>>> machines, but both are running HP-UX and Oracle 10g. > >>>>>> > >>>>>> I am trying to use external password store (oracle wallet) > >>>>>> to change scripts with embedded login information to be > >>>>>> more secure. > >>>>>> > >>>>>> On server B, I configured oracle wallet to use the > >>>>>> $HOME/.sqlnet.ora file. It work fine with sqlplus > >>>>>> and with a very simple perl script. > >>>>>> > >>>>>> On server A, I configured oracle wallet the same way > >>>>>> and it works fine with sqlplus, but the same > >>>>>> simple perl script gives me "invalid username/password" > >>>>>> errors. > >>>>>> > >>>>>> I have some version differences between the two machines. > >>>>>> > >>>>>> Server B is using DBI 1.601, DBD 1.16, Perl 5.8.8 > >>>>>> Server A is using DBI 1.43, DBD 1.16, Perl 5.8.5 > >>>>>> > >>>>>> I may be able to get them eventually on exactly parallel > >>>>>> > > versions > > > >>>>>> but that will take quite a bit of time and effort. > >>>>>> > >>>>>> Any hope for forward progress otherwise? > >>>>>> > >>>>>> Chris Howard > >>>>>> > >>>>>> > >>>>>> > >>>>> ________________________________ > >>>>> > >>>>> Videos that have everyone talking! Now also in HD! MSN.ca Video. > >>>>> <http://go.microsoft.com/?linkid=9724460> > >>>>> > >>>>>
