문서유형ㅣ기술정보
분야ㅣ관리/환경설정
적용제품버전ㅣTibero 7.2.3
문서번호ㅣTADTI147
개요
테스트 구성 환경
- 서버명 : Tibero
- OS version : CentOS Stream release 10 (Coughlan)
- DB Version : Tibero 7.2.3
방법
IPv6 정의
Internet Protocol Version 6의 약자인 IPv6는 IPv4의 주소 고갈 문제를 비롯하여 확장성, 호스트 주소 자동 설정 등 여러 한계를 해결하기 위해 제안된 차세대 인터넷 프로토콜입니다.
IPv6는 128비트 주소 체계를 사용하며, 일반적으로 가독성을 높이기 위해 16진수와 콜론(:)을 사용하여 표기합니다.
아래에 제시된 IPv6 표기들은 모두 동일한 주소를 의미하며, 일반적인 Linux 환경에서는 ifconfig -a 명령어를 통해 IPv6 주소를 확인할 수 있습니다.
--모두 동일한 IPv6 주소
2001:0DB8:0000:0000:0000:0000:1428:57ab
2001:0DB8:0000:0000:0000::1428:57ab
2001:0DB8:0:0:0:0:1428:57ab
2001:0DB8:0::0:1428:57ab
2001:0DB8::1428:57ab
--ifconifg -a로 확인한 IPv6 주소값
[tibero@node1 ~/tibero7/client/config]$ ifconfig -a
enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.20.10.6 netmask 255.255.255.240 broadcast 172.20.10.15
inet6 fe80::a00:27ff:fe69:9cdd prefixlen 64 scopeid 0x20<link>
inet6 2001:2d8:634f:fdb6:a00:27ff:fe69:9cdd prefixlen 64 scopeid 0x0<global>
inet6 2001:2d8:6349:fae8:a00:27ff:fe69:9cdd prefixlen 64 scopeid 0x0<global>
ether 08:00:27:69:9c:dd txqueuelen 1000 (Ethernet)
RX packets 2574 bytes 321059 (313.5 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 1788 bytes 329516 (321.7 KiB)
TX errors 0 dropped 7 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 95 bytes 11598 (11.3 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 95 bytes 11598 (11.3 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
티베로 IPv6 관련 패치
단 테스트한 7.2.3 버젼에서는 별도의 패치 없이 설정이 가능하다. --패치 리스트 189619f => 194325j로 변경 134584a 202908a => 배포 불가 200548a => 배포 불가 189619a_jdbc
IPv6 설정 방법
티베로 환경파일과 접속 정보를 가지고 있는 tbdsn.tbr 파일을 수정해야 합니다.
--tip
# tip file generated from /home/tibero/tibero7/config/tip.template (2025. 12. 15. (월) 13:42:02 KST)
#-------------------------------------------------------------------------------
#
# RDBMS initialization parameter
#
#-------------------------------------------------------------------------------
DB_NAME=node1
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=2G
MEMORY_TARGET=3G
WTHR_PER_PEP=1
LISTENER_IP=fe80::a00:27ff:fe69:9cdd%enp0s3
IP_VERSION=6
--tbdsn.tbr
node1_v6=(
(INSTANCE=(HOST=fe80::a00:27ff:fe69:9cdd)
(PORT=8629)
(IP_VERSION=6)
(DB_NAME=node1)
)
)
IPv6 접속 테스트
IPv6를 설정하는 경우 기존 IPv4 접속정보로는 접속이 불가능합니다. (포트 충돌)
--테스트 서버 IP 정보
[tibero@node1 ~/tibero7/client/config]$ ifconfig -a
enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.20.10.6 netmask 255.255.255.240 broadcast 172.20.10.15
inet6 fe80::a00:27ff:fe69:9cdd prefixlen 64 scopeid 0x20<link>
inet6 2001:2d8:634f:fdb6:a00:27ff:fe69:9cdd prefixlen 64 scopeid 0x0<global>
inet6 2001:2d8:6349:fae8:a00:27ff:fe69:9cdd prefixlen 64 scopeid 0x0<global>
ether 08:00:27:69:9c:dd txqueuelen 1000 (Ethernet)
RX packets 2574 bytes 321059 (313.5 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 1788 bytes 329516 (321.7 KiB)
TX errors 0 dropped 7 overruns 0 carrier 0 collisions 0
lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
inet6 ::1 prefixlen 128 scopeid 0x10<host>
loop txqueuelen 1000 (Local Loopback)
RX packets 95 bytes 11598 (11.3 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 95 bytes 11598 (11.3 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0
--테스트 서버 tbdsn.tbr 정보
[tibero@node1 ~/tibero7/client/config]$ cat tbdsn.tbr
#-------------------------------------------------
# /home/tibero/tibero7/client/config/tbdsn.tbr
# Network Configuration File.
# Generated by gen_tip.sh at 2025. 12. 15. (월) 13:42:03 KST
node1=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=node1)
)
)
node1_v6=(
(INSTANCE=(HOST=fe80::a00:27ff:fe69:9cdd)
(PORT=8629)
(IP_VERSION=6)
(DB_NAME=node1)
)
)
--IPv6 접속 테스트
[tibero@node1 ~/tibero7/client/config]$ tbsql sys/tibero@node1_v6
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero using node1_v6.
SQL> select * from v$database;
DBID NAME DB_CREATE_DATE
---------- ---------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CF_CREATE_DATE CURRENT_TSN OPEN_MODE PROTECTION_MODE RESETLOG_TSN
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------- --------------- ------------
RESETLOG_DATE PREV_RESETLOG_TSN
-------------------------------------------------------------------------------------------------------------------------------- -----------------
PREV_RESETLOG_DATE DATABASE_ROLE STANDBY_BECAME_PRIMARY_TSN
-------------------------------------------------------------------------------------------------------------------------------- ----------------- --------------------------
STANDBY_BECAME_PRIMARY_DATE LOG_MODE FORCE_LOGGING CKPT_TSN
-------------------------------------------------------------------------------------------------------------------------------- ------------ ----------------- ----------
CKPT_DATE CPU_NAME PLATFORM_NAME
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------- --------------------------------
CPU_MODEL
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OS_UPTIME CM_OBSERVER
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------
91488347 node1 2025/12/16
2025/12/16 46316 READ WRITE UNPROTECTED 45289
2025/12/16 45122
2025/12/16 PRIMARY 0
ARCHIVELOG NO 46268
2025/12/17 X86 LINUX_X86_64
12th Gen Intel(R) Core(TM) i5-1240P
15:50:46 up 5:15, 4 users, load average: 0.01, 0.05, 0.07 DISABLED
1 row selected.
SQL> quit
Disconnected.
--IPv4 접속 테스트
[tibero@node1 ~/tibero7/client/config]$ tbsql sys/tibero@node1
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
TBR-2131: Generic I/O error.
SQL> quit
IPv4, IPv6 듀얼스택 설정 방법
티베로 환경파일과 접속 정보를 가지고 있는 tbdsn.tbr 파일을 수정해야 합니다.
tbdsn.tbr 파일의 기존 IPv4의 접속정보의 IP 항목은 localhost가 아닌 실제 IP값으로 변경합니다.
--tip
# tip file generated from /home/tibero/tibero7/config/tip.template (2025. 12. 15. (월) 13:42:02 KST)
#-------------------------------------------------------------------------------
#
# RDBMS initialization parameter
#
#-------------------------------------------------------------------------------
DB_NAME=node1
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=2G
MEMORY_TARGET=3G
WTHR_PER_PEP=1
LISTENER_IP=172.20.10.6
LOCAL_CLUSTER_IP_VERSION=4
IP_VERSION=10
LISTENER_IP_6=fe80::a00:27ff:fe69:9cdd%enp0s3
LISTENER_PORT_6=28629
--tbdsn.tbr
#-------------------------------------------------
# /home/tibero/tibero7/client/config/tbdsn.tbr
# Network Configuration File.
# Generated by gen_tip.sh at 2025. 12. 15. (월) 13:42:03 KST
node1=(
(INSTANCE=(HOST=172.20.10.6)
(PORT=8629)
(DB_NAME=node1)
)
)
node1_v6=(
(INSTANCE=(HOST=fe80::a00:27ff:fe69:9cdd)
(PORT=28629)
(IP_VERSION=6)
(DB_NAME=node1)
)
)듀얼스택 설정 시 부팅화면 및 접속 테스트
[tibero@node1 ~/tibero7/client/config]$ tbboot
Change core dump dir to /home/tibero/tibero7/bin/prof.
/usr/bin/pstack or /usr/bin/gstack is required to dump the callstack.
****************************************************
* The following path was not found.
* /usr/bin/pstack or /usr/bin/gstack
* pstack or gstack is required to dump the callstack.
****************************************************
Listener IPv4 port = 8629
Listener IPv6 port = 28629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
[tibero@node1 ~/tibero7/client/config]$ tbsql sys/tibero@node1
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero using node1.
SQL> select * from v$database;
DBID NAME DB_CREATE_DATE
---------- ---------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CF_CREATE_DATE CURRENT_TSN OPEN_MODE PROTECTION_MODE RESETLOG_TSN
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------- --------------- ------------
RESETLOG_DATE PREV_RESETLOG_TSN
-------------------------------------------------------------------------------------------------------------------------------- -----------------
PREV_RESETLOG_DATE DATABASE_ROLE STANDBY_BECAME_PRIMARY_TSN
-------------------------------------------------------------------------------------------------------------------------------- ----------------- --------------------------
STANDBY_BECAME_PRIMARY_DATE LOG_MODE FORCE_LOGGING CKPT_TSN
-------------------------------------------------------------------------------------------------------------------------------- ------------ ----------------- ----------
CKPT_DATE CPU_NAME PLATFORM_NAME
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------- --------------------------------
CPU_MODEL
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OS_UPTIME CM_OBSERVER
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------
91488347 node1 2025/12/16
2025/12/16 46513 READ WRITE UNPROTECTED 45289
2025/12/16 45122
2025/12/16 PRIMARY 0
ARCHIVELOG NO 46468
2025/12/17 X86 LINUX_X86_64
12th Gen Intel(R) Core(TM) i5-1240P
15:56:25 up 5:20, 4 users, load average: 0.42, 0.16, 0.09 DISABLED
1 row selected.
SQL> quit
Disconnected.
[tibero@node1 ~/tibero7/client/config]$ tbsql sys/tibero@node1_v6
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero using node1_v6.
SQL> select * from v$database;
DBID NAME DB_CREATE_DATE
---------- ---------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CF_CREATE_DATE CURRENT_TSN OPEN_MODE PROTECTION_MODE RESETLOG_TSN
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------- --------------- ------------
RESETLOG_DATE PREV_RESETLOG_TSN
-------------------------------------------------------------------------------------------------------------------------------- -----------------
PREV_RESETLOG_DATE DATABASE_ROLE STANDBY_BECAME_PRIMARY_TSN
-------------------------------------------------------------------------------------------------------------------------------- ----------------- --------------------------
STANDBY_BECAME_PRIMARY_DATE LOG_MODE FORCE_LOGGING CKPT_TSN
-------------------------------------------------------------------------------------------------------------------------------- ------------ ----------------- ----------
CKPT_DATE CPU_NAME PLATFORM_NAME
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------- --------------------------------
CPU_MODEL
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OS_UPTIME CM_OBSERVER
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------
91488347 node1 2025/12/16
2025/12/16 46516 READ WRITE UNPROTECTED 45289
2025/12/16 45122
2025/12/16 PRIMARY 0
ARCHIVELOG NO 46468
2025/12/17 X86 LINUX_X86_64
12th Gen Intel(R) Core(TM) i5-1240P
15:56:34 up 5:21, 4 users, load average: 0.36, 0.15, 0.09 DISABLED
1 row selected.
SQL> quit
Disconnected.IPv6 설정 시 유의사항
IPv6가 Local IP인 경우에는 반드시 % 뒤에 NIC 명을 기입해야 합니다.
Local IP의 경우 IP 주소는 fe80으로 시작합니다.
FileZilla 등 일부 프로그램에서 IPv6 주소를 사용하는 경우, 대괄호([]) 안에 IPv6 주소를 명시해야 합니다.
IPv4와 IPv6를 듀얼로 설정한 경우, Listener가 수행되는 Port를 제외한 나머지 통신은 모두 IPv4를 사용합니다.
IPv6 기능을 정상적으로 사용하기 위해서는 반드시 Tibero의 IPv6 관련 패치들을 적용해야 합니다.
ssh 접속 예시 --nic명 미기입 [tibero@node1 ~/tibero7/client/config]$ ssh root@fe80::a00:27ff:fe69:9cdd ssh: connect to host fe80::a00:27ff:fe69:9cdd port 22: Invalid argument --nic명 기입 [tibero@node1 ~/tibero7/client/config]$ ssh root@fe80::a00:27ff:fe69:9cdd%enp0s3 root@fe80::a00:27ff:fe69:9cdd%enp0s3's password: