Document Type | Technical Information

Category | Installation

Applicable Product Version | Tibero 7.2.2

Document Number | TINTI041

Overview

This guide explains how to configure TAC on TAS using Tibero Cluster Manager.

It uses VirtualBox to set up two Virtual Machines and configure a shared disk.

The OS used for testing is Rocky Linux 8.10.

Method

1. Preparations before Installation

1.1. Upload Binary and Extract

In this test, Tibero 7.2.2 (tibero7-bin-FS02_PS02-linux64_4.18-285045-20250107070637.tar.gz) is used.
Upload it to both Virtual Machines and extract it using the tar command.

$ tar -xvzf tibero7-bin-FS02_PS02-linux64_4.18-285045-20250107070637.tar.gz

1.2. License Setup

$ mv license.xml $TB_HOME/license/

1.3. OS Kernel Parameter Settings

$ vi /etc/sysctl.conf

# MEMORY based on 9G
kernel.sem = 10000 32000 10000 10000
kernel.shmmax = 5092931584
kernel.shmall = 1243391
kernel.shmmni = 4096
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576

$ sysctl -p
$ ulimit -n 65536


$ vi /etc/security/limits.conf
tibero soft nproc 16384
tibero hard nproc 16384
tibero soft nofile 65536
tibero hard nofile 65536
tibero soft core 0
tibero hard core 0

$ vi /etc/systemd/logind.conf
# RemoveIPC = no

$ systemctl restart systemd-logind

2. Installation

2.1. Configuration Details

Configure TAS-TAC with the following information.

	Item	NODE 1	NODE 2
OS	Hostname	rocky	rocky
OS	User	tibero	tibero
TAS	SID	tas1	tas2
	DB NAME	tas
	Listener PORT	18629	18629
	Inter-connect PORT	19629	19629
TAC	SID	DBPIW1	DBPIW2
	DB NAME	DBPIW
	Listener PORT	8629	8629
	Inter-connect PORT	11019	11019
CM	SID	cm0	cm1
	Listener PORT	11029	11029
	CM_UI_PORT	11039	11039
TAS/TAC	LOCAL_CLUSTER_ADDR	10.10.10.1	10.10.10.2

2.2. Network Settings

interconnect: 10.10.10.1 / 10.10.10.2

RIP: 192.168.56.51 / 192.168.56.52

VIP: 192.168.56.55 / 192.168.56.56

2.3. Environment Variable Settings

$ vi .bash_profile

NODE 1

NODE 2

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PS1="[`whoami`@`hostname`:\$PWD]$"
export PATH

# Java ENV
export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.462.b08-3.el9.x86_64
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=$CLASSPATH:$JAVA_HOME/jre/lib/ext:$JAVA_HOME/lib/tools.jar

### Tibero 7 ENV ###
export TB_BASE=/home/tibero/jb24
export TB_HOME=$TB_BASE/tibero7
export TB_SID=DBPIW1
export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$TB_BASE/tbinary/monitor:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH

######## TIBERO alias ########
alias tbhome='cd $TB_HOME'
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 tbprocess='ps -ef | grep tbsvr'
alias tbcliv='vi $TB_HOME/client/config/tbdsn.tbr'
export TBINARY_PATH=$TB_BASE/tbinary
alias tbi='cd $TBINARY_PATH'
alias tm='cd $TBINARY_PATH/monitor;monitor;cd -'

### TEST ENV ###
export TB_SQLPATH=$TB_HOME
### User ENV ###
#export LANG=ko_KR.eucKR
#export LANG=C
set -o vi
stty erase ^H
stty erase ^?
#export EDITOR=vi
#export TERM=vt100
export PS1="[`whoami`@`hostname`:\$PWD]$"

### TIBERO CLUSTERE MANAGER ###
export CM_HOME=$TB_HOME
export CM_SID=cm0

### Alias For tbcm ###
alias cmcfgv='vi $CM_HOME/config/$CM_SID.tip'
alias cmlog='cd $CM_HOME/instance/$CM_SID/log'
alias show='cmrctl show'

tac(){
export TB_SID=DBPIW1
}

tas(){
export TB_SID=tas1
}

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

# Java ENV
export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.462.b08-3.el9.x86_64
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=$CLASSPATH:$JAVA_HOME/jre/lib/ext:$JAVA_HOME/lib/tools.jar

