mORMot Open Source

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,544

Website

Oracle Wallet support

In this commit we add Oracle Wallet support to SynDBOracle.

To not store connection credentials (user name / password) for Oracle connection you can use the External Password Store.
In this case set TSQLDBOracleConnectionProperties.UseWallet to true.

Wallet configuration is performed on the computer where server is running. You must perform full Oracle 32bit client setup - using of InstantClient is not possible with wallets.
Steps to create Wallet:
1) create a folder for you wallet

> mkdir c:\OraWallets 

2) Create a wallet on the client by using the following syntax at the command line:

> mkstore -wrl c:\OraWallets -create

   Oracle will ask you the wallet password - remember it!
3) Create database connection credentials in the wallet by using the following syntax at the command line:
 

 mkstore -wrl c:\OraWallets -createCredential TNS_alias_name_from_tnsnames_ora username password 

  where password is the password of database user. Oracle will ask you the wallet password - use the password from previous step.

4) In the client sqlnet.ora file, add the WALLET_LOCATION parameter and set it to the directory location of the wallet and set SQLNET.WALLET_OVERRIDE parameter to TRUE
sqlnet.ora
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
  (DIRECTORY = c:\OraWallets)
  )
)

You can not drop database while it has wallet. You can delete wallet credentials by the next command

mkstore -wrl wallet_location -deleteCredential db_alias

Oracle will ask you the wallet password - use the same password which you used for creation wallet

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,238

Website

Re: Oracle Wallet support

Nice!

I've updated the documentation to add information about this feature.
See http://synopse.info/fossil/info/885dcbab80
and http://synopse.info/files/html/Synopse% … l#TITL_117