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!
http://go.microsoft.com/?linkid=9724465
