- 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 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 ## 링크 생성 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 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 # 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 복사 # 환경변수 설정 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 # 라이선스 복사 $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 # 포트번호 변경 nano $TB_HOME/config/$TB_SID.tip nano $TB_HOME/client/config/tbdsn.tbr # system.sh 실행 cd $TB_HOME/scripts ./system.sh -p1 tibero -p2 syscat -a1 y -a2 y -a3 y -a4 y # 프로세스 확인 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 ```