1. 커널파라미터확인
- fs.file-max : 커널이할당할수있는파일핸들최대값 (권장값 : 65535)
- kernel.sem : 세마포어관련설정. semmsl semmns semopm semmni 순서로설정
• semmsl : 세마포어셋당세마포어최대개수 (권장값 : 250)
• semmns : 전체시스템의세마포어최대개수 (권장값 : 3200)
• semopm : 시스템호출별로수행될수있는세마포어수 (권장값 : 100)
• semmni : 전체시스템의세마포어셋최대개수 (권장값 : 128)
- kernel.shmmax : 공유메모리최대값 (권장값 : 1073741824)
2. 커널파라미터수정
- root 접속하여아래제시한권장값을기준으로각사이트운영환경에맞추어설정
- 커널파라미터동적변경시
# sysctl -w fs.file-max=65535
# sysctl -w kernel.sem="256 32000 100 128"
# sysctl -w kernel.shmmax=1073741824
|
- 커널파라미터정적변경시
• 아래커널파라미터항목을 sysctl.conf 파일에추가
• sysctl.conf에추가한후 sysctl –p 명령으로동적으로적용가능
fs.file-max = 65536
kernel.sem = 250 32000 100 128
kernel.shmmax = 1073741824
|
3. 티베로 OS 유저생성 (Group명 : tmax 유저명 : tibero)
- OS의사용자등록 command를사용하여 Tibero를설치할사용자를등록
- 그룹명 : tmax, 유저명 : tibero 설정
예) useradd –g tmax tibero
4. 티베로설치디렉토리생성
예) /home/tibero
5. 유저환경변수설정
- 유저로접속, 계정홈디렉토리에있는환경파일수정 (bash shell경우: (vi /home/tibero/.bash_profile)
- Linux (공통)
### Tibero ENV ###
export TB_HOME=/home/tibero/tibero4
export TB_SID=tibero
export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$TB_HOME/client/lib:$LD_LIBRARY_PATH
|
- AIX (공통)
### Tibero ENV ###
export TB_HOME=/home/tibero/tibero4
export TB_SID=tibero
export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export LIBPATH=$TB_HOME/client/lib:$LIBPATH
export LINK_CNTRL=L_PTHREADS_D7
|
- HP (공통)
### Tibero ENV ###
export TB_HOME=/home/tibero/tibero4
export TB_SID=tibero
export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export SHLIB_PATH=$TB_HOME/client/lib:$TB_HOME/bin:$SHLIB_PATH
|
- HP (공통)
### Tibero ENV ###
export TB_HOME=/home/tibero/tibero4
export TB_SID=tibero
export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export SHLIB_PATH=$TB_HOME/client/lib:$TB_HOME/bin:$SHLIB_PATH
|
- Solaris (공통) (32bit 경우)
### Tibero ENV ###
export TB_HOME=/home/tibero/tibero4
export TB_SID=tibero
export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$TB_HOME/client/lib:$LD_LIBRARY_PATH
|
- Alias 관련환경설정 (필요시)
### Tibero ALIAS ###
alias tbhome='cd $TB_HOME'
alias tblog='cd ${TB_HOME}/instance/$TB_SID/log'
alias tbcfg='cd $TB_HOME/config'
alias tbcfgv='vi $TB_HOME/config/$TB_SID.tip'
alias tbi='cd ~/tbinary'
alias tbdata='cd ~/tbdata'
|
6. 티베로바이너리압축해제
- tibero 폴더밑으로바이너리옮김
$ cd /home/tibero
$ tar –xvzf tibero_banary.tar.gz
|
7. 초기환경파일생성
$ cd $TB_HOME/config
$ ./gen_tip.sh
|
- 환경변수로지정한 TB_SID에따라 $TB_HOME/config/TB_SID.tip 생성
- psm을실행하기위한 gen_psm_cmd.sh 파일실행 (이작업은 Window에서는하지않음)
8. 라이센스적용
- Hostname에맞는 license.xml 파일을발급 (명령어 : hostname )
- 라이센스폴더생성 (엔진설치직후라이선스폴더가생성되지않음)
$ cd $TB_HOME
$ mkdir license
|
- $TB_HOME/license 디렉토리생성후라이선스파일을이디렉토리에복사
$ mv [Original File Path] [Move File Path]
|
9. Tibero 파라미터파일수정 ($TB_HOME/config/$TB_SID.tip)
#-------------------------------------------------------------------------------
# tibero 초기화 parameter
#-------------------------------------------------------------------------------
DB_NAME=tibero
LISTENER_PORT=8629
CONTROL_FILES="/home/tibero/tbdata/c1.ctl"
CERTIFICATE_FILE="/home/tibero/tibero4/client/ssl/certs/tb_cert.pem"
DB_CREATE_FILE_DEST= ‘/home/tibero/tbdata’
PRIVKEY_FILE="/home/sina22/tibero4/client/ssl/private/tb_privkey.key"
DBWR_CNT=1
DBMS_LOG_TOTAL_SIZE_LIMIT=300M
TRACE_LOG_TOTAL_SIZE_LIMIT=300M
WTHR_PROC_CNT=1
_WTHR_PER_PROC=10
TOTAL_SHM_SIZE=320M
DB_BLOCK_SIZE=8K
DB_CACHE_SIZE=256M
LOG_BUFFER=10M
LOG_LVL=4
# module, work log example:
#LOG_LVL_FRM=5
#LOG_WORK_LVL_RECOVERY=5
SQL_LOG_ON_MEMORY=Y
#_BTRACE_METHOD=1
BTRACE_FILE_LIMIT=1M
BTRACE_TOTAL_LIMIT=10G
BTRACE_MAP="/home/sina22/tibero4/config/btrace.map"
BTRACE_USEC=Y
|
10. Network 설정파일($TB_HOME/client/config/tbnet_alias.tbr) 수정가능
- Client가 Tibero에접속시필요한통신환경을설정하는파일
tibero=( # Tibero Client 접속 Alias (=SID)
IP=localhost # 접속할 Tibero IP
PORT=8629 # 접속할 Tibero Port (=Tip파일의 Port#와동일)
DB_NAME=tibero # 접속할 Tibero Database 명
)
|
|