문서유형ㅣ기술정보
분야ㅣ설치
적용제품버전ㅣ7FS02PS
문서번호ㅣTINTI049
개요
Tibero 6 FS05 버전부터 tbcm의 구조가 변경되었습니다. (new cm)
다음 스크립트를 이용하여 new cm을 이용한 tas 환경에서의 tac 구축을 할 수 있습니다.
(tas 환경이 아닐 경우에는 tas 부분만 제외하고 진행하면 됩니다.)
스크립트는 Tibero 7 기준으로 작성되었습니다.
방법
다음 페이지부터 순서대로 따라 가면 기본 설치를 할 수 있습니다.
추가적인 옵션은 Administrator's guide를 참조 바랍니다.
| NODE1 | NODE2 |
[OS계정: tas1] * bash_profile 설정
### 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 환경파일 설정 (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 환경파일 설정 (cm1.tip) CM_NAME=cm1 CM_UI_PORT=4649 CM_RESOURCE_FILE=/home/tas1/tibero7/config/cm1_res.crf
* tbdsn.tbr 설정 tas1=( (INSTANCE=(HOST=localhost) (PORT=8639) (DB_NAME=tas) ) ) | [OS계정: tas2] * bash_profile 설정
### 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 환경파일 설정 (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 환경파일 설정 (cm2.tip) CM_NAME=cm2 CM_UI_PORT=4649 CM_RESOURCE_FILE=/home/tas2/tibero7/config/cm2_res.crf
* tbdsn.tbr 설정 tas2=( (INSTANCE=(HOST=localhost) (PORT=8639) (DB_NAME=tas) ) ) |
| NODE1 |
* 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.
* 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
* CM 기동 $ tbcm -b
* CM에 네트워크 등록 $ cmrctl add network --name inter1 --nettype private --ipaddr 10.1.1.1 --portno 19629 $ cmrctl add network --name pub1 --nettype public --ifname eth0
* CM에 cluster 등록 $ 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 ===================================================================== * CM Cluster 기동 $ cmrctl start cluster --name cluster1 SUCCESS!
* CM에 TAS Service 등록 $ cmrctl add service --name tas --cname cluster1 --type as Resource add success! (service, tas)
* CM에 TAS Instance 등록 $ cmrctl add as --name tas1 --svcname tas --dbhome $TB_HOME --envfile /home/tas1/.bash_profile Resource add success! (as, tas1)
* 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)
* 중간 확인 [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 =====================================================================
* NODE2의 TAS Instance Thread 추가 [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 구성 끝 TAC 구성 시작
|
| NODE2 |
* CM 기동 $ tbcm -b
* CM에 네트워크 등록 $ cmrctl add network --name inter2 --nettype private --ipaddr 10.1.1.2 --portno 19629 $ cmrctl add network --name pub2 --nettype public --ifname eth0
* CM에 Cluster 등록 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 =====================================================================
* CM Cluster 기동 [tas2@localhost config]$ cmrctl start cluster --name cluster1 SUCCESS!
* CM에 TAS Instance 등록 $ cmrctl add as --name tas2 --svcname tas --dbhome $TB_HOME --envfile /home/tas2/.bash_profile Resource add success! (as, tas2)
* 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)
* 중간 확인 [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 구성 끝 TAC 구성 시작
|
| NODE1 | NODE2 |
[OS계정: tac1] * bash_profile 설정 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 환경파일 설정 (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계정: tac2] * bash_profile 설정 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 환경파일 설정 (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계정: tas1] * CM에 TAC Service 등록 $ 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 =====================================================================
* CM에 TAC DB Instance 등록 [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계정: tas2] * CM에 TAC DB Instance 등록 [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계정: tac1] * 티베로 nomount 기동 및 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.
* 티베로 normal 기동 및 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 |
* system.sh 수행 $ sh system_install.sh -p1 [sys password] -p2 [syscat password] ex) $ sh system_install.sh -p1 tibero -p2 syscat |
| NODE2 |
[OS계정: tac2] * 티베로 normal 기동 $ tbboot Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. |