Document Type | Technical Information
Category | Installation
Applicable Product Version | 7FS02PS
Document Number | TINTI049
Overview
From Tibero 6 FS05 version, the structure of tbcm has changed. (new cm)
You can build tac in a tas environment using new cm with the following script.
(If it is not a tas environment, just exclude the tas part and proceed.)
The script is written based on Tibero 7.
Method
You can perform the basic installation by following the steps from the next page in order.
For additional options, please refer to the Administrator's guide.
| NODE1 | NODE2 |
[OS Account: tas1] * bash_profile Settings
### TAS SETTING ### export TB_SID=tas1 export TB_HOME=/home/tas1/tibero7 export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH
### CM SETTING ### export CM_HOME=$TB_HOME export CM_SID=cm1
* tas Environment File Settings (tas1.tip) DB_NAME=tas LISTENER_PORT=8639 MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=512M MEMORY_TARGET=1G
#################### ### TAS SETTING #### #################### INSTANCE_TYPE=AS AS_DISKSTRING="/dev/mapper/vg0*" AS_ALLOW_ONLY_RAW_DISKS=Y AS_WTHR_CNT=10
#################### #### TAS CLUSTER ### #################### CLUSTER_DATABASE=Y LOCAL_CLUSTER_ADDR=10.1.1.1 LOCAL_CLUSTER_PORT=4639 CM_PORT=4649 THREAD=0
* CM Environment File Settings (cm1.tip) CM_NAME=cm1 CM_UI_PORT=4649 CM_RESOURCE_FILE=/home/tas1/tibero7/config/cm1_res.crf
* tbdsn.tbr Settings tas1=( (INSTANCE=(HOST=localhost) (PORT=8639) (DB_NAME=tas) ) ) | [OS Account: tas2] * bash_profile Settings
### TAS SETTING ### export TB_SID=tas2 export TB_HOME=/home/tas2/tibero7 export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH
### CM SETTING ### export CM_HOME=$TB_HOME export CM_SID=cm2 * tas Environment File Settings (tas2.tip) DB_NAME=tas LISTENER_PORT=8639 MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=512M MEMORY_TARGET=1G
#################### ### TAS SETTING #### #################### INSTANCE_TYPE=AS AS_DISKSTRING="/dev/mapper/vg0*" AS_ALLOW_ONLY_RAW_DISKS=Y AS_WTHR_CNT=10
#################### #### TAS CLUSTER ### #################### CLUSTER_DATABASE=Y LOCAL_CLUSTER_ADDR=10.1.1.2 LOCAL_CLUSTER_PORT=4639 CM_PORT=4649 THREAD=1
* CM Environment File Settings (cm2.tip) CM_NAME=cm2 CM_UI_PORT=4649 CM_RESOURCE_FILE=/home/tas2/tibero7/config/cm2_res.crf
* tbdsn.tbr Settings tas2=( (INSTANCE=(HOST=localhost) (PORT=8639) (DB_NAME=tas) ) ) |
| NODE1 |
* Create diskspace $ tbboot nomount; SQL> create diskspace ds0 normal redundancy failgroup fg1 disk '/dev/mapper/vg0-vol01_1G' name disk1 failgroup fg2 disk '/dev/mapper/vg0-vol02_1G' name disk2 attribute 'AU_SIZE'='4M'; Diskspace 'DS0' created SQL> ALTER DISKSPACE ds0 ADD FAILGROUP fg1 disk '/dev/mapper/vg0-vol03_1G' NAME disk3 REBALANCE; Diskspace altered. SQL> ALTER DISKSPACE ds0 ADD FAILGROUP fg2 disk '/dev/mapper/vg0-vol04_1G' NAME disk4 REBALANCE; Diskspace altered.
* Create CM tip $ vi $TB_HOME/config/$CM_SID.tip CM_NAME=cm1 CM_UI_PORT=4649 CM_RESOURCE_FILE=/home/tas1/tibero7/config/cm1_res.crf
* Start CM $ tbcm -b
* Register network to CM $ cmrctl add network --name inter1 --nettype private --ipaddr 10.1.1.1 --portno 19629 $ cmrctl add network --name pub1 --nettype public --ifname eth0
* Register cluster to CM $ cmrctl add cluster --name cluster1 --incnet inter1 --pubnet pub1 --cfile "+/dev/mapper/vg0*" [tac1@localhost config]$ cmrctl show Resource List of Node cm1 ===================================================================== CLUSTER TYPE NAME STATUS DETAIL ----------- -------- -------------- -------- ------------------------ COMMON network inter1 UP (private) 10.1.1.1/19629 COMMON network pub1 UP (public) eth0 COMMON cluster cluster1 DOWN inc: inter1, pub: pub1 ===================================================================== * Start CM Cluster $ cmrctl start cluster --name cluster1 SUCCESS!
* Register TAS Service to CM $ cmrctl add service --name tas --cname cluster1 --type as Resource add success! (service, tas)
* Register TAS Instance to CM $ cmrctl add as --name tas1 --svcname tas --dbhome $TB_HOME --envfile /home/tas1/.bash_profile Resource add success! (as, tas1)
* Start TAS Instance cmrctl start as --name tas1
Listener port = 8639 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance started up (NORMAL mode). BOOT SUCCESS! (MODE : NORMAL)
* Intermediate Check [tas1@localhost ~]$ cmrctl show Resource List of Node cm1 ===================================================================== CLUSTER TYPE NAME STATUS DETAIL ----------- -------- -------------- -------- ------------------------ COMMON network inter1 UP (private) 10.1.1.1/19629 COMMON network pub1 UP (public) eth0 COMMON cluster cluster1 UP inc: inter1, pub: pub1 cluster1 file cluster1:0 UP +0 cluster1 file cluster1:1 UP +1 cluster1 file cluster1:2 UP +2 cluster1 service tas UP Active Storage, Active Cluster (auto-restart: OFF) cluster1 as tas1 UP(NRML) tas, /home/tas1/tibero7 =====================================================================
* Add TAS Instance Thread on NODE2 [tas1@localhost ~]$ tbsql sys/tibero tbSQL 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Connected to Tibero. SQL> ALTER DISKSPACE DS0 ADD THREAD 1; Diskspace altered.
TAS Setup Complete Begin TAC Setup
|
| NODE2 |
* Start CM $ tbcm -b
* Register network to CM $ cmrctl add network --name inter2 --nettype private --ipaddr 10.1.1.2 --portno 19629 $ cmrctl add network --name pub2 --nettype public --ifname eth0
* Register Cluster to CM cmrctl add cluster --name cluster1 --incnet inter2 --pubnet pub2 --cfile "+/dev/mapper/vg0*" [tas2@localhost config]$ cmrctl show Resource List of Node cm2 ===================================================================== CLUSTER TYPE NAME STATUS DETAIL ----------- -------- -------------- -------- ------------------------ COMMON network inter2 UP (private) 10.1.1.2/19629 COMMON network pub2 UP (public) eth0 COMMON cluster cluster1 DOWN inc: inter2, pub: pub2 =====================================================================
* Start CM Cluster [tas2@localhost config]$ cmrctl start cluster --name cluster1 SUCCESS!
* Register TAS Instance to CM $ cmrctl add as --name tas2 --svcname tas --dbhome $TB_HOME --envfile /home/tas2/.bash_profile Resource add success! (as, tas2)
* Start TAS Instance $ cmrctl start as --name tas2
Listener port = 8639 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance started up (NORMAL mode). BOOT SUCCESS! (MODE : NORMAL)
* Intermediate Check [tas2@localhost log]$ cmrctl show Resource List of Node cm2 ===================================================================== CLUSTER TYPE NAME STATUS DETAIL ----------- -------- -------------- -------- ------------------------ COMMON network inter2 UP (private) 10.1.1.2/19629 COMMON network pub2 UP (public) eth0 COMMON cluster cluster1 UP inc: inter2, pub: pub2 cluster1 file cluster1:0 UP +0 cluster1 file cluster1:1 UP +1 cluster1 file cluster1:2 UP +2 cluster1 service tas UP Active Storage, Active Cluster (auto-restart: OFF) cluster1 as tas2 UP(NRML) tas, /home/tas2/tibero7 =====================================================================
TAS Setup Complete Begin TAC Setup
|
| NODE1 | NODE2 |
[OS Account: tac1] * bash_profile Settings export TB_HOME=/home/tac1/tibero7 export TB_SID=tac1 export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH
* tibero Environment File Settings (tac1.tip) DB_NAME=tac LISTENER_PORT=8629 CONTROL_FILES="+DS0/tbdata/c1.ctl" DB_CREATE_FILE_DEST="+DS0/tbdata/"
MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=512M MEMORY_TARGET=1G
USE_ACTIVE_STORAGE=Y AS_PORT=8639
CLUSTER_DATABASE=Y THREAD=0 UNDO_TABLESPACE=UNDO0 LOCAL_CLUSTER_ADDR=10.1.1.1 LOCAL_CLUSTER_PORT=9629 CM_PORT=4649
| [OS Account: tac2] * bash_profile Settings export TB_HOME=/home/tac2/tibero7 export TB_SID=tac2 export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH
* tibero Environment File Settings (tac2.tip) DB_NAME=tac LISTENER_PORT=8629 CONTROL_FILES="+DS0/tbdata/c1.ctl" DB_CREATE_FILE_DEST="+DS0/tbdata/"
MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=512M MEMORY_TARGET=1G
USE_ACTIVE_STORAGE=Y AS_PORT=8639
CLUSTER_DATABASE=Y THREAD=1 UNDO_TABLESPACE=UNDO1 LOCAL_CLUSTER_ADDR=10.1.1.2 LOCAL_CLUSTER_PORT=9629 CM_PORT=4649
|
| NODE1 |
[OS Account: tas1] * Register TAC Service to CM $ cmrctl add service --name tac --cname cluster1 --type db Resource add success! (service, tac) [tas1@localhost ~]$ cmrctl show Resource List of Node cm1 ===================================================================== CLUSTER TYPE NAME STATUS DETAIL ----------- -------- -------------- -------- ------------------------ COMMON network inter1 UP (private) 10.1.1.1/19629 COMMON network pub1 UP (public) eth0 COMMON cluster cluster1 UP inc: inter1, pub: pub1 cluster1 file cluster1:0 UP +0 cluster1 file cluster1:1 UP +1 cluster1 file cluster1:2 UP +2 cluster1 service tas UP Active Storage, Active Cluster (auto-restart: OFF) cluster1 service tac DOWN Database, Active Cluster (auto-restart: OFF) cluster1 as tas1 UP(NRML) tas, /home/tas1/tibero7 =====================================================================
* Register TAC DB Instance to CM [tas1@localhost ~]$ cmrctl add db --name tac1 --svcname tac --dbhome /home/tac1/tibero7 --envfile /home/tac1/.bash_profile Resource add success! (db, tac1) [tas1@localhost ~]$ cmrctl show Resource List of Node cm1 ===================================================================== CLUSTER TYPE NAME STATUS DETAIL ----------- -------- -------------- -------- ------------------------ COMMON network inter1 UP (private) 10.1.1.1/19629 COMMON network pub1 UP (public) eth0 COMMON cluster cluster1 UP inc: inter1, pub: pub1 cluster1 file cluster1:0 UP +0 cluster1 file cluster1:1 UP +1 cluster1 file cluster1:2 UP +2 cluster1 service tas UP Active Storage, Active Cluster (auto-restart: OFF) cluster1 service tac DOWN Database, Active Cluster (auto-restart: OFF) cluster1 as tas1 UP(NRML) tas, /home/tas1/tibero7 cluster1 db tac1 DOWN tac, /home/tac1/tibero7 =====================================================================
|
| NODE2 |
[OS Account: tas2] * Register TAC DB Instance to CM [tas2@localhost ~]$ cmrctl add db --name tac2 --svcname tac --dbhome /home/tac2/tibero7 --envfile /home/tac2/.bash_profile Resource add success! (db, tac2) [tas2@localhost ~]$ cmrctl show Resource List of Node cm2 ===================================================================== CLUSTER TYPE NAME STATUS DETAIL ----------- -------- -------------- -------- ------------------------ COMMON network inter2 UP (private) 10.1.1.2/19629 COMMON network pub2 UP (public) eth0 COMMON cluster cluster1 UP inc: inter2, pub: pub2 cluster1 file cluster1:0 UP +0 cluster1 file cluster1:1 UP +1 cluster1 file cluster1:2 UP +2 cluster1 service tas UP Active Storage, Active Cluster (auto-restart: OFF) cluster1 service tac DOWN Database, Active Cluster (auto-restart: OFF) cluster1 as tas2 UP(NRML) tas, /home/tas2/tibero7 cluster1 db tac2 DOWN tac, /home/tac2/tibero7 ===================================================================== |
| NODE1 |
[OS Account: tac1] * Start Tibero nomount and Create DB $ tbboot nomount $ tbsql sys/tibero CREATE DATABASE "tac" USER sys IDENTIFIED BY tibero MAXDATAFILES 2048 CHARACTER SET UTF8 -- UTF8, EUCKR, ASCII NATIONAL CHARACTER SET UTF16 LOGFILE GROUP 0 ('+DS0/tbdata/log01.log') SIZE 20M, GROUP 1 ('+DS0/tbdata/log11.log') SIZE 20M, GROUP 2 ('+DS0/tbdata/log21.log') SIZE 20M MAXLOGFILES 100 MAXLOGMEMBERS 8 ARCHIVELOG DATAFILE '+DS0/tbdata/system001.dtf' SIZE 128M AUTOEXTEND ON NEXT 100M MAXSIZE 2G DEFAULT TABLESPACE USR DATAFILE '+DS0/tbdata/usr001.dtf' SIZE 128M AUTOEXTEND ON NEXT 100M MAXSIZE 1G DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '+DS0/tbdata/temp001.dtf' SIZE 128M AUTOEXTEND ON NEXT 10M MAXSIZE 1G EXTENT MANAGEMENT LOCAL AUTOALLOCATE UNDO TABLESPACE UNDO0 DATAFILE '+DS0/tbdata/undo001.dtf' SIZE 128M AUTOEXTEND ON NEXT 10M MAXSIZE 1G EXTENT MANAGEMENT LOCAL AUTOALLOCATE; Database created.
* Start Tibero normal and Add Files for TAC2 $ tbboot $ tbsql sys/tibero CREATE UNDO TABLESPACE UNDO1 datafile '+DS0/tbdata/undo101.dtf' SIZE 128M AUTOEXTEND ON NEXT 10M MAXSIZE 1G EXTENT MANAGEMENT LOCAL AUTOALLOCATE; Tablespace 'UNDO1' created. alter database add logfile thread 1 group 3 '+DS0/tbdata/log02.log' size 20M; Database altered. alter database add logfile thread 1 group 4 '+DS0/tbdata/log12.log' size 20M; Database altered. alter database add logfile thread 1 group 5 '+DS0/tbdata/log22.log' size 20M; Database altered.
alter database enable public thread 1; Database altered.
CREATE TABLESPACE SYSSUB DATAFILE '+DS0/tbdata/tpr_ts.dtf' SIZE 10M AUTOEXTEND ON MAXSIZE 1G; Tablespace 'SYSSUB' created. |
| NODE1 |
* Run system.sh $ sh system_install.sh -p1 [sys password] -p2 [syscat password] ex) $ sh system_install.sh -p1 tibero -p2 syscat |
| NODE2 |
[OS Account: tac2] * Start Tibero normal $ tbboot Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. |