# MULTI INSERT INDEXES 적용
$cat control.ctl 
LOAD DATA
...
MULTI INSERT INDEXES
... 
(...)

# FAS BUILD INDEXES 적용
$cat control.ctl 
LOAD DATA
...
FAST BUILD INDEXES
... 
(...)

INSERT 하는 ROW의 내용(TABLE row 전체 + INDEX key 전체) + 
INSERT에 대한 UNDO(delete할 rowid + delete할 INDEX key)

UPDATE 내용(ROW의 내용 중 새로 변경되는 내용 + 변경되는 컬럼의 INDEX key delete/insert)
+ UPDATE에 대한 UNDO(row 변경을 되돌리는 내용 + INDEX key delete/insert)

DELETE되는 ROW에 대한 내용(rowid 정보 + INDEX key 전체)
+ DELETE에 대한 UNDO(row 전체 + INDEX key 전체)

java -classpath migrator_cli.jar:ojdbc6.jar:postgresql-42.2.27.jre6.jar:msllogger-
14.jar:toolcom.jar:internal-jdbc-16.jar:antlr-4.3-complete.jar com.m.migrator.Main "$@”

sh migrator.sh SOURCE_TYPE=ORACLE \
SOURCE_URL=jdbc:oracle:thin:@127.0.0.1:1521:orcl \
SOURCE_USER=system SOURCE_PASSWORD=manager SOURCE_LOGIN_AS=NORMAL \
SOURCE_SCHEMA=scott SOURCE_TABLE=emp \
TARGET_URL=jdbc:internal:thin:@127.0.0.2:8629:t7 \
TARGET_USER=dbtech TARGET_PASSWORD=dbtech

sh migrator.sh PROPERTY_FILE=migrator.properties

$ ls
tibero7-bin-FS02-windows64_2008-269353-20240314021215.zip

$ unzip tibero7-bin-FS02-linux64_3.10-254994.tar.gz

```shell
$ vi ~/.bash_profile
export TB_HOME=/home/tibero7_client/tibero7
export TB_SID=tibero
export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$TB_HOME/client/lib:$LD_LIBRARY_PATH

$ source ~/.bash_profile

$ cd $TB_HOME/config

$ sh gen_tip.sh Using TB_SID "tibero"
/home/tibero7_client/tibero7/config/tibero.tip generated
/home/tibero7_client/tibero7/config/psm_commands generated
/home/tibero7_client/tibero7/client/config/tbdsn.tbr generated. 
Running client/config/gen_esql_cfg.sh
Done.

$ cd $TB_HOME/client/config

$ ls
gen_esql_cfg.sh tbco_file_id tbdsn.tbr	tbimport_hl.config.default tbpcb.cfg 
tbc_file_id	tbdfdump.cfg tbertl.cfg tbpc.cfg

$ vi tbdsn.tbr 
#------------------------------------------------------------
# /home/tibero7_client/tibero7/client/config/tbdsn.tbr 
# Network Configuration File.
# Generated by gen_tip.sh at 2023. 06. 12. (월) 14:30:16 KST
tibero=(
    (INSTANCE=(HOST=192.168.xxx.xxx) 
              (PORT=8629)
              (DB_NAME=tibero)
     )
)

/tbsql tibero/tmax


TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> SELECT
    IPADDR, USERNAME 
FROM
    V$SESSION;	2	3	4

IPADDR
----------------------------------------------------------
USERNAME
-----------------------------------------------------------------------------------
192.168.xxx.xxx
TIBERO

$ chmod 640 [Control 파일|Redo 로그 파일|데이터 파일]

UTL_HTTP, UTL_FILE, DBMS_RANDOM, DBMS_LOB, DBMS_SQL, DBMS_JOB, 
DBMS_OBFUSCATION_TOOLKIT

SQL> REVOKE EXECUTE ON <패키지명> FROM PUBLIC;

SQL> REVOKE DBA FROM <username>;

SQL> ALTER USER <username> ACCOUNT LOCK;

SQL> ALTER USER <username> IDENTIFIED BY ‘<new_password>’;

SQL> CREATE PROFILE <profile_name>
    LIMIT PASSWORD_VERIFY_FUNCTION verify_function 
    FAILED_LOGIN_ATTEMPTS <횟수>;

SQL> ALTER PROFILE <profile_name> LIMIT FAILED_LOGIN_ATTEMPTS <횟수>;

SQL> ALTER USER <username> PROFILE <profile_name>;

SQL> ALTER PROFILE <profile_name> LIMIT PASSWORD_LOCK_TIME <시간>;

SQL> ALTER USER <username> PROFILE <profile_name>;

SQL> ALTER PROFILE <profile_name> LIMIT PASSWORD_LIFE_TIME <일수>;

SQL> ALTER USER <username> PROFILE <profile_name>;

SQL> ALTER PROFILE <profile_name> LIMIT PASSWORD_REUSE_TIME <일수>;

SQL> ALTER USER <username> PROFILE <profile_name>;

REVOKE <privilege> ON <system catalog object> FROM PUBLIC;

LSNR_INVITED_IP
LSNR_DENIED_IP
LSNR_INVITED_IP_FILE
LSNR_DENIED_IP_FILE

LSNR_INVITED_IP="192.168.20.0/24;192.168.10.101"

*** listener started and got into main loop ***
[INVITED-IP] 192.168.20.0 / 255.255.255.0
[INVITED-IP] 192.168.10.101 / 255.255.255.255

LSNR_INVITED_IP_FILE="/home/tibero/tibero7/invited.list"

# WAS_JEUS
192.168.22.20
192.168.44.10
### END OF FILE ###

#AUDIT Setting
AUDIT_TRAIL=OS
AUDIT_SYS_OPERATIONS=Y
AUDIT_FILE_DEST=/tibero/tbdata/audit/

0byte

16bytes(lob locator)

16bytes(lob locator) + 16bytes(lob inode)

16bytes(lob locator) + 16bytes(lob inode) + 48bytes(12 page dbas)

16bytes(lob locator) + 16bytes(lob inode) + 48bytes * (LOB 컬럼 크기 / 64KB)(lob index)

$ echo %TB_HOME% %TB_SID%
$ cd %TB_HOME%\bin
$ tbinstall.vbs %TB_HOME% %TB_SID%

$ echo %TB_HOME% %TB_SID%
$ cd %TB_HOME%\config
$ gen_tip.bat\

tibero=(
    (INSTANCE=(HOST=192.168.xxx.xxx) 
              (PORT=8629)
              (DB_NAME=tibero)
          )
)

C:\Users\tmax\Desktop\tibero7\config>tbsql tibero/tmax
SQL> SELECT IPADDR, USERNAME FROM V$SESSION;

IPADDR
-----------------------------------------------
USERNAME
---------------------------------------------------------------------------------
192.168.xxx.xxx
TIBERO

1 row selected.

$ echo %TB_HOME% %TB_SID%
$ cd %TB_HOME%\bin
$ tbuninstall.vbs

(Undo 테이블 스페이스당 Undo Segment 최소 개수 * _USGMT_UNIFORM_EXTSIZE * 2
* Block size(8KB)) + 여유값

(Undo 테이블 스페이스당 Undo Segment 최대 개수 * _USGMT_UNIFORM_EXTSIZE * 2
* Block size(8KB)) + 여유값

(초당 UNDO Block 소모량 * UNDO retention * Block size(8KB)) + 여유값

SQL> REVOKE <권한> ON <object> FROM PUBLIC

SQL> REVOKE <권한> ON <object명> FROM <user_name>;

SQL> GRANT <권한> ON <object명> TO <user_name>;

SQL> REVOKE <권한> ON <object명> FROM <user_name>;

SQL> GRANT <권한> ON <object명> TO <user_name>;

SQL> select * from v$sga;	

NAME		                        TOTAL		        USED
-------------------------------------  --------------------    ---------------
SHARED MEMORY		                1258291200		1258291200
FIXED MEMORY		                1032962080		1032962080
SHARED POOL MEMORY		        225312768		222298112
SHARED POOL ALLOCATORS (LC)		25165824		24048688
SHARED POOL ALLOCATORS (DD)		16777216		3620240
SHARED POOL ALLOCATORS (SLAB)		79691776		76092320
SHARED POOL ALLOCATORS (MISC)		100663296		98956536
SHARED POOL ALLOCATORS (Total)		222298112		202717784
Database Buffers		        838860800		838860800
Redo Buffers		                10485760		10485760
10 rows selected.				

SQL> show param total_shm_size

NAME		                        TOTAL		        USED
-------------------------------------  --------------------    ---------------
TOTAL_SHM_SIZE                          INT64                   1258291200

SQL> show param db_cache_size

NAME		                        TOTAL		        USED
-------------------------------------  --------------------    ---------------
DB_CACHE_SIZE                           UINT64                  838860800

SQL> show param log_buffer

NAME		                        TOTAL		        USED
-------------------------------------  --------------------    ---------------
FLASHBACK_LOG_BUFFER		        UINT32		        0
LOG_BUFFER		                UINT32		        10485760

TOTAL_SHM_SIZE - [Fixed Memory]

[전체 Shared Pool 크기] = _MIN_SHARED_POOL_SIZE + [CCC 공간] + [CWS 공간]
+ [Free Shared Pool 크기]

[Free Shared Pool 크기] > ([전체 Shared Pool 크기] - _MIN_SHARED_POOL_SIZE) / 2

FROM rockylinux:9

# Tibero 설치를 위한 환경 변수 설정
ENV TB_VERSION=7
ENV TB_BASE=/opt
ENV TB_HOME=$TB_BASE/tibero$TB_VERSION
ENV LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
ENV PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin

# Tibero 바이너리 파일 복사
COPY tibero.tar.gz /tmp/tibero.tar.gz

# 필수 패키지 설치
COPY ./scripts/install_dependency.sh /opt/install_dependency.sh
RUN chmod +x /opt/install_dependency.sh
RUN /opt/install_dependency.sh


# Tibero 설치
COPY ./scripts/install_tibero.sh /opt/install_tibero.sh
RUN chmod +x /opt/install_tibero.sh

# Entrypoint 스크립트 복사 및 권한 설정
COPY ./scripts/entrypoint.sh /opt/entrypoint.sh
RUN chmod +x /opt/entrypoint.sh

ENTRYPOINT ["/opt/entrypoint.sh"]

#!/bin/bash
set -e

# Install dependencies for Tibero
dnf update -y

dnf install -y gcc
dnf install -y gcc-c++
dnf install -y libaio
dnf install -y libaio-devel
dnf install -y sysstat
dnf install -y glibc-utils
dnf install -y ncurses-devel
dnf install -y libnsl
dnf install -y libnsl2
dnf install -y gdb
dnf install -y gdb-doc
dnf install -y gdb-gdbserver
dnf install -y gdb-headless
dnf install -y gdb-minimal
dnf install -y gdbm-libs
dnf install -y tar
dnf install -y vim
dnf install -y vi
dnf install -y hostname

# Tibero process 확인용 (pgrep)
dnf install -y procps-ng

dnf clean all


curl -O https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm
rpm -ivh epel-release-latest-9.noarch.rpm

dnf install -y nmon
dnf install -y java-1.8.0-openjdk-devel
dnf install -y ncurses-compat-libs

ln -s /usr/lib64/libncurses.so.6.2 /usr/lib64/libncurses.so.5 || true
ln -s /usr/lib64/libtinfo.so.6.2 /usr/lib64/libtinfo.so.5 || true
ln -s /usr/lib64/libform.so.6.2 /usr/lib64/libform.so.5 || true

#!/usr/bin/env bash
set -euo pipefail

# BOOT_POLICY=auto(기본) | manual
: "${BOOT_POLICY:=auto}"
: "${INSTALL_TGZ:=/tmp/tibero.tar.gz}"
: "${TB_PROC:=tbsvr}"          # Tibero 메인 프로세스명
: "${TB_START_CMD:=tbboot}"    # Tibero 기동 명령
: "${TB_DOWN_CMD:=tbdown}"     # Tibero 종료 명령

if [ -f /etc/bashrc ]; then
  set +u
  # /etc/bashrc 내부에서 BASHRCSOURCED를 사용할 수 있으므로 기본값 보장
  : "${BASHRCSOURCED:=0}"
  source /etc/bashrc || true
  set -u
fi

if [ -f "${HOME}/.bashrc" ]; then
  set +u
  : "${BASHRCSOURCED:=0}"
  source "${HOME}/.bashrc" || true
  set -u
fi

graceful_shutdown() {
  echo "[signal] Shutting down database (if running)..."
  ${TB_DOWN_CMD} immediate >/dev/null 2>&1 || true
  exit 0
}
trap graceful_shutdown SIGINT SIGTERM

# ===== 수동 모드: 설치/기동 모두 생략, 컨테이너만 유지 =======================
if [[ "${BOOT_POLICY}" == "manual" ]]; then
  echo "[mode] BOOT_POLICY=manual → skip install/boot. keeping container alive."
  echo "[note] even if ${INSTALL_TGZ} exists, will NOT install. will NOT run tbboot."
  # 컨테이너 생존 유지
  exec sleep infinity
fi

# ===== 자동 모드: 설치 및 기동 시도 ==========================================
# 1) 최초 생성 판단: tar.gz 존재시 설치 시도
if [ -f "${INSTALL_TGZ}" ]; then
  echo "[init] Found ${INSTALL_TGZ} → running /opt/install_tibero.sh ..."
  /opt/install_tibero.sh
fi

# 2) 서버 기동 시도
if ! pgrep "${TB_PROC}" >/dev/null 2>&1; then
  echo "[start] Starting Tibero..."
  if ! ${TB_START_CMD} >/dev/null 2>&1; then
    echo "[error] Failed to start Tibero (${TB_START_CMD}). Check logs."
    exit 1
  fi
fi

# 3) 기동 검증
if pgrep "${TB_PROC}" >/dev/null 2>&1; then
  echo "#########################"
  echo "Tibero is Ready To Use!"
  echo "#########################"
else
  echo "[error] Tibero process not found after start attempt."
  exit 1
fi

# 4) 컨테이너 생존 유지 (로그 tail이 필요 없으면 단순 sleep으로 유지)
exec sleep infinity

#!/bin/bash
set -e

if [ -f "/tmp/tibero.tar.gz" ]; then
  : "${TB_BASE:?TB_BASE is required}"
  mkdir -p "${TB_BASE}"
  tar -xzf "/tmp/tibero.tar.gz" -C "${TB_BASE}" && rm -f "/tmp/tibero.tar.gz"
  chmod -R 775 $TB_HOME
fi
echo "10% complete"

echo "Setting Environment Variables"

if [[ -n "${TB_USER_FILE:-}" && -f "${TB_USER_FILE}" ]]; then
  TB_USER="$(< "${TB_USER_FILE}")"
  export TB_USER
fi

if [[ -n "${TB_PASSWORD_FILE:-}" && -f "${TB_PASSWORD_FILE}" ]]; then
  TB_PASSWORD="$(< "${TB_PASSWORD_FILE}")"
  export TB_PASSWORD
fi

# 루트 패스워드 필수
if [[ -z "${TB_ROOT_PASSWORD:-}" ]]; then
  echo "[ERROR] TB_ROOT_PASSWORD environment variable is not set. Exiting." >&2
  exit 1
fi
if [[ -n "${TB_ROOT_PASSWORD_FILE:-}" && -f "${TB_ROOT_PASSWORD_FILE}" ]]; then
  TB_ROOT_PASSWORD="$(< "${TB_ROOT_PASSWORD_FILE}")"
  export TB_ROOT_PASSWORD
fi

: "${TB_HOME:?TB_HOME is required}"
if [ -f "${TB_HOME}/bin/base_env.sh" ]; then
  sed -i "s|^svr_sys_password=\"tibero\"$|svr_sys_password=\"${TB_ROOT_PASSWORD}\"|" \
    "${TB_HOME}/bin/base_env.sh"
fi

: "${TB_SID:=tibero}"
export TB_SID
echo "export TB_VERSION=\"${TB_VERSION}\"" >> "${HOME}/.bashrc"
echo "export TB_BASE=\"${TB_BASE}\"" >> "${HOME}/.bashrc"
echo "export TB_HOME=\"${TB_HOME}\"" >> "${HOME}/.bashrc"
echo "export LD_LIBRARY_PATH=\"${LD_LIBRARY_PATH}\"" >> "${HOME}/.bashrc"
echo "export PATH=\"${PATH}\"" >> "${HOME}/.bashrc"
echo "export TB_SID=\"${TB_SID}\"" >> "${HOME}/.bashrc"

echo "20% complete"


# Generating Tip file
echo "Generating tip file"
TIP_FILE_PATH=${TB_HOME}/config/${TB_SID}.tip

"${TB_HOME}/config/gen_tip.sh" -s "${TB_SID}"

# LOG_ARCHIVE_DEST 반영 (있으면 교체, 없으면 추가)
if [ -n "${LOG_ARCHIVE_DEST:-}" ]; then
  if grep -q "^LOG_ARCHIVE_DEST=" "${TIP_FILE_PATH}"; then
    sed -i "s|^LOG_ARCHIVE_DEST=.*|LOG_ARCHIVE_DEST=${LOG_ARCHIVE_DEST}|" "${TIP_FILE_PATH}"
  else
    printf "\nLOG_ARCHIVE_DEST=%s\n" "${LOG_ARCHIVE_DEST}" >> "${TIP_FILE_PATH}"
  fi
fi

echo "30% complete"

# # Setting DB Create environment variables
args=()
[ -n "$CHAR_SET" ] && args+=("-ch" "$CHAR_SET")
[ -n "$NCHAR_SET" ] && args+=("-nch" "$NCHAR_SET")
[ -n "$MAX_DATAFILE" ] && args+=("--max-datafile" "$MAX_DATAFILE")
[ -n "$MAX_LOGGROUP" ] && args+=("--max-loggroup" "$MAX_LOGGROUP")
[ -n "$MAX_LOGMEMBER" ] && args+=("--max-logmember" "$MAX_LOGMEMBER")
[ -n "$LOG_SIZE" ] && args+=("--log-size" "$LOG_SIZE")
[ -n "$LOG_GROUP" ] && args+=("--log-group" "$LOG_GROUP")
[ -n "$LOG_FILE" ] && args+=("--log-file" "$LOG_FILE")
[ -n "$LOG_DIR" ] && args+=("--log-dir" "$LOG_DIR")
[ -n "$SYS_SIZE" ] && args+=("--sys-size" "$SYS_SIZE")
[ -n "$SYS_DIR" ] && args+=("--sys-dir" "$SYS_DIR")
[ -n "$SYS_AUTOEXTEND" ] && args+=("--sys-autoextend" "$SYS_AUTOEXTEND")
[ -n "$SYS_NEXTSIZE" ] && args+=("--sys-nextsize" "$SYS_NEXTSIZE")
[ -n "$SYS_MAXSIZE" ] && args+=("--sys-maxsize" "$SYS_MAXSIZE")
[ -n "$TEMP_SIZE" ] && args+=("--temp-size" "$TEMP_SIZE")
[ -n "$TEMP_DIR" ] && args+=("--temp-dir" "$TEMP_DIR")
[ -n "$TEMP_AUTOEXTEND" ] && args+=("--temp-autoextend" "$TEMP_AUTOEXTEND")
[ -n "$TEMP_NEXTSIZE" ] && args+=("--temp-nextsize" "$TEMP_NEXTSIZE")
[ -n "$TEMP_MAXSIZE" ] && args+=("--temp-maxsize" "$TEMP_MAXSIZE")
[ -n "$UNDO_SIZE" ] && args+=("--undo-size" "$UNDO_SIZE")
[ -n "$UNDO_DIR" ] && args+=("--undo-dir" "$UNDO_DIR")
[ -n "$UNDO_AUTOEXTEND" ] && args+=("--undo-autoextend" "$UNDO_AUTOEXTEND")
[ -n "$UNDO_NEXTSIZE" ] && args+=("--undo-nextsize" "$UNDO_NEXTSIZE")
[ -n "$UNDO_MAXSIZE" ] && args+=("--undo-maxsize" "$UNDO_MAXSIZE")
[ -n "$USR_SIZE" ] && args+=("--usr-size" "$USR_SIZE")
[ -n "$USR_DIR" ] && args+=("--usr-dir" "$USR_DIR")
[ -n "$USR_AUTOEXTEND" ] && args+=("--usr-autoextend" "$USR_AUTOEXTEND")
[ -n "$USR_NEXTSIZE" ] && args+=("--usr-nextsize" "$USR_NEXTSIZE")
[ -n "$USR_MAXSIZE" ] && args+=("--usr-maxsize" "$USR_MAXSIZE")
[ -n "$SYSSUB_SIZE" ] && args+=("--syssub-size" "$SYSSUB_SIZE")
[ -n "$SYSSUB_DIR" ] && args+=("--syssub-dir" "$SYSSUB_DIR")
[ -n "$SYSSUB_AUTOEXTEND" ] && args+=("--syssub-autoextend" "$SYSSUB_AUTOEXTEND")
[ -n "$SYSSUB_NEXTSIZE" ] && args+=("--syssub-nextsize" "$SYSSUB_NEXTSIZE")
[ -n "$SYSSUB_MAXSIZE" ] && args+=("--syssub-maxsize" "$SYSSUB_MAXSIZE")
[ -n "$BACKUP_CTRLFILE" ] && args+=("--backup-ctrlfile" "$BACKUP_CTRLFILE")
[ -n "$SYSTEM_SCRIPT" ] && args+=("--system-script" "$SYSTEM_SCRIPT")


# creating the database
echo "Creating the database"
$TB_HOME/bin/tb_create_db.sh "${args[@]}"
echo "70% complete"

# Setting Archive log mode
if [ -n "$ARCHIVE_LOG_MODE" ] && [ "$ARCHIVE_LOG_MODE" == "Y" -o "$ARCHIVE_LOG_MODE" == "y" ]; then
  echo "Setting Archive log mode"
  tbdown
  tbboot mount
  tbsql sys/"$TB_ROOT_PASSWORD" <<EOF
ALTER DATABASE ARCHIVELOG;
EOF
  tbdown
  tbboot
fi
echo "90% complete"


# Setting up the database user
echo "Setting up the database user"

if { [ -n "${TB_USER:-}" ] && [ -z "${TB_PASSWORD:-}" ]; } || \
   { [ -z "${TB_USER:-}" ] && [ -n "${TB_PASSWORD:-}" ]; }; then
  echo "Cannot create database user: both TB_USER and TB_PASSWORD must be provided."
fi

if [ -n "${TB_USER:-}" ] && [ -n "${TB_PASSWORD:-}" ]; then
  tbsql "sys/${TB_ROOT_PASSWORD}" <<EOF
create user ${TB_USER} identified by '${TB_PASSWORD}';
grant dba to ${TB_USER};
EOF
fi

echo "100% complete"
echo "Tibero installation and database creation completed successfully."

docker build -t <이미지명>:<태그> .

.
├── Dockerfile
├── tibero.tar.gz
└── scripts
    ├── entrypoint.sh
    ├── install_dependency.sh
    └── install_tibero.sh