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:[email protected]]
>> Sent: Tuesday, April 20, 2010 6:51 AM
>> To: Howard, Chris; [email protected]
>> 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: [email protected]
>>> To: [email protected]
>>>
>>> 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>
>>