문서유형ㅣ기술정보
분야ㅣ설치
적용제품버전ㅣ6FS07, 6FS07PS, 7FS02, 7FS02PS
문서번호ㅣTINTI020
개요
본 문서에서는 AIX환경에서 TSC no observer -> observer 전환 방법에 대해 설명합니다.
| 구분 | 테스트 환경 |
|---|---|
| OS | AIX 7.3 |
| Tibero | Tibero 7 (DB 7.2.2) Build 281152 |
방법
1. 운영 중인 TSC No observer 종료
standby node 종료 $ tbdown immediate primary node 종료 $ tbdown immediate
2. observer os계정 추가
1) Standby Node에 observer 계정 생성
$ useradd -g dba obs
2) observer 계정에 tibero7 바이너리 생성
$ su - obs $ gzip -dc tibero7-bin-FS02_PS02-aix_7.1-281152-20241024103828.tar.gz | tar xvf -
3) observer .profile 설정
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 Manger ENV export CM_HOME=$TB_HOME export CM_SID=observer
3. primary db tip파일 파라미터 추가
1) Primary Node
#---------------------------------------------- # OBSERVER #---------------------------------------------- STANDBY_USE_OBSERVER=Y CM_PORT=33039 LOCAL_CLUSTER_ADDR=192.168.1.212 LOCAL_CLUSTER_PORT=33029
4. cm.tip 추가
1) Primary DB
vi $TB_HOME/config/primary.tip CM_NAME=primary CM_UI_PORT=33039 CM_RESOURCE_FILE=/data/pub1/kiw/tsc/tibero7/config/cm_res.ref CM_HEARTBEAT_EXPIRE=300 CM_WATCHDOG_EXPIRE=290
2) standby DB
vi $TB_HOME/config/standby.tip CM_NAME=standby CM_UI_PORT=33039 CM_RESOURCE_FILE=/data/pub1/kiw/tsc/tibero7/config/cm_res.ref CM_HEARTBEAT_EXPIRE=300 CM_WATCHDOG_EXPIRE=290
3) observer cm.tip
vi $TB_HOME/config/observer.tip CM_NAME=observer CM_MODE_OBSERVER=Y CM_OBSERVER_PORT=5310 CM_UI_PORT=55039
4. tbdsn.tbr 설정
1) Primary Node
$ vi $TB_HOME/client/config/tbdsn.tbr
tsc1=(
(INSTANCE=(HOST=localhost)
(PORT=3310)
(DB_NAME=tsc)
)
)
2) Standby Node
$ vi $TB_HOME/client/config/tbdsn.tbr
tsc2=(
(INSTANCE=(HOST=localhost)
(PORT=3310)
(DB_NAME=tsc)
)
)5. cm resource 등록
$ tbcm -b $ cmrctl
6. TSC 구축 후 검증 절차
1) Primary Node
2) standby Node