ttCacheUidPwdSet
This built-in procedure lets you set the Oracle cache administration user and password within a system-managed wallet in TimesTen to connect to the Oracle database.
You only need to register the Oracle cache administration user ID and password once for each new database. You can change the Oracle cache administration password at any time.
Note:
If you defined CacheAdminWallet=1
as a first connection attribute (in the DSN or on the initial database connection), then the credentials registered with the ttCacheUidPwdSet
are saved in an Oracle Wallet (this is the recommended method). If you defined CacheAdminWallet=0
as a first connection attribute, the credentials are stored in memory. See CacheAdminWallet
.
Required Privilege
This procedure requires the CACHE_MANAGER
privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttCacheUidPwdSet('UID', 'PWD')
Parameters
ttCacheUidPwdSet
has these parameters:
Parameter | Type | Description |
---|---|---|
|
|
The Oracle cache administration user ID that is used for cache operations. It is usually represented in examples as Calling |
|
|
The password for the Oracle cache administration user. It is usually referred as |
Result Set
ttCacheUidPwdSet
returns no results.
Examples
The first example shows setting the Oracle cache administration user and password using ttCacheUidPwdSet
built-in procedure. Then, the example calls ttCacheUidGet
to show the Oracle cache administration user that is set in TimesTen. The next part of the example shows that if you do not provide any values for the Oracle cache administration in the ttCacheUidPwdSet
built-in procedure, then the Oracle cache administration user is erased.
Command> CALL ttCacheUidPwdSet ('cacheadmin','orapwd'); Command> CALL ttCacheUidGet; < CACHEADMIN > 1 row found. Command> CALL ttCacheUidPwdSet(); Command> CALL ttCacheUidGet; < <NULL> > 1 row found.
Notes
-
This procedure cannot be called from an unencrypted client/server connection.
-
This procedure is available only for cache operations
-
For all levels of
DDLReplicationLevel
, you can set the cache administration user ID and password while the cache or replication agents are running. For more details on changing the cache administration user ID or password, see Changing Cache User Names and Passwords in Oracle TimesTen In-Memory Database Cache Guide. -
The cache administration user ID cannot be reset while there are cache groups on the database. The cache administration password can be changed at any time.
See Also