ttAdmin

This utility specifies or changes database policies. It enables you to:

  • Get information about ttAdmin options, version, and settings. See Help, Version, and Query Options.

  • Specify settings for database RAM policy, database start, and database stop. See Perform RAM Operations.

  • Open or close a database to user connections. See Open or Close a Database.

  • Rotate the encryption keys used for encryption at rest. See Encryption at Rest.

  • Run a forced disconnect operation for existing database connections. See Force Disconnect.

  • Start and stop TimesTen cache agents for caching data from Oracle Database tables. The cache agent is a process that handles Oracle Database access on behalf of a TimesTen database. It also handles the aging and autorefresh of the cache groups in the TimesTen database. See Set Cache Policies.

  • Specify settings to automatically or manually start and stop replication agents for specified databases. See Set Replication Policies.

Required Privilege

This utility requires no privileges to query the database.

Cache options require the CACHE_MANAGER privilege.

All other options require the ADMIN privilege.

Syntax

ttAdmin {-h | -help | -?}
ttAdmin {-V | -version}
ttAdmin -query {-connStr connection_string | DSN} 

ttAdmin  [-ramUnload | -ramLoad [-open | -close]]
         [-ramPolicy {always | manual | enduring | inUse [-ramGrace secs]}]
         [-autoreload | -noautoreload]
         [-shmAttach | -shmDetach [-ckpt | -noCkpt] | -shmFree]

         [-disconnect urgency [granularity]] {-connStr connection_string | DSN}]
           urgency: {-transactional | -immediate | -abort}
           granularity: [-users | -unload]

ttAdmin -clientExportAll {FILE}{-connStr connection_string | DSN}
 
ttAdmin -certificateList [-json]

ttAdmin -rekey [-encrAlg algorithm] {-connStr connection_string | DSN}

ttAdmin  [-repPolicy always | manual | norestart]
         [-repStart | -repStop]
         [-repQueryThresholdSet secs]
         [-repQueryThresholdGet]

           [-cacheUidGet]
           [-cacheUidPwdSet -cacheUid uid [-cachePwd pwd]]
           [-cachePolicy {always | manual | norestart}]
           [-cacheStart] 
           [-cacheStop [-stopTimeout secs]]
           {-connStr connection_string | DSN}

Notes

The following notes apply to all modes of ttAdmin usage:

You need to set some environment variables. See Environment Variables in Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide for more details.

The ttAdmin utility is supported only for TimesTen Data Manager DSNs. It is not supported for TimesTen Client DSNs.