Oracle Wallet support

[ccorgnet]

Hello Sergei

 

Does Lab128 support wallet connection ?

If not is there any workaround to do so ?

 

Thanks by advance as usual

 

Chris

[Sergei - Lab128]

Chris,

Never done wallet connection before. Can you connect from sqlplus, or other oracle tools? Is that just a few options added to the connect string?
Thanks,

[ccorgnet]

Yes other tools manage it in a rather simple way


- sqlplus :sqlplus /@SID
- TOAD : you use an "EXTERNAL" account and leave the password field blank :

It's rather a nice feature preventing the necessity of providing password for users whose password have been stored in the wallet:

For you information you manage your wallet via a tool named "mkstore" (create, display, update, delete encrypted entries ) and you can use it by providing following lines in your standard sqlnet.ora :

<< sqlnet.ora >> :
WALLET_LOCATION =
(
   SOURCE =
      (METHOD = FILE)
      (METHOD_DATA =
         (DIRECTORY = C:\Oracle\wallet)
      )
)
SQLNET.WALLET_OVERRIDE = TRUE
<< >>

In this example "C:\Oracle\wallet" is the wallet directory containing next 2 encrypted files :
- cwallet.sso
- ewallet.p1


I think Lab128 could handle it the same way that TOAD does with a special username such as EXTERNAL - leaving the pasword field empty.

[Sergei - Lab128]

Chris,

Finally, I am checking the Oracle wallet stored credentials. It seems that you can supply any non-empty username/password and they will be overwritten by Wallet credentials. Can you try something like external/external and see if you can connect. It works for me. 

Regards,

Sergei 

[ccorgnet]

Nop i always get "ORA-01017: invalid username/password; logon denied    " when I enter external inside Lab128 login screen fields.

How did you manage to make Wallet credentials overwrites any non empy username/password ?

FYI the mode is supported so far by all my usual tools (SQL*Plus, SQL Developer, TOAD ...) usually supplying a "OS Authentification" check box so i can'(

[Sergei - Lab128]

On Wednesday, December 19, 2012 4:39:02 AM UTC-5, ccorgnet wrote: