Performing an Offline TimesTen Upgrade when Using Oracle Clusterware

This section discusses the steps for an offline upgrade of TimesTen when using TimesTen with Oracle Clusterware. Since TimesTen replication with Oracle Clusterware is not supported on Linux for ARM (aarch64) systems, the information in this section is not applicable if you are using Linux for ARM (aarch64).

You have the option of also upgrading Oracle Clusterware, independently, while upgrading TimesTen. (See Performing an Online TimesTen Upgrade When Using Oracle Clusterware for details on online upgrade.)

Note:

  • These instructions apply for either a TimesTen patch upgrade (for example, from 22.1.w.x to 22.1.y.z) or a TimesTen major upgrade (for example, from 18.1 to 22.1).

  • Refer to the Oracle TimesTen In-Memory Database Release Notes for information about versions of Oracle Clusterware that are supported by TimesTen.

For this procedure, except where noted, you can execute the ttCWAdmin commands from any host in the cluster. Each command affects all hosts.

  1. Stop the replication agents on the databases in the active standby pair:
    ttCWAdmin -stop -dsn advancedDSN
    
  2. Drop the active standby pair:
    ttCWAdmin -drop -dsn advancedDSN
    
  3. Stop the TimesTen cluster agent. This removes the hosts from the cluster and stops the TimesTen daemon:
    ttCWAdmin -shutdown
    
  4. Upgrade TimesTen on the desired hosts.
  5. Upgrade Oracle Clusterware if desired.
  6. If you have upgraded Oracle Clusterware, use the ttInstanceModify utility to configure TimesTen with Oracle Clusterware. On each host, run:
    ttInstanceModify -crs
    

    For Linux or UNIX hosts, see Change the Oracle Clusterware Configuration for an Instance for details.

  7. Start the TimesTen cluster agent. This includes the hosts defined in the cluster as specified in ttcrsagent.options. This also starts the TimesTen daemon.
    ttCWAdmin -init
    
  8. Create the active standby pair replication scheme:
    ttCWAdmin -create -dsn advancedDSN
    

    Important: The host from which you run this command must have access to the cluster.oracle.ini file. (See Configuring Oracle Clusterware Management with the cluster.oracle.ini File in the Oracle TimesTen In-Memory Database Replication Guide for information about this file.)

  9. Start the active standby pair replication scheme:
    ttCWAdmin -start -dsn advancedDSN