1. Reference
  2. Connection Attributes
  3. Cache Connection Attributes
  4. Cache General Connection Attributes
  5. OraclePWD

OraclePWD

When using TimesTen for caching, the OraclePWD attribute is the password the Oracle cache administration user provides to connect to the Oracle database to perform cache operations. These cache operations include, for example, cache group SQL, passthrough, and ttLoadFromOracle.

For more information about cache group SQL operations, see Setting a Passthrough Level in Oracle TimesTen In-Memory Database Cache Guide. For information about loading data from Oracle Database and using ttLoadFromOracle, see Use TimesTen Built-In Procedures to Recommend a Table and Load SQL Query Results in Oracle TimesTen In-Memory Database Operations Guide.

Notes:

  • The name for the Oracle cache administration user must be the same as the TimesTen cache administration user.

  • To specify the TimesTen cache administration user name, use UID.

  • To specify the TimesTen cache administration password, use PWD.

  • The value of the OraclePWD attribute can be different from the value specified for the PWD attribute.

Required Privilege

No privilege is required to set the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

You can use the OraclePWD attribute to register an Oracle password in the connection string. However, we recommend you to store your passwords in a wallet. See Providing Cache Administration User Credentials When Connecting in Oracle TimesTen In-Memory Database Cache Guide.

If you decide to use the OraclePWD attribute to create an Oracle password, suppose you have defined the following odbc.ini file on Linux: 

[myDSN]
Datastore=/data/myDSN
PermSize=512
TempSize=256
LogBufMB=256
LogFileSize=256
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
OracleNetServiceName=ttorcl

The example specifies OraclePWD as myoraclepwd for user cacheadmin by connecting to myDSN. The TimesTen cache administration password PWD is pwd. The Oracle cache administration user is not the instance administrator. 

% ttisql
Copyright (c) 1996, 2022, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.

Command> connect"DSN=myDSN;UID=cacheadmin;PWD=mypwd;OraclePWD=myoraclepwd";
Connection successful:
DSN=myDSN;UID=cacheadmin;DataStore=/=/data/myDSN;DatabaseCharacterSet=AL32UTF8;
ConnectionCharacterSet=AL32UTF8;LogFileSize=256;LogBufMB=256;PermSize=512;
TempSize=256;OracleNetServiceName=ttorcl;(Default setting AutoCommit=1)

To connect using Windows, you must provide the OraclePWD in the connect string. The following example provides the cache administration user, the TimesTen cache administration user password and the Oracle cache administration user password. 

ttIsql -connStr "DSN=database1CS;UID=cacheadmin;PWD=mypwd;OraclePWD=orapwd;"
In TimesTen Scaleout, this attribute can be set in a connectable or a connection string. See Connecting to a Database in Oracle TimesTen In-Memory Database Scaleout User's Guide.
Also see