2023-08-14 16:19:25 +00:00
|
|
|
|
- CentOS
|
|
|
|
|
|
- (사전작업) JDK 설치 [[CentOS Java 설치]]
|
|
|
|
|
|
```Shell
|
|
|
|
|
|
|
|
|
|
|
|
# 필수 패키지 설치
|
|
|
|
|
|
yum install -y gcc gcc-c++ libgcc libstdc++ libstdc++-devel compat-libstdc++ libaio libaio-devel pstack libpthread librt libm libaio libdl
|
|
|
|
|
|
|
|
|
|
|
|
yum install -y gcc
|
|
|
|
|
|
yum install -y gcc-c++
|
|
|
|
|
|
yum install -y libgcc
|
|
|
|
|
|
yum install -y libstdc++
|
|
|
|
|
|
yum install -y libstdc++-devel
|
|
|
|
|
|
yum install -y libaio
|
|
|
|
|
|
yum install -y libaio-devel
|
|
|
|
|
|
|
|
|
|
|
|
# compat-libstdc++ 수동으로 다운로드해서 설치
|
|
|
|
|
|
rpm -ivh /tmp/tmp/tibero_pac/temp/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
|
|
|
|
|
|
|
|
|
|
|
|
yum install -y pstack -> gdb dstat
|
|
|
|
|
|
yum install -y libpthread
|
|
|
|
|
|
yum install -y librt
|
|
|
|
|
|
yum install -y libm
|
|
|
|
|
|
yum install -y libdl
|
|
|
|
|
|
|
|
|
|
|
|
## RHEL 8.1 이상은 아래 추가 설치
|
|
|
|
|
|
yum install -y libnsl.so.1 -> libnsl
|
|
|
|
|
|
|
|
|
|
|
|
# 직접 설치해야 함
|
|
|
|
|
|
# yum install -y libncurses.so.5
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/libgcc-11.3.1-2.1.el9.i686.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/glibc-2.34-40.el9.i686.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/glibc-gconv-extra-2.34-40.el9.i686.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/libstdc++-11.3.1-2.1.el9.i686.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-libs-6.2-8.20210508.el9.i686.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-term-6.2-8.20210508.el9.noarch.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-base-6.2-8.20210508.el9.noarch.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-libs-6.2-8.20210508.el9.x86_64.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-6.2-8.20210508.el9.x86_64.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-c++-libs-6.2-8.20210508.el9.i686.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-c++-libs-6.2-8.20210508.el9.x86_64.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-c++-libs-6.2-8.20210508.el9.x86_64.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-devel-6.2-8.20210508.el9.x86_64.rpm &&
|
|
|
|
|
|
rpm -ivh /tmp/tibero_pac/ncurses-devel-6.2-8.20210508.el9.i686.rpm
|
2024-08-23 08:36:39 +00:00
|
|
|
|
|
|
|
|
|
|
yum install -y libgcc
|
|
|
|
|
|
yum install -y glibc
|
|
|
|
|
|
yum install -y glibc-gconv-extra
|
|
|
|
|
|
yum install -y libstdc++
|
|
|
|
|
|
yum install -y ncurses-libs
|
|
|
|
|
|
yum install -y ncurses-term
|
|
|
|
|
|
yum install -y ncurses-base
|
|
|
|
|
|
yum install -y ncurses-libs
|
|
|
|
|
|
yum install -y ncurses
|
|
|
|
|
|
yum install -y ncurses-c++-lib
|
|
|
|
|
|
|
2023-08-14 16:19:25 +00:00
|
|
|
|
## 링크 생성
|
|
|
|
|
|
ln -s /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5
|
|
|
|
|
|
ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5
|
|
|
|
|
|
|
|
|
|
|
|
---------------------------------------------------------------------------------
|
|
|
|
|
|
# JAVA 설치
|
|
|
|
|
|
# JDK 설치 가능한 버전 확인
|
|
|
|
|
|
yum list java*jdk
|
|
|
|
|
|
|
|
|
|
|
|
# JDK 1.8 설치
|
|
|
|
|
|
yum install -y java-1.8.0-openjdk.x86_64
|
|
|
|
|
|
|
|
|
|
|
|
# java 설치 경로를 확인 (맨위의 폴더)
|
|
|
|
|
|
ls -l /usr/lib/jvm/
|
|
|
|
|
|
|
|
|
|
|
|
# 환경변수 설정 (파일의 맨 하단에 추가)
|
|
|
|
|
|
vi /etc/profile
|
|
|
|
|
|
> export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.222.b10-0.el7_6.x86_64
|
|
|
|
|
|
> export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.352.b08-2.el7_9.x86_64
|
|
|
|
|
|
# 환경변수 반영
|
|
|
|
|
|
source /etc/profile
|
|
|
|
|
|
------------------------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
# 메모리확인(byte)
|
|
|
|
|
|
## total의 Mem 확인
|
|
|
|
|
|
free -b
|
|
|
|
|
|
## Page size 확인 ( 4096 byte = 32768B)
|
|
|
|
|
|
getconf PAGESIZE |sed -e :a -e 's/\(.*[0-9]\)\([0-9]\{3\}\)/\1.\2/;ta'
|
|
|
|
|
|
|
|
|
|
|
|
# 커널 파라미터 설정
|
|
|
|
|
|
sudo nano /etc/sysctl.conf
|
|
|
|
|
|
|
2024-08-23 08:36:39 +00:00
|
|
|
|
kernel.sem = 10000 32000 10000 10000
|
|
|
|
|
|
kernel.shmall = 1976652500
|
|
|
|
|
|
kernel.shmmax = 8096368640
|
|
|
|
|
|
kernel.shmmni = 4096
|
|
|
|
|
|
fs.file-max = 67108864
|
|
|
|
|
|
fs.aio-max-nr = 1048576
|
|
|
|
|
|
net.ipv4.ip_local_port_range = 1024 65000
|
|
|
|
|
|
|
|
|
|
|
|
# 커널 파라미터 설정 적용
|
|
|
|
|
|
sudo sysctl -p
|
|
|
|
|
|
|
2023-08-14 16:19:25 +00:00
|
|
|
|
|
|
|
|
|
|
# Shell Limits 파라미터 설정
|
|
|
|
|
|
/etc/security/limits.conf
|
|
|
|
|
|
----------------------------
|
|
|
|
|
|
MAX_SESSION_COUNT=20 이상
|
|
|
|
|
|
----------------------------
|
|
|
|
|
|
* soft nofile 65536
|
|
|
|
|
|
* hard nofile 65536
|
|
|
|
|
|
* soft nproc 65536
|
|
|
|
|
|
* hard nproc 65536
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
## RHEL 7.2 이상 버전부터는 아래 커널 파라미터 설정이 필요
|
|
|
|
|
|
vi /etc/systemd/logind.conf
|
|
|
|
|
|
RemoveIPC=no
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
mkdir /etc/tibero
|
|
|
|
|
|
tar -zxvf tibero7.tar.gz
|
|
|
|
|
|
|
|
|
|
|
|
# /license 폴더에 licence.xml 복사
|
|
|
|
|
|
|
|
|
|
|
|
# 환경변수 설정
|
2024-08-23 08:36:39 +00:00
|
|
|
|
export TB_HOME=/home/tibero/tibero7
|
|
|
|
|
|
export TB_SID=sacp
|
|
|
|
|
|
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH
|
|
|
|
|
|
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH
|
|
|
|
|
|
export SHLIB_PATH=$LD_LIBRARY_PATH:$SHLIB_PATH
|
|
|
|
|
|
export LIBPATH=$LD_LIBRARY_PATH:$LIBPATH
|
2023-08-14 16:19:25 +00:00
|
|
|
|
|
|
|
|
|
|
# 라이선스 복사
|
|
|
|
|
|
$TB_HOME/license
|
|
|
|
|
|
|
|
|
|
|
|
# gen_tip 실행
|
|
|
|
|
|
cd $TB_HOME/config
|
|
|
|
|
|
./gen_tip.sh
|
|
|
|
|
|
|
|
|
|
|
|
# 마운트 모드로 가동
|
|
|
|
|
|
cd $TB_HOME/bin > tbboot nomount
|
|
|
|
|
|
|
|
|
|
|
|
# sys 접속후 테이블 스페이스 생성
|
|
|
|
|
|
cd $TM_HOM/bin > tbsql sys/tibero
|
|
|
|
|
|
|
|
|
|
|
|
# 재기동
|
|
|
|
|
|
cd $TM_HOM/bin > tbdown
|
|
|
|
|
|
cd $TM_HOM/bin > tbboot
|
|
|
|
|
|
|
2024-08-23 08:36:39 +00:00
|
|
|
|
# 포트번호 변경
|
|
|
|
|
|
nano $TB_HOME/config/$TB_SID.tip
|
|
|
|
|
|
nano $TB_HOME/client/config/tbdsn.tbr
|
|
|
|
|
|
|
2023-08-14 16:19:25 +00:00
|
|
|
|
# system.sh 실행
|
|
|
|
|
|
cd $TB_HOME/scripts
|
2024-08-23 08:36:39 +00:00
|
|
|
|
./system.sh -p1 tibero -p2 syscat -a1 y -a2 y -a3 y -a4 y
|
2023-08-14 16:19:25 +00:00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# 프로세스 확인
|
|
|
|
|
|
ps -ef | grep tbsvr
|
|
|
|
|
|
$TB_HOME
|
|
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
```Shell
|
|
|
|
|
|
기본 포트 : 8629
|
|
|
|
|
|
|
|
|
|
|
|
# 포트번호 변경
|
|
|
|
|
|
vi $TB_HOME/config/$TB_SID.tip
|
|
|
|
|
|
|
|
|
|
|
|
# 특정 포트 허용
|
|
|
|
|
|
firewall-cmd --permanent --zone=public --add-port=18629/tcp
|
|
|
|
|
|
|
|
|
|
|
|
# firewall 설정 적용
|
|
|
|
|
|
firewall-cmd --reload
|
|
|
|
|
|
```
|
