Task 2: Start the Cache Agent

Start the ttIsql utility and connect to the cache1 DSN as the TimesTen cache administration user, including the TimesTen cache administration user and its credentials in an Oracle Wallet.

One of the most frequently used TimesTen utilities is the ttIsql utility. This is an interactive SQL utility that serves the same purpose for TimesTen as SQL*Plus does for Oracle Database.

  1. % ttIsql "DSN=cache1;UID=cacheadmin;PwdWallet=/wallets/cacheadminwallet"

    See Connect Using an Oracle Wallet with Credentials for directions on how to create an Oracle Wallet.

  2. Start the cache agent. The cache agent is a TimesTen daemon process that manages many of the cache-related functions for a TimesTen database.

    call ttCacheStart;