Document Type | Technical Information
Category | Installation
Applicable Product Version | 7FS04PS
Document Number | TINTI046
Overview
This document describes how to configure TSC + Observer in Tibero7.
Test Environment
Configured with 2 servers, creating tibero user on Primary Node, and obs, tibero users on Standby Node.
- OS: CentOS Linux release 8.4.2105
- Tibero: Tibero 7.2.4 (build 303667)
Method
Pre-installation Checks
Build Options
The observer operates using the tbcmobs executable. tbcmobs is located in the $TB_HOME/bin directory, and the binary must be built with compile options set for observer mode. (Linux is compiled in observer mode by default.)
To verify, run tbboot -version and check that the compiled with options include "-D_CM_OBSERVER".
[tibero@kimmi ~]$ tbboot -version
Tibero 7 (DB 7.2.4) Build 303667
Linux bistro-build-centos_8.4 5.15.0-134-generic #145~20.04.1-Ubuntu SMP Mon Feb 17 13:27:16 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux version (little-endian)
Patch files (FS02PS_700093a FS02PS_700103a FS02PS_344166f FS02PS_700110a FS02PS_342949f)
Compiled with "cc -no-pie -ggdb -fstack-protector-all -fno-strict-aliasing -fno-omit-frame-pointer -pipe -O3 -D_OPT_COMPILED -U_FORTIFY_SOURCE -D_USE_VIP -Wall -W -Werror-implicit-function-declaration -Wno-unused-parameter -Wpointer-arith -Wdeclaration-after-statement -DHAVE_CONFIG_H -D_WORDSIZE=64 -D_OS_LINUX -D_LINUX_X86_64 -D_X86 -DUSE_ASSERT -DTSAM -DTSAM_NO_ESDS_SEQUENCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_USE_FSYNC -D_CHECK_LICENSE -D_STBLOG -D_TAC -DFD_SETSIZE=8192 -D_CM_OBSERVER -D_USE_FALLOCATE -D_GNU_SOURCE -D_GNU_SOURCE -D_GNU_SOURCE -D_GNU_SOURCE -DHAVE_EPOLL"
Compiled at Oct 13 2025 01:59:51 build seq 303667 init rev {2023-11-24}
Installation
1. User Creation and Environment Setup
1.1 Primary Node
-- tibero user $ groupadd dba $ useradd -d /home/tibero -g dba tibero $ su - tibero $ vi .bash_profile ### Tibero 7 ENV ### export TB_HOME=/home/tibero/tibero7 export TB_SID=tsc_P export TB_PROF_DIR=$TB_HOME/bin/prof export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH ### Cluster Manager ENV ### export CM_HOME=$TB_HOME export CM_SID=PRIMARY
1.2 Standby Node
-- tibero user $ groupadd dba $ useradd -d /home/tibero -g dba tibero $ su - tibero $ vi .bash_profile ### Tibero 7 ENV ### export TB_HOME=/home/tibero/tibero7 export TB_SID=tsc_S export TB_PROF_DIR=$TB_HOME/bin/prof export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH ### Cluster Manager ENV ### export CM_HOME=$TB_HOME export CM_SID=PRIMARY -- obs user $ su - $ useradd -d /home/obs -g dba obs $ su - obs $ vi .bash_profile ### Tibero 7 ENV ### export TB_HOME=/home/obs/tibero7 export TB_PROF_DIR=$TB_HOME/bin/prof export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH ### Cluster Manager ENV ### export CM_HOME=$TB_HOME export CM_SID=OBSERVER
2. Extract Binary
2.1 Primary Node
$ su - tibero $ tar -xvzf tibero7-bin-FS02_PS03-linux64_4.18-295003-20250604143651.tar.gz
2.2 Standby Node
$ su - tibero $ tar -xvzf tibero7-bin-FS02_PS03-linux64_4.18-295003-20250604143651.tar.gz $ su - obs $ tar -xvzf tibero7-bin-FS02_PS03-linux64_4.18-295003-20250604143651.tar.gz
3. Apply License
Upload the license matching the hostname and ncpu information to each server.
3.1 Primary Node
$ su - tibero $ vi $TB_HOME/license/license.xml
3.2 Standby Node
$ su - tibero $ vi $TB_HOME/license/license.xml
Note
The observer user does not require a license.
4. $CM_SID.tip Configuration
Configure $TB_HOME/config/$CM_SID.tip for each user.
4.1 Primary Node
-- tibero $ vi $TB_HOME/config/$CM_SID.tip CM_NAME=PRIMARY CM_UI_PORT=18632 CM_RESOURCE_FILE=/home/tibero/tibero7/config/cm_res CM_HEARTBEAT_EXPIRE=300 CM_WATCHDOG_EXPIRE=290
4.2 Standby Node
-- tibero $ vi $TB_HOME/config/$CM_SID.tip CM_NAME=STANDBY CM_UI_PORT=18632 CM_RESOURCE_FILE=/home/tibero/tibero7/config/cm_res CM_HEARTBEAT_EXPIRE=300 CM_WATCHDOG_EXPIRE=290 -- obs $ vi $TB_HOME/config/$CM_SID.tip CM_NAME=OBSERVER CM_MODE_OBSERVER=Y CM_OBSERVER_PORT=9050 CM_UI_PORT=28632
5. $TB_SID.tip Configuration
5.1 Primary Node
-- tibero $ vi $TB_HOME/config/$TB_SID.tip DB_NAME=tsc LISTENER_PORT=8629 CONTROL_FILES="/home/tibero/tbdata/c1.ctl" DB_CREATE_FILE_DEST="/home/tibero/tbdata" LOG_ARCHIVE_DEST="/home/tibero/tbarch" MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=1G MEMORY_TARGET=2G ### TSC Primary DB ENV ### LOG_REPLICATION_MODE=PERFORMANCE LOG_REPLICATION_DEST_1="172.16.59.111:8633 LGWR ASYNC" ## Standby DB IP:PPORT+4 ### TBCM Primary ENV ### STANDBY_USE_OBSERVER=Y CM_PORT=18632 ## Must match CM_UI_PORT set in $CM_SID.tip LOCAL_CLUSTER_ADDR=172.16.59.110 ## local IP LOCAL_CLUSTER_PORT=15000
5.2 Standby Node
-- tibero $ vi $TB_HOME/config/$TB_SID.tip DB_NAME=tsc LISTENER_PORT=8629 CONTROL_FILES="/home/tibero/tbdata/c1.ctl" DB_CREATE_FILE_DEST="/home/tibero/tbdata" LOG_ARCHIVE_DEST="/home/tibero/tbarch" MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=1G MEMORY_TARGET=2G ### TSC STANDBY DB ENV ### LOG_REPLICATION_MODE=PERFORMANCE LOG_REPLICATION_DEST_1="172.16.59.110:8633 LGWR ASYNC" ## Primary DB IP:PPORT+4 ### TBCM STANDBY ENV ### STANDBY_USE_OBSERVER=Y CM_PORT=18632 ## Must match CM_UI_PORT set in $CM_SID.tip LOCAL_CLUSTER_ADDR=172.16.59.111 ## local IP LOCAL_CLUSTER_PORT=15000
Note
The observer user does not require $TB_SID.tip configuration.
6. tbdsn.tbr Configuration
6.1 Primary Node
-- tibero
$ vi $TB_HOME/client/config/tbdsn.tbr
tsc_P=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=tsc)
)
)
6.2 Standby Node
-- tibero
$ vi $TB_HOME/client/config/tbdsn.tbr
tsc_S=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=tsc)
)
)Note
The observer user does not require tbdsn.tbr configuration.
7. Start Observer
$ su - obs $ tbcmobs -b TBCM OBSERVER MODE 7.1.1 (Build 303667) TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero cluster manager observer started up. Local observer name is (OBSERVER:28632).
8. Start Primary CM and Register Resources
8.1 Start Primary CM
$ su - tibero $ tbcm -b CM Guard daemon started up. import resources from '/home/tibero/tibero7/config/cm_res'... TBCM 7.1.1 (Build 303667) TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero cluster manager started up. Local node name is (PRIMARY:18632).
8.2 Resource Registration
8.2.1 Register private network
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
NO RESOURCE
=====================================================================
$ cmrctl add network --name net0 --ipaddr 172.16.59.110 --portno 29000
Resource add success! (network, net0)
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net0 UP (private) 172.16.59.110/29000
=====================================================================
8.2.2 Register public network
$ cmrctl add network --name pub0 --nettype public --ifname ens33
Resource add success! (network, pub0)
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net0 UP (private) 172.16.59.110/29000
COMMON network pub0 UP (public) ens33
=====================================================================
8.2.3 Register cluster
$ cmrctl add cluster --name cls0 --incnet net0 --pubnet pub0 --cfile /home/tibero/tibero7/config/cls0_cfile
Resource add success! (cluster, cls0)
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net0 UP (private) 172.16.59.110/29000
COMMON network pub0 UP (public) ens33
COMMON cluster cls0 DOWN inc: net0, pub: pub0
=====================================================================
8.2.4 Start cluster
$ cmrctl start cluster --name cls0
MSG SENDING SUCCESS!
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net0 UP (private) 172.16.59.110/29000
COMMON network pub0 UP (public) ens33
COMMON cluster cls0 UP inc: net0, pub: pub0
cls0 file cls0:0 UP /home/tibero/tibero7/config/cls0_cfile
=====================================================================
8.2.5 Register service
$ cmrctl add service --name tsc --cname cls0 --tscid 11 --obsip 172.16.59.111 --obsport 9050
Resource add success! (service, tsc)
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net0 UP (private) 172.16.59.110/29000
COMMON network pub0 UP (public) ens33
COMMON cluster cls0 UP inc: net0, pub: pub0
cls0 file cls0:0 UP /home/tibero/tibero7/config/cls0_cfile
cls0 service tsc DOWN Database, Active Cluster (auto-restart: OFF)
=====================================================================
8.2.6 Register DB
$ cmrctl add db --name tsc_P --svcname tsc --dbhome /home/tibero/tibero7 --envfile /home/tibero/.bash_profile
Resource add success! (db, tsc_P)
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net0 UP (private) 172.16.59.110/29000
COMMON network pub0 UP (public) ens33
COMMON cluster cls0 UP inc: net0, pub: pub0
cls0 file cls0:0 UP /home/tibero/tibero7/config/cls0_cfile
cls0 service tsc DOWN Database, Active Cluster (auto-restart: OFF)
cls0 db tsc_P DOWN tsc, /home/tibero/tibero7, failed retry cnt: 0
=====================================================================
8.2.7 Register VIP
$ cmrctl add vip --name vip0 --node PRIMARY --svcname tsc --ipaddr 192.168.41.117/255.255.255.0 --bcast 192.168.41.255
Resource add success! (vip, vip0)
$ cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net0 UP (private) 172.16.59.110/29000
COMMON network pub0 UP (public) ens33
COMMON cluster cls0 UP inc: net0, pub: pub0
cls0 file cls0:0 UP /home/tibero/tibero7/config/cls0_cfile
cls0 service tsc DOWN Database, Active Cluster (auto-restart: OFF)
cls0 db tsc_P DOWN tsc, /home/tibero/tibero7, failed retry cnt: 0
cls0 vip vip0 DOWN tsc, 192.168.41.117/255.255.255.0/192.168.41.255 (1)
failed retry cnt: 0
=====================================================================Caution
The tbcm process must be started as root, and the tibero process must be started as the tibero user for the VIP to be up.
9. Database Creation
Once CM startup and resource registration are complete on the Primary Node, create the database.
9.1 Start Primary DB in nomount mode
$ tbboot nomount Change core dump dir to /home/tibero/tibero7/bin/prof. Listener port = 8629 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance started up (NOMOUNT mode).
9.2 Create Database
$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> create database
user sys identified by tibero
maxinstances 8
maxdatafiles 100
character set MSWIN949
national character set UTF16
logfile
group 1 'log001.redo' size 100M,
group 2 'log002.redo' size 100M,
group 3 'log003.redo' size 100M
maxloggroups 255
maxlogmembers 8
archivelog
datafile 'system001.dtf' size 100M autoextend on next 100M maxsize unlimited
default temporary tablespace TEMP
tempfile 'temp001.dtf' size 100M autoextend on next 100M maxsize unlimited
extent management local autoallocate
undo tablespace UNDO
datafile 'undo001.dtf' size 100M autoextend on next 100M maxsize unlimited
extent management local autoallocate;
Database created.
Note
If create database completes successfully, all tibero processes started in nomount mode will be terminated.
- To check tibero processes: ps -ef | grep tbsvr
10. Run system_install.sh
After database creation, start the DB in normal mode and run $TB_HOME/scripts/system_install.sh.
10.1 Start Primary DB
$ su - tibero $ tbboot Change core dump dir to /home/tibero/tibero7/bin/prof. Listener port = 8629 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance started up (NORMAL mode).
10.2 Run system_install.sh
Running system_install.sh requires entering passwords for sys and syscat accounts.
- Initial password for sys account: tibero
- Initial password for syscat account: syscat
$ cd $TB_HOME/scripts
[tsc_tibero7@kimmi scripts]$ sh system_install.sh
Enter SYS password:
--> enter password tibero
Enter SYSCAT password:
--> enter password syscat
Creating internal system tables...
Creating additional system index...
Creating client policy table ...
Setting case insensitive password...
Create system tables related to dbms_redact...
Creating text packages table ...
Inserting for text packages table ...
Creating the role DBA...
Creating system users & roles...
Creating example users...
Creating virtual tables...
Granting public access to _VT_DUAL...
Creating the system generated sequences...
Creating internal dynamic performance views...
Creating outline table...
Creating system tables related to dbms_job...
Creating system tables related to dbms_lock...
Creating system tables related to dbms_parallel_execute...
Creating system tables related to scheduler...
Creating system tables related to server_alert...
Creating system tables related to tpm...
Creating system tables related to tsn and timestamp...
... (omitted)...
Setting system_install.sh parameter...
Done.
For details, check /home/tibero/tibero7/instance/tsc_P/log/system_init.log.
11. Create Temporary Table
$ tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> create table tibero.tsc_sync_test (c1 number, dt date default sysdate);
Table 'TIBERO.TSC_SYNC_TEST' created.
SQL> insert into tibero.tsc_sync_test(c1)
select level from dual connect by level < 100;
99 rows inserted.
SQL> commit;
Commit completed.
SQL> select count(*) from tibero.tsc_sync_test;
COUNT(*)
----------
99
12. Data Synchronization
To synchronize data between Primary DB and Standby DB, shut down the Primary DB. Then copy the Data files, Control files, Redo files, Archive files, and .passwd file to the Standby DB. (Use scp/sftp)
12.1 Shutdown Primary DB & CM
$ tbdown immediate Tibero instance terminated (IMMEDIATE mode). $ tbcm -d Tibero instance terminated (IMMEDIATE mode).
12.2 File Copy
$ scp -r tbdata tbarch tibero@172.16.59.111:/home/tibero tibero7@172.16.59.111's password: c1.ctl 100% 77MB 123.7MB/s 00:00 c2.ctl 100% 77MB 165.2MB/s 00:00 redo001.redo 100% 50MB 160.3MB/s 00:00 redo002.redo 100% 50MB 170.2MB/s 00:00 redo011.redo 100% 50MB 123.0MB/s 00:00 redo012.redo 100% 50MB 108.6MB/s 00:01 redo021.redo 100% 50MB 121.9MB/s 00:00 redo022.redo 100% 50MB 141.2MB/s 00:00 redo031.redo 100% 50MB 102.6MB/s 00:00 redo032.redo 100% 50MB 91.3MB/s 00:00 redo041.redo 100% 50MB 51.7MB/s 00:00 redo042.redo 100% 50MB 40.4MB/s 00:01 system001.dtf 100% 512MB 36.7MB/s 00:13 undo001.dtf 100% 512MB 104.0MB/s 00:04 temp001.dtf 100% 512MB 14.9MB/s 00:34 usr001.dtf 100% 512MB 96.6MB/s 00:05 tpr_ts.dtf 100% 60MB 89.8MB/s 00:00 .passwd 100% 88 35.5KB/s 00:00 log-t0-r0-s1.arc 100% 512 291.7KB/s 00:00 log-t0-r0-s2.arc 100% 1511KB 55.1MB/s 00:00 log-t0-r0-s3.arc 100% 50MB 83.8MB/s 00:00