현상
TSC(Tibero Standby Cluster) Observer Mode 설치 중, CM(Cluster Manager) 등록까지는 진행되었으나, 이후 데이터베이스 생성을 위한 tbboot -t nomount 단계에서 기동이 실패하였습니다.
이때, Listener: tb_network_accept failed 오류가 발생하였습니다.
Create DB 를 위한 Nomount 기동 시 Fail
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh]tbboot nomount
Change core dump dir to /idiskb/expert/lsh/tibero7_tsc/bin/prof.
Listener port = 8629
Tibero instance startup failed!
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh] Listener: tb_network_accept failed.
Check if there are any Tibero instances running.
SQL
복사
원인
CM(Cluster Manager)에 등록한 서비스 이름과 DB_NAME이 일치하지 않아 에러가 발생한 것으로 확인되었습니다.
자세한 오류 원인은 CM log를 통해 확인할 수 있습니다.
서비스명을 잘못 등록 한 경우
$ cmrctl add service --name tsc --cname cls1 --tscid 11 --obsip 192.168.1.187 --obsport 9050 --> tsc 로 잘 못 등록
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh/tibero7_tsc/config]cmrctl add service --name tsc --cname cls1 --tscid 11 --obsip 192.168.1.187 --obsport 9050
Resource add success! (service, tsc)
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh/tibero7_tsc/config]cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net1 UP (private) 192.168.1.186/29000
COMMON network pub01 UP (public) eno2
COMMON cluster cls1 UP inc: net1, pub: pub01
cls1 file cls1:0 UP /idiskb/expert/lsh/tibero7_tsc/config/cls1_cfile
cls1 service tsc DOWN Database, Active Cluster (auto-restart: OFF)
=====================================================================
SQL
복사
Trace_CM.log
2025/06/16 14:53:59.440 [1] cm_ui.c :4044(02) [INST] Instance `t7tsc_P` send request msg (service port: 15000, on_revival:0)
2025/06/16 14:53:59.440 [1] cm_ui.c :4083(02) [ERROR] Service name(tsc) and DB_NAME(t7tsc) mismatch.
SQL
복사
해결
cmrctl add service --name (DB_NAME) 명령어를 통해, CM(Cluster Manager)에 DB 이름과 동일한 서비스명을 등록하여 해결합니다.
$ cmrctl del service --name tsc --cname cls1 --tscid 11 --obsip 192.168.1.187 --obsport 9050 (기존 내용 삭제)
$ cmrctl add service --name t7tsc --cname cls1 --tscid 11 --obsip 192.168.1.187 --obsport 9050 (DB_NAME 으로 등록)
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh]cmrctl add service --name t7tsc --cname cls1 --tscid 11 --obsip 192.168.1.187 --obsport 9050
Resource add success! (service, t7tsc)
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh]cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net1 UP (private) 192.168.1.186/29000
COMMON network pub01 UP (public) eno2
COMMON cluster cls1 UP inc: net1, pub: pub01
cls1 file cls1:0 UP /idiskb/expert/lsh/tibero7_tsc/config/cls1_cfile
cls1 service t7tsc DOWN Database, Active Cluster (auto-restart: OFF)
=====================================================================
SQL
복사
nomount 기동 확인
expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh]cmrctl add db --name t7tsc_P --svcname t7tsc --dbhome /idiskb/expert/lsh/tibero7_tsc/ --envfile /idiskb/expert/lsh/.t7tsc_profile
Resource add success! (db, t7tsc_P)
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh]cmrctl show
Resource List of Node PRIMARY
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net1 UP (private) 192.168.1.186/29000
COMMON network pub01 UP (public) eno2
COMMON cluster cls1 UP inc: net1, pub: pub01
cls1 file cls1:0 UP /idiskb/expert/lsh/tibero7_tsc/config/cls1_cfile
cls1 service t7tsc DOWN Database, Active Cluster (auto-restart: OFF)
cls1 db t7tsc_P DOWN t7tsc, /idiskb/expert/lsh/tibero7_tsc/, failed retry cnt: 0
=====================================================================
[expert@psdblrt1:t7tsc_P:/idiskb/expert/lsh]tbboot nomount
Change core dump dir to /idiskb/expert/lsh/tibero7_tsc/bin/prof.
Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NOMOUNT mode).
--------------------------------------------
SQL
복사