Manage In-Memory Database and Clusterware

The following four tasks are the most common management tasks once the active standby pair have been created by Oracle Clusterware:

1. Check the cluster agent status

a. Check the TimesTen cluster agents by executing the ttCWAdmin -status command on one of the hosts. eg on mobile-qa4:
   
ttCWAdmin -status -dsn repdb1_1121
   
  ttCWAdmin -status after start

2. Stop the Active Standby Pair

a. Stop the Active Standby Pair by executing the ttCWAdmin -stop command on one of the hosts. eg on mobile-qa4:
   
ttCWAdmin -stop -dsn repdb1_1121
   
  ttCWAdmin -stop
   
b. Check the cluster status after doing ttCWAdmin -stop
   
ttCWAdmin -status -dsn repdb1_1121
   
  ttCWAdmin -status after stop

3. Drop the Active Standby Pair

a. Drop the Active Standby Pair by executing the ttCWAdmin -drop command on one of the hosts.
eg on mobile-qa4:
   
ttCWAdmin -drop -dsn repdb1_1121
   
  ttCWAdmin -drop
   
b. Check the cluster status after doing ttCWAdmin -drop
   
ttCWAdmin -status -dsn repdb1_1121
   
  ttCWAdmin -status after drop

4. Shutdown the cluster agents

a. Shutdown the cluster agents by executing the ttCWAdmin -shutdown command on one of the hosts. eg on mobile-qa4:
   
ttCWAdmin -shutdown
   
  ttCWAdmin -shutdown
   
b. Check the cluster status after doing ttCWAdmin -shutdown
   
ttCWAdmin -status -dsn repdb1_1121
   
  ttCWAdmin -status after shutdown
   
  The ttCWAdmin status succeeds as it is querying Oracle Clusterware which is still running.