Restricted Commands and SQL Statements

When you use Oracle Clusterware with TimesTen, the active standby pair replication scheme is created on the active database with the ttCWAdmin -create command and dropped with the ttCWAdmin -drop command.

In between the ttCWAdmin -create and ttCWAdmin -drop commands, you cannot run certain commands or SQL statements.

However, you can perform these commands or SQL statements when you use the ttCWAdmin -beginAlterSchema and the ttCWAdmin -endAlterSchema commands, as described in Changing the Schema.

You cannot run the following commands or SQL statements:

• Creating, altering, or dropping the active standby pair with the CREATE ACTIVE STANDBY PAIR, ALTER ACTIVE STANDBY PAIR, and DROP ACTIVE STANDBY PAIR SQL statements.

• Starting or stopping the replication agent with either the -repStart and -repStop options of the ttAdmin utility or the ttRepStart or ttRepStop built-in procedures. For more information, see Starting and Stopping the Replication Agents.

• Starting or stopping the cache agent after the active standby pair has been created with either the -cacheStart and -cacheStop options of the ttAdmin utility or the ttCacheStart and ttCacheStop built-in procedures.

• Duplicating the database with the -duplicate option of the ttRepAdmin utility.

In addition, do not call ttDaemonAdmin -stop before calling ttCWAdmin -shutdown.

The TimesTen integration with Oracle Clusterware accomplishes these operations with the ttCWAdmin utility and the attributes specified in the cluster.oracle.ini file.