ttCWAdmin

Description

Manages TimesTen active standby pairs that take advantage of the high availability framework of Oracle Clusterware. This utility starts administrative processes, generates scripts and performs other functions to administer active standby pairs and the corresponding Clusterware resources.

For more information about using Oracle Clusterware to manage TimesTen active standby pairs, see Oracle TimesTen In-Memory Database TimesTen to TimesTen Replication Guide. Also see Chapter 5, "Clusterware Attributes for TimesTen."

Required privilege

This utility requires the instance administrator privilege.

On Linux and UNIX, these commands must be executed by the root user:

ttCWAdmin -createVIPs
ttCWAdmin -dropVIPs

If authentication information is not supplied in the connection string or DSN, this utility prompts for a user ID and password before continuing.

Syntax

ttCWAdmin {-h | -help | -?}

ttCWAdmin {-V | -version}

ttCWAdmin -init [-hosts "host_name1, host_name2[, ...]"]

ttCWAdmin {-createVIPs | -dropVIPs | -create | -drop | -restore | -start |
           -stop | -status} [-ttclusterini path] -dsn DSN

ttCWAdmin -shutdown [-hosts "host_name1, host_name2[, ...]"]

Options

ttCWAdmin has these general options:

Option	Description
`-create`	Creates the active standby pair replication scheme for the specified DSN and creates the associated action scripts. This command prompts for the user ID and password for an internal user with the ADMIN privilege if it does not find this information in the `sys.odbc.ini` file. This command also prompts for a passphrase for the encryption of stored authentication information. This internal user will be used to create the active standby pair. If CacheConnect is enabled, the command also prompts for the user password for the Oracle database. The Oracle password is used to set the autorefresh states for cache groups.
`-createVIPs`	Creates virtual IP addresses for the active standby pair.
`-drop`	Drops the active standby pair replication scheme and deletes its action scripts.
`-dropVIPs`	Drops the virtual IP addresses for the active standby pair.
`-h` `-help` `-?`	Prints a usage message and exits.
`-init`	Starts the TimesTen cluster agent.
`-restore`	Restores the active master data store from the backup specified by RepBackupDir. Do not use this command when AutoRecover is enabled.
`-shutdown`	Stops the TimesTen cluster agent.
`-start`	Starts the active standby pair.
`-status`	Obtains the status of resources in the cluster.
`-stop`	Stops the active standby pair.
`-dsn` `DSN`	Specifies the DSN for the active standby pair.
`-hosts "host_name1,` `host_name2[, ...]`"	Specifies the hosts on which to start or shut down the TimesTen cluster agent. If this option is not specified, the TimesTen cluster agent is started or stopped on all hosts.
`-ttclusterini` `path`	Specifies the full path name of the `cluster.oracle.ini` file. The default location is in the daemon home directory. The default location is recommended.
`-V \| -version`	Prints the release number of `ttCWAdmin` and exits.

Examples

To create and start an active standby pair managed by Oracle Clusterware, using the clusterDSN DSN, enter:

ttCWAdmin -create -dsn clusterDSN
ttCWAdmin -start -dsn clusterDSN

To stop and drop an active standby pair managed by Oracle Clusterware, using the clusterDSN DSN, enter:

ttCWAdmin -stop -dsn clusterDSN
ttCWAdmin -drop -dsn clusterDSN