Oracle Audio Technologies B31679-01 manual Limitations, Requirements

16.	Wait for all of the updates to
	propagate to the upgrade system.

17.Reconnect all applications to the upgrade data store.

After the above procedures have been carried out on the upgrade system, the active system can be upgraded using the same steps.

Limitations

Online upgrades can be performed only on data stores for which all the user tables meet the replication requirements. All the user tables must contain either a PRIMARY KEY declaration or have a unique index declared over non-nullable columns.

Requirements

To perform online upgrades with replication, replication must be configured to use static ports. See “Dynamic vs. static port assignments” on page 55 of the TimesTen to TimesTen Replication Guide.

If you are performing an online upgrade on a single system where a bidirectional replication configuration does not already exist, you must make sure that enough memory and disk space is available to support two copies of the data store being upgraded. Both the original data store and its copy will be active for the duration of the upgrade. To maintain the performance of your production applications, you may wish to create the copy of the data store on a second system.

Additional disk space must be allocated to hold a backup copy of the data store made by the ttMigrate utility. The size of the backup copy is typically about the same as the in-use size of the data store. This size may be determined by querying the sys.monitor table, using ttIsql:

Command> SELECT perm_in_use_size FROM sys.monitor;

Data Store Upgrades 107