### Tibero 7 ENV ###
export TB_BASE=/home/tibero/jb24
export TB_HOME=$TB_BASE/tibero7
export TB_SID=DBPIW2
export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$TB_BASE/tbinary/monitor:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH

### TIBERO CLUSTERE MANAGER ###
export CM_HOME=$TB_HOME
export CM_SID=cm1

### Alias For tbcm ###
alias cmcfgv='vi $CM_HOME/config/$CM_SID.tip'
alias cmlog='cd $CM_HOME/instance/$CM_SID/log'
alias show='cmrctl show'

tac(){
export TB_SID=DBPIW2
}

tas(){
export TB_SID=tas2
}

2.4. Create and Edit TAS tip File

Run tas to apply TAS SID. (Applied as an alias in .bash_profile)

NODE 1 (tas1.tip)

NODE 2 (tas2.tip)

### DATABASE ###
DB_NAME=tas
LISTENER_PORT=18629

### MEMORY ###
MAX_SESSION_COUNT=30
TOTAL_SHM_SIZE=1G
MEMORY_TARGET=2G

CLUSTER_DATABASE=Y
THREAD=0
LOCAL_CLUSTER_ADDR=10.10.10.1
LOCAL_CLUSTER_PORT=19629
CM_PORT=11039

INSTANCE_TYPE=AS
AS_DISKSTRING="/dev/tas/*"
AS_ALLOW_ONLY_RAW_DISKS=N
AS_WTHR_CNT=2

### DATABASE ###
DB_NAME=tas
LISTENER_PORT=18629

### MEMORY ###
MAX_SESSION_COUNT=30
TOTAL_SHM_SIZE=1G
MEMORY_TARGET=2G

CLUSTER_DATABASE=Y
THREAD=1
LOCAL_CLUSTER_ADDR=10.10.10.2
LOCAL_CLUSTER_PORT=19629
CM_PORT=11039

INSTANCE_TYPE=AS
AS_DISKSTRING="/dev/tas/*"
AS_ALLOW_ONLY_RAW_DISKS=N
AS_WTHR_CNT=2

2.5. Create and Edit TAC tip File

Run tac to apply TAC SID. (Applied as an alias in .bash_profile)

NODE 1 (DBPIW1.tip)

NODE 2 (DBPIW2.tip)

# tip file generated from /home/tibero/jb/tibero7/config/tip.template (Mon Sep 1 16:54:32 KST 2025)
#-------------------------------------------------------------------------------
#
# RDBMS initialization parameter
#
#-------------------------------------------------------------------------------

DB_NAME=DBPIW
LISTENER_PORT=8629
CONTROL_FILES="+DS_DATA/control/c1.ctl"

DB_CREATE_FILE_DEST="+DS_DATA/DBPIWDBF"
LOG_ARCHIVE_DEST="/home/tibero/jb24/tbarch"

MAX_SESSION_COUNT=20

TOTAL_SHM_SIZE=2G
MEMORY_TARGET=3G

##TAC
THREAD=0
UNDO_TABLESPACE=UNDO0
CLUSTER_DATABASE=Y

# TAS
USE_ACTIVE_STORAGE=Y
AS_PORT=18629

##CM
LOCAL_CLUSTER_ADDR=10.10.10.1
LOCAL_CLUSTER_PORT=11029
CM_PORT=11039

USE_TS_QUOTA=N
SLOG_DISPLAY_YEAR=Y
AUTHENTICATION_TIMEOUT=100
DBLINK_CONN_TIMEOUT=100
GATHER_SQL_EXEC_TIME=Y
GATHER_SQL_PLAN_STAT=Y
DBWR_USE_AIO=N
_MISC_SHP_ALLOC_MAX_RATIO=80

_ENABLE_LOG_MINER=Y
_DDL_TRIGGER_ENABLE=Y
_SPAN_UNDO=N

# tip file generated from /home/tibero/jb/tibero7/config/tip.template (Mon Sep 1 18:11:00 KST 2025)
#-------------------------------------------------------------------------------
#
# RDBMS initialization parameter
#
#-------------------------------------------------------------------------------

DB_NAME=DBPIW
LISTENER_PORT=8629
CONTROL_FILES="+DS_DATA/control/c1.ctl"

DB_CREATE_FILE_DEST="+DS_DATA/DBPIWDBF"
LOG_ARCHIVE_DEST="/home/tibero/jb24/tbarch"

