Installation

This chapter explains how to install the Tibero client in manual mode.

Installation in manual mode

1. Prepare the installation file(tar.gz) and license file(license.xml).

1. Create client account.

$ useradd -d /home/tibero7_client -g dba tibero7_client
$ passwd tibero7_client

1. Unzip the binary archive.

$ ls
tibero7-bin-FS02-windows64_2008-269353-20240314021215.zip

$ unzip tibero7-bin-FS02-linux64_3.10-254994.tar.gz

1. Configure the profile.

   Modify the content to suit the environment and add it to the profile of the client server.

```shell
$ vi ~/.bash_profile
export TB_HOME=/home/tibero7_client/tibero7 export TB_SID=tibero
export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export   LD_LIBRARY_PATH=$TB_HOME/client/lib:$LD_LIBRARY_PATH

$ source ~/.bash_profile

1. Copy the license file(license.xml) to the directory, $TB_HOME/license.

1. Execute gen_tip.sh.

$ cd $TB_HOME/config

$ sh gen_tip.sh Using TB_SID "tibero"
/home/tibero7_client/tibero7/config/tibero.tip generated
/home/tibero7_client/tibero7/config/psm_commands generated
/home/tibero7_client/tibero7/client/config/tbdsn.tbr generated. 
Running client/config/gen_esql_cfg.sh
Done.

1. Configure the network file (tbdsn). tbdsn.tbr file configures the server connection path, and it is located in $TB_HOME/client/config. Manually configure tbdsn.tbr as the following guide.

$ cd $TB_HOME/client/config

$ ls
gen_esql_cfg.sh tbco_file_id tbdsn.tbr	tbimport_hl.config.default tbpcb.cfg 
tbc_file_id	tbdfdump.cfg tbertl.cfg tbpc.cfg

$ vi tbdsn.tbr 
#------------------------------------------------------------
# /home/tibero7_client/tibero7/client/config/tbdsn.tbr 
# Network Configuration File.
# Generated by gen_tip.sh at 2023. 06. 12. (월) 14:30:16 KST
tibero=(
    (INSTANCE=(HOST=192.168.xxx.xxx) 
              (PORT=8629)
              (DB_NAME=tibero)
     )
)

1. Access to Tibero Server with Tibero Client.

/tbsql tibero/tmax


TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> SELECT
    IPADDR, USERNAME 
FROM
    V$SESSION;	2	3	4

IPADDR
----------------------------------------------------------
USERNAME
-----------------------------------------------------------------------------------
192.168.xxx.xxx
TIBERO