Performing an Upgrade of Your Client Instance

You can upgrade your client instance which is being used to access a database in a full instance. For information on instances, see Overview of Installations and Instances and TimesTen Instances for details. For information on Client/Server, see Overview of the TimesTen Client/Server in the Oracle TimesTen In-Memory Database Operations Guide.

To perform the upgrade, follow these steps:

Optional: This step is included for informational purposes to assist you in identifying and verifying the TimesTen client release information.
In the client instance, run the ttVersion utility to verify the client release and the client instance. In this example, running ttVersion in the client instance shows the client release is 22.1.1.25.0 and the client instance is instance_221_client.
```
% ttVersion
TimesTen Release 22.1.1.25.0  (64 bit Linux/x86_64) (instance_221_client)
2024-06-29T23:22:07Z
  Instance home directory: /scratch/instance_221_client
  Group owner: g900
```

Optional: This step is included for informational purposes to establish and then show a client connection to the database1 database. In the client instance, run ttIsqlCS to connect to the database1 database in the full instance (on the server). Note that the TCP_PORT is not specified. The default value is assumed.

% ttIsqlCS -connstr "TTC_SERVER=server.mycompany.com;TTC_SERVER_DSN=database1";
 
Copyright (c) 1996, 2024, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
 
 
 
connect "TTC_SERVER=server.mycompany.com;TTC_SERVER_DSN=database1";
Connection successful: DSN=;TTC_SERVER=server.mycompany.com;
TTC_SERVER_DSN=database1;
...
(Default setting AutoCommit=1)

Stop all applications using the client instance. In this example, in the client instance, first run ttIsqlCS to connect to the database1 database, then exit from ttIsqlCS.

% ttIsqlCS -connstr "TTC_SERVER=server.mycompany.com;
TTC_SERVER_DSN=database1";
 
Copyright (c) 1996, 2021, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
 
 
 
connect "TTC_SERVER=server.mycompany.com;TTC_SERVER_DSN=database1";
Connection successful: DSN=;TTC_SERVER=server.mycompany.com;
TTC_SERVER_DSN=database1;
...
(Default setting AutoCommit=1)
Command> exit
Disconnecting...
Done.

Create a new client installation in a new location. For example, create the clientinstall_new installation directory. Then unzip the new release zip file into that directory. For example, to create an 22.1.1.26.0 installation on Oracle Linux for Intel and AMD, unzip timesten2211260.server.linux8664.zip into the clientinstall_new directory. (Note, there is only one distribution on Linux 64-bit. This distribution contains the server and the client installation.)
```
% mkdir clientinstall_new
% cd clientinstall_new
% unzip /swdir/TimesTen/ttinstallers/timesten2211260.server.linux8664.zip
[...UNZIP OUTPUT...]
```
See TimesTen Installations for detailed information.

Modify the client instance to point to the new installation. Do this by running the ttInstanceModify utility with the -install option from the $TIMESTEN_HOME/bin directory of the client instance.

In this example, point the client instance to the installation in /clientinstall_new/tt22.1.1.26.0.

% $TIMESTEN_HOME/bin/ttInstanceModify -install 
 /clientinstall_new/tt22.1.1.26.0
 
Instance Info (UPDATED)
-----------------------
 
Name:           instance_221_client
Version:        22.1.1.26.0
Location:       /scratch/instance__client
Installation:   /clientinstall_new/tt22.1.1.26.0
 
* Client-Only Installation
 
 
The instance instance_221_client now points to the installation in 
clientinstall_new/tt22.1.1.25.0

Optional: In the client instance, run the ttVersion utility to verify the client release is 22.1.1.26.0.

% ttVersion
TimesTen Release 22.1.1.26.0 (64 bit Linux/x86_64) (instance_221_client) 2021-06-28T22:37:51Z
  Instance home directory: /scratch/instance_221_client
  Group owner: g900

Restart the applications that use the client instance.

In this example, in the client instance, run ttIsqlCS to connect to the database1 database in the full instance.

% ttIsqlCS -connstr "TTC_SERVER=server.mycompany.com;
TTC_SERVER_DSN=database1";
 
Copyright (c) 1996, 2021, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
 
 
 
connect "TTC_SERVER=server.mycompany.com;TTC_SERVER_DSN=database1";
Connection successful: DSN=;TTC_SERVER=server.mycompany.com;
TTC_SERVER_DSN=database1;
...
(Default setting AutoCommit=1)

Optional: Delete the previous release installation (used for the client).

% chmod -R 750 installation_dir/tt22.1.1.26.0
% rm -rf installation_dir/tt22.1.1.26.0