MAX_SESSION_COUNT=20

TOTAL_SHM_SIZE=2G
MEMORY_TARGET=3G

##TAC
THREAD=1
UNDO_TABLESPACE=UNDO1
CLUSTER_DATABASE=Y

# TAS
USE_ACTIVE_STORAGE=Y
AS_PORT=18629

##CM
LOCAL_CLUSTER_ADDR=10.10.10.2
LOCAL_CLUSTER_PORT=11029
CM_PORT=11039

USE_TS_QUOTA=N
SLOG_DISPLAY_YEAR=Y
AUTHENTICATION_TIMEOUT=100
DBLINK_CONN_TIMEOUT=100
GATHER_SQL_EXEC_TIME=Y
GATHER_SQL_PLAN_STAT=Y
DBWR_USE_AIO=N
_MISC_SHP_ALLOC_MAX_RATIO=80

_ENABLE_LOG_MINER=Y
_DDL_TRIGGER_ENABLE=Y
_SPAN_UNDO=N

2.6. Create CM tip File

NODE 1 (cm0.tip)

NODE 2 (cm1.tip)

CM_UI_PORT=11039
CM_NAME=cm0
CM_RESOURCE_FILE=/home/tibero/jb24/tibero7/config/cm0_res.crf
CM_ENABLE_FAST_NET_ERROR_DETECTION=Y

CM_HEARTBEAT_EXPIRE=90
CM_WATCHDOG_EXPIRE=80

CM_UI_PORT=11039
CM_NAME=cm1
CM_RESOURCE_FILE=/home/tibero/jb24/tibero7/config/cm1_res.crf
CM_ENABLE_FAST_NET_ERROR_DETECTION=Y

CM_HEARTBEAT_EXPIRE=90
CM_WATCHDOG_EXPIRE=80

2.7. Edit tbdsn.tbr

NODE 1

NODE 2

DBPIW1=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=DBPIW)
)
)

tas1=(
(INSTANCE=(HOST=localhost)
(PORT=18629)
(DB_NAME=tas)
)
)

DBPIW=(
(INSTANCE=(HOST=localhost)
        (PORT=8629)
     (DB_NAME=DBPIW)
)
(INSTANCE=(HOST=192.168.56.52)
        (PORT=8629)
     (DB_NAME=DBPIW)
)
     (LOAD_BALANCE=Y)
     (USE_FAILOVER=Y)
)

DBPIW2=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=DBPIW)
)
)

tas2=(
(INSTANCE=(HOST=localhost)
(PORT=18629)
(DB_NAME=tas)
)
)

DBPIW=(
(INSTANCE=(HOST=localhost)
        (PORT=8629)
     (DB_NAME=DBPIW)
)
(INSTANCE=(HOST=192.168.56.51)
        (PORT=8629)
     (DB_NAME=DBPIW)
)
     (LOAD_BALANCE=Y)
     (USE_FAILOVER=Y)
)

Execute on NODE1

$ echo $TB_SID - confirm tas1

$ tbboot nomount

2.12. Create Diskspace

Execute on NODE1

$ tbsql sys/tibero@tas1

SQL> CREATE DISKSPACE DS_DATA force
EXTERNAL REDUNDANCY
FAILGROUP DFG1
DISK '/dev/tas/disk01' NAME disk1 SIZE 20G
attribute 'AU_SIZE'='4M';

2.13. Start Cluster

Execute on NODE1

$ cmrctl start cluster --name cls

$ cmrctl show

2.14. Register TAS Service in CM

Execute on NODE1

$ cmrctl add service --name tas --cname cls --type as

2.15. Register TAS Instance in CM

Execute on NODE1

$ cmrctl add as --name tas1 --svcname tas --dbhome $TB_HOME

2.16. Start TAS Instance

Execute on NODE1

$ cmrctl start as --name tas1

2.17. Add Thread for NODE2 TAS Instance

Execute on NODE1

$ tbsql sys/tibero@tas1

SQL> alter diskspace DS_DATA add thread 1;

2.18. Register TAC Service and DB Instance in CM

Execute on NODE1

$ cmrctl add service --name DBPIW --cname cls --type db

$ cmrctl add db --name DBPIW1 --svcname DBPIW --dbhome $TB_HOME

2.19. Start TAC

Execute on NODE1

$ tbboot nomount

2.20. Create Database

