OraclePWD
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 thePWD
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.