Connect Using an Oracle Wallet with Credentials
You can provide credentials for cache administration users by saving them in an Oracle Wallet, which then can be used for connecting to both the TimesTen and Oracle databases.
Use the ttUser -setPwd
command to store the TimesTen cache administration user and password in a wallet. Use the ttUser -setOraclePwd
command to store the Oracle cache administration user and password in a wallet.
This section describes the process to add cache administration user passwords to an Oracle Wallet.
The following example shows how to use the ttUser
utility to add both cache administration users to an Oracle Wallet in the /wallets/cacheadminwallet
directory.
-
If it does not already exist, make a directory for your wallet. This example users
/wallets
as the directory for the wallet.% mkdir /wallets
-
Run the
ttUser -setPwd
command to store the TimesTen cache administration user credentials. ThettUser
utility requires that you provide a subdirectory name that identifies the wallet (since you cannot change the name of an Oracle Wallet). This example providescacheadminwallet
as the subdirectory name for the wallet. Ifcacheadminwallet
directory does not exist, then thettUser
utility creates thecacheadminwallet
subdirectory and then creates the Oracle Wallet in the/wallets/cacheadminwallet
directory. ThettUser
utility prompts for the password for the TimesTen cache administration usercacheadmin
, which is added to the wallet.% ttUser -setPwd -wallet /wallets/cacheadminwallet -uid cacheadmin Enter password:
-
Run the
ttUser -setOraclePwd
command to store the Oracle cache administration user credentials. ThettUser
utility prompts for the password for the Oracle cache administration usercacheadmin
, which is added to the wallet in/wallets/cacheadminwallet
.% ttUser -setOraclePwd -wallet /wallets/cacheadminwallet -uid cacheadmin Enter password:
After the credentials are stored within an Oracle Wallet, provide the user name and location of the wallet on the connection string. The PwdWallet
connection attribute identifies the wallet. The UID
connection attribute identifies which credentials to locate within the wallet.
connect “dsn=cache1;uid=cacheadmin;PwdWallet=/wallets/cacheadminwallet”;
For client/server connections, the wallet must exist on the client.
See Providing the Cache Administration User Names and Passwords in an Oracle Wallet in the Oracle TimesTen In-Memory Database Security Guide for full details on how to store credentials in an Oracle Wallet. See PwdWallet and ttUser in the Oracle TimesTen In-Memory Database Reference.