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>