Skip to main content

Search

Welcome to Tibero GTS!

How to Set OS Profile for Multi-Instance Configuration

Document Type | Technical Information

Category | Installation

Applicable Product Version | Tibero 7.2.4

Document Number | TINTI016

Overview

This document guides you through how to configure the profile settings when using Tibero 7 multi-instance with a shared engine in Linux and Unix environments, using examples. 

Test Environment

  • DB: Tibero 7 (DB 7.2.4)
  • OS: Rocky Linux 9.6
  • Shell: bash

Note

You can find the OS profile setting method for Unix environments for versions earlier than Tibero 7 in the post below.

OS Profile Settings for Multi-Instance Use 

 

Method

1. Create .bash_profile

The red text in the example below should be changed according to your environment.

### Tibero 7 ENV ###
TB_HOME="/home/tibero/tibero7"
TB_PROF_DIR="$TB_HOME/bin/prof"

PATH=".:$TB_HOME/bin:$TB_HOME/client/bin:$PATH"
LD_LIBRARY_PATH="$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH"

export TB_HOME TB_PROF_DIR PATH LD_LIBRARY_PATH

#########################################
# Tibero SID Selection Menu
#########################################

VALUE=true

while [ "$VALUE" = true ]
do
   echo "SELECT TIBERO_SID"
   echo "------------------------------"
   echo "1. tibero01"
   echo "2. tibero02"
   echo "------------------------------"

   printf "%s" "---ANS> "
   read ans

   echo "------------------------------"

   case "$ans" in
       1)
           TB_SID="tibero01"
           VALUE=false
           ;;
       2)
           TB_SID="tibero02"
           VALUE=false
           ;;
       *)
           echo "Invalid input. Please select again."
           sleep 1
           ;;
   esac
done

export TB_SID

echo "#################################"
echo "## Tibero instance is $TB_SID ##"
echo "#################################"

# \w not usable โ†’ in sh, `pwd` must be called
PS1="[$TB_SID@`hostname`:\$(pwd)] "
export PS1

######## TIBERO alias ########
alias tbhome='cd "$TB_HOME"'
alias tbbin='cd "$TB_HOME/bin"'
alias tblog='cd "$TB_HOME/instance/$TB_SID/log"'
alias tbcfg='cd "$TB_HOME/config"'
alias tbcfgv='vi "$TB_HOME/config/$TB_SID.tip"'
alias tbcli='cd "$TB_HOME/client/config"'
alias tbcliv='vi "$TB_HOME/client/config/tbdsn.tbr"'

alias tbi='cd "$HOME/tbinary"'
alias tm='cd "$HOME/tbinary/monitor" ; monitor ; cd -'

 

2. Apply .bash_profile

Apply this to the profile of the OS account where Tibero is installed. Depending on the shell type, the .profile file may be used instead of .bash_profile.

. ~/.bash_profile or source ~/.bash_profile

 

3. Result

Each time the profile is applied or the OS account logs in, you can select the SID as shown below.

Enter the number corresponding to the Tibero SID you want to use and press Enter to access the selected instance.

SELECT TIBERO_SID
------------------------------
1. tibero01
2. tibero02
------------------------------

 


 

Related to