Execute on NODE1

$ tbsql sys/tibero@tac

SQL> create database
user sys identified by tibero
character set UTF8 -- UTF8, EUCKR, ASCII, MSWIN949
logfile group 0 ('+DS_REDO/redo1/redo00A.redo','+DS_REDO/redo2/redo00B.redo') size 100M,
group 1 ('+DS_REDO/redo1/redo01A.redo','+DS_REDO/redo2/redo01B.redo') size 100M,
group 2 ('+DS_REDO/redo1/redo02A.redo','+DS_REDO/redo2/redo02B.redo') size 100M
maxdatafiles 4096
maxlogfiles 100
maxlogmembers 8
archivelog
datafile '+DS_DATA/DBPIWDBF/system001.dtf' size 1G autoextend off --system
default tablespace USR
datafile '+DS_DATA/DBPIWDBF/usr001.dtf' size 1G autoextend off --usr
default temporary tablespace TEMP
tempfile '+DS_DATA/DBPIWDBF/temp001.dtf' size 1G autoextend off -- temp
undo tablespace UNDO0
datafile '+DS_DATA/DBPIWDBF/undo001.dtf' size 1G autoextend off --undo
syssub datafile '+DS_DATA/DBPIWDBF/tpr_ts.dtf' size 1G autoextend off; --syssub

2.21. Add undo and redo for Thread of NODE2 TAC Instance

Execute on NODE1

$ cmrctl show

$ tbsql sys/tibero@tac

SQL> create undo tablespace UNDO1 datafile '+DS_DATA/DBPIWDBF/undo002.dtf' size 1G autoextend off;

SQL> alter database add logfile thread 1 group 3 ('+DS_REDO/redo1/redo03A.redo','+DS_REDO/redo2/redo03B.redo') size 100M;
SQL> alter database add logfile thread 1 group 4 ('+DS_REDO/redo1/redo04A.redo','+DS_REDO/redo2/redo04B.redo') size 100M;
SQL> alter database add logfile thread 1 group 5 ('+DS_REDO/redo1/redo05A.redo','+DS_REDO/redo2/redo05B.redo') size 100M;

SQL> alter database enable public thread 1;

2.22. Run system.sh

Execute on NODE1

$ sh $TB_HOME/scripts/system.sh -p1 tibero -p2 syscat -a1 y -a2 y -a3 y -a4 y

Execute on NODE2

$ cmrctl start as --name tas2

$ show

2.29. Register TAC Instance in CM

Execute on NODE2

$ cmrctl add db --name DBPIW2 --svcname DBPIW --dbhome $TB_HOME

$ show

2.30. Start TAC Second Time

Execute on NODE2

$ tbboot

2.31. Register VIP

Start as OS root account, then apply tibero account .bash_profile

$ tbcm -b

$ cmrctl add vip --name vip1 --node cm0 --svcname DBPIW --ipaddr 192.168.56.55

$ cmrctl add vip --name vip2 --node cm1 --svcname DBPIW --ipaddr 192.168.56.56

Normal Screen

업무 외 시간 안내

Search

Welcome to Tibero GTS!

Overview

Method

1. Preparations before Installation

1.1. Upload Binary and Extract

1.2. License Setup

1.3. OS Kernel Parameter Settings

2. Installation

2.1. Configuration Details

2.2. Network Settings

2.3. Environment Variable Settings

2.4. Create and Edit TAS tip File

2.5. Create and Edit TAC tip File

2.6. Create CM tip File

2.7. Edit tbdsn.tbr

2.8. Start tbcm

2.9. Register network in CM

2.10. Register cluster in CM

2.11. Start TAS Instance

2.12. Create Diskspace

2.13. Start Cluster

2.14. Register TAS Service in CM

2.15. Register TAS Instance in CM

2.16. Start TAS Instance

2.17. Add Thread for NODE2 TAS Instance

2.18. Register TAC Service and DB Instance in CM

2.19. Start TAC

2.20. Create Database

2.21. Add undo and redo for Thread of NODE2 TAC Instance

2.22. Run system.sh

2.23. Start tbcm

2.24. Register network in CM

2.25. Register cluster in CM

2.26. Start Cluster

2.27. Register TAS Instance in CM

2.28. Start TAS Instance

2.29. Register TAC Instance in CM

2.30. Start TAC Second Time

2.31. Register VIP

Normal Screen