tibero TAC 설치 - 환경 설정

### bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

ulimit -c 0
stty erase ^H
export TMOUT=0

## TAC
export TB_SID=tac1
#export TB_SID=tac2
export TB_HOME=/sw/tibero/tibero6
export TB_BASE=/sw/tibero
export CM_SID=cm1
#export CM_SID=cm2
export CM_HOME=$TB_HOME
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin

# TMAX alias
alias tbhome='cd $TB_HOME'
alias tblog='cd $TB_HOME/instance/$TB_SID/log'
alias tbout='cd $TB_HOME/instance/$TB_SID'
alias tbcfg='cd $TB_HOME/config'
alias tbcfgv='vi $TB_HOME/config/$TB_SID.tip'
alias tbcli='cd ${TB_HOME}/client/config'
alias tbcliv='vi ${TB_HOME}/client/config/tbdsn.tbr'
alias tbdata='cd $TB_HOME/../tbdata'
alias tbi='cd $HOME/tbinary'
alias tm='sh $HOME/tbinary/monitor/monitor'
alias tstat='ps -ef | egrep "tbsvr|tblistener" | grep -v grep'
alias tnet='netstat -tlpn | grep tblistener'

# Extra alias
alias ..='. ~/.bash_profile'
alias pro='vi ~/.bash_profile'
alias pp='ps -ef | egrep "tblistener|tbsvr" | grep -v grep'

alias sys="$TB_HOME/client/bin/tbsql sys"
alias tib="$TB_HOME/client/bin/tbsql tibero"

alias boot="$TB_HOME/bin/tbboot normal"
alias down="$TB_HOME/bin/tbdown immediate"

alias dlog="cd $TB_HOME/instance/$TB_SID/log/dlog"
alias slog="cd $TB_HOME/instance/$TB_SID/log/slog"
alias tsl="tail -f $TB_HOME/instance/$TB_SID/log/slog/sys.log"

 

 

### tac1.tip

DB_NAME=tibero
LISTENER_PORT=21000
CONTROL_FILES="/dev/raw/raw2","/dev/raw/raw21"
DB_CREATE_FILE_DEST=/sw/tibero/tbdata/
LOG_ARCHIVE_DEST=/sw/tibero/tbdata/log/

DBWR_CNT=1

DBMS_LOG_TOTAL_SIZE_LIMIT=300M

MAX_SESSION_COUNT=30

TOTAL_SHM_SIZE=2G
MEMORY_TARGET=4G
DB_BLOCK_SIZE=8K
DB_CACHE_SIZE=300M


CLUSTER_DATABASE=Y
THREAD=0
UNDO_TABLESPACE=UNDO0

############### CM #######################
CM_PORT=61040
_CM_LOCAL_ADDR=192.168.137.150
LOCAL_CLUSTER_ADDR=10.10.10.10
LOCAL_CLUSTER_PORT=61050
###########################################

 

 

### tac2.tip

DB_NAME=tibero
LISTENER_PORT=21000
CONTROL_FILES="/dev/raw/raw2","/dev/raw/raw21"
DB_CREATE_FILE_DEST=/sw/tibero/tbdata/
LOG_ARCHIVE_DEST=/sw/tibero/tbdata/log/

DBWR_CNT=1

DBMS_LOG_TOTAL_SIZE_LIMIT=300M

MAX_SESSION_COUNT=30

TOTAL_SHM_SIZE=2G
MEMORY_TARGET=4G
DB_BLOCK_SIZE=8K
DB_CACHE_SIZE=300M


CLUSTER_DATABASE=Y
THREAD=0
UNDO_TABLESPACE=UNDO1

############### CM #######################
CM_PORT=61040
_CM_LOCAL_ADDR=192.168.137.151
LOCAL_CLUSTER_ADDR=10.10.10.20
LOCAL_CLUSTER_PORT=61050
###########################################

 

 

 

### cm1.tip

CM_NAME=cm1
CM_UI_PORT=61040

CM_HEARTBEAT_EXPIRE=450
CM_WATCHDOG_EXPIRE=400
LOG_LVL_CM=5


CM_RESOURCE_FILE=/sw/tibero/cm_resource/cmfile
CM_RESOURCE_FILE_BACKUP=/sw/tibero/cm_resource/cmfile_backup
CM_RESOURCE_FILE_BACKUP_INTERVAL=1


CM_LOG_DEST=/sw/tibero/tibero6/instance/tac1/log/cm
CM_GUARD_LOG_DEST=/sw/tibero/tibero6/instance/tac1/log/cm_guard

CM_FENCE=Y
CM_ENABLE_FAST_NET_ERROR_DETECTION=Y
_CM_CHECK_RUNLEVEL=Y

 

 

 

### cm2.tip

CM_NAME=cm2
CM_UI_PORT=61040

CM_HEARTBEAT_EXPIRE=450
CM_WATCHDOG_EXPIRE=400
LOG_LVL_CM=5


CM_RESOURCE_FILE=/sw/tibero/cm_resource/cmfile
CM_RESOURCE_FILE_BACKUP=/sw/tibero/cm_resource/cmfile_backup
CM_RESOURCE_FILE_BACKUP_INTERVAL=1


CM_LOG_DEST=/sw/tibero/tibero6/instance/tac2/log/cm
CM_GUARD_LOG_DEST=/sw/tibero/tibero6/instance/tac2/log/cm_guard

CM_FENCE=Y
CM_ENABLE_FAST_NET_ERROR_DETECTION=Y
_CM_CHECK_RUNLEVEL=Y

 

 

### tbdsn.tbr --- 1번/2번 노드 동일

tibero=(
    (INSTANCE=(HOST=192.168.137.150)
                (PORT=21000)
                (DB_NAME=tibero)
    )
    (INSTANCE=(HOST=192.168.137.151)
                (PORT=21000)
                (DB_NAME=tibero)
    )
    (LOAD_BALANCE=Y)
    (USE_FAILOVER=Y)
)


tac1=(
    (INSTANCE=(HOST=192.168.137.150)
              (PORT=21000)
              (DB_NAME=tibero)
    )
)
tac2=(
    (INSTANCE=(HOST=192.168.137.151)
              (PORT=21000)
              (DB_NAME=tibero)
    )
)

 

 

 

### Create Database

CREATE DATABASE "tibero"
                   USER sys IDENTIFIED BY tibero
          MAXINSTANCES 8
          MAXDATAFILES 256
CHARACTER set MSWIN949
NATIONAL character set UTF16
LOGFILE GROUP 0 ('/dev/raw/raw3','/dev/raw/raw22') SIZE 127M,
        GROUP 1 ('/dev/raw/raw4','/dev/raw/raw23') SIZE 127M,
        GROUP 2 ('/dev/raw/raw5','/dev/raw/raw24') SIZE 127M
        MAXLOGFILES 100
          MAXLOGMEMBERS 8
          ARCHIVELOG
         DATAFILE '/dev/raw/raw10' SIZE 127M
         AUTOEXTEND off          
         DEFAULT TABLESPACE USR
         DATAFILE '/dev/raw/raw11' SIZE 127M
        AUTOEXTEND off
        DEFAULT TEMPORARY TABLESPACE TEMP
        TEMPFILE '/dev/raw/raw12' SIZE 127M
        AUTOEXTEND off
        UNDO TABLESPACE UNDO0
        DATAFILE '/dev/raw/raw9' SIZE 127M
        AUTOEXTEND off ;