Multi-instance Installation and Uninstallation

This chapter describes how to install and uninstall multiple instances.

Installation

In Unix (Linux), multiple instances from different databases can be simultaneously installed.

These instances can share a single Tibero binary execution file and a Tibero license file, but their TB_SID and configuration file (.tip) must be separately configured.

Unix

The manual installation process of Tibero in a Unix environment is basically the same as in the single instance installation. The steps are as follows:

1. Install a Tibero instance by referring to “Unix” in installation page.

Note

This document assumes that the first instance contains the following environment variables.

Environment Variable	Value
TB_HOME	/home/tibero/Tibero/tibero7
TB_SID	tibero1
LD_LIBRARY_PATH	$TB_HOME/lib:$TB_HOME/client/lib
PATH	$PATH:$TB_HOME/bin:$TB_HOME/client/bin

1. Set another TB_SID variable for a second instance. It must be set to a value that is different from the first variable.

export TB_SID=tibero2

1. Enter the following command from the $TB_HOME/config directory.

gen_tip.sh

This command creates a configuration file (.tip) as well as tbdsn.tbr and psm_commands files.

tibero@Tibero:~/Tibero/tibero7/config$ gen_tip.sh
Using TB_SID "tibero2"
/home/tibero/Tibero/tibero7/config/tibero2.tip generated
/home/tibero/Tibero/tibero7/config/psm_commands generated
/home/tibero/Tibero/tibero7/client/config/tbdsn.tbr generated. 
Running client/config/gen_esql_cfg.sh
Done.

1. Open the configuration file created in the $TB_HOME/config directory, and set the LISTENER_PORT value differently from the first instance's setting.

tibero@Tibero:~/Tibero/tibero7/config$ cat tibero2.tip
......Omitted......

DB_NAME=tibero2 
LISTENER_PORT=9629
......Omitted......

Warning

The initialization parameters _LSNR_SPECIAL_PORT, _LSNR_SSL_PORT and CM_PORT are respectively set to LISTENER_PORT+1, LISTENER_PORT+2, LISTENER_PORT+3 by default.

Therefore, when setting LISTENER_PORT, the values of the initialization parameters LISTENER_PORT, _LSNR_SPECIAL_PORT, _LSNR_SSL_PORT and CM_PORT for the new instance must be set differently from the previously installed instance.

1. The subsequent steps are the same as in “Unix” in installation page from step 5.

In step 7 of “Unix”, however, when creating a database with the CREATE DATABASE statement, you need to modify the path of log files or data files in accordance with the new instance's TB_SID.

---

Uninstallation

This section describes the uninstallation process of existing multi-instances.

Unix

The manual uninstallation process of Tibero multi-instances for Unix is basically the same as in the single instance uninstallation.

This document assumes that the existing instances contain the following environment variables.

Environment Variable	Value
TB_HOME	/home/tibero/Tibero/tibero7
TB_SID	tibero1
	tibero2
LD_LIBRARY_PATH	$TB_HOME/lib:$TB_HOME/client/lib
PATH	$PATH:$TB_HOME/bin:$TB_HOME/client/bin

1. Set the TB_SID environment variable of the first Tibero instance to delete, and then shut down the instance.

export TB_SID=tibero1 
tbdown

1. Set the TB_SID environment variable of another instance to delete, and then shut down the instance.

export TB_SID=tibero2 
tbdown

1. Delete the Tibero installation directory as well as all the subdirectories by using the OS's command.

rm –rf $TB_HOME