[ Linux ] TIBERO 설치

yum -y install libaio

mkdir -p /app/install/dbms /app/dbms/tibero

tar xvfz /app/install/dbms/tibero6-bin-FS07_CS_2005-linux64_3.10-189892-opt.tar.gz -C /app/dbms/tibero --strip-components=1

mv /app/install/dbms/license.xml /app/dbms/tibero/license/license.xml

cat <<'TIBERO_SETTING' >> /root/.bashrc

export TB_HOME=/app/dbms/tibero
export TB_SID=MSSSRCH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
TIBERO_SETTING

cat <<'TIBERO_SETTING' >> /root/.bash_profile

export TB_HOME=/app/dbms/tibero
export TB_SID=MSSSRCH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
TIBERO_SETTING

cat <<'TIBERO_SETTING' >> /root/.profile

export TB_HOME=/app/dbms/tibero
export TB_SID=MSSSRCH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
TIBERO_SETTING

source /root/.bashrc

$TB_HOME/config/gen_tip.sh

tbboot nomount

tbsql sys/tibero

create database TIBERO
user sys identified by tibero
maxinstances 8
maxdatafiles 100
character set MSWIN949
national character set UTF16
logfile
group 1 'log001.log' size 100M,
group 2 'log002.log' size 100M,
group 3 'log003.log' size 100M
maxloggroups 255
maxlogmembers 8
noarchivelog
datafile 'system001.dtf' size 100M autoextend on next 100M maxsize unlimited
default temporary tablespace TEMP
tempfile 'temp001.dtf' size 100M autoextend on next 100M maxsize unlimited
extent management local autoallocate
undo tablespace UNDO
datafile 'undo001.dtf' size 100M autoextend on next 100M maxsize unlimited
extent management local autoallocate;

quit

tbboot

echo -e "tibero\nsyscat\nY\nY\nY\nY" | $TB_HOME/scripts/system.sh

ps -ef | grep tbsvr

chmod +x /etc/rc.d/rc.local

# tbdown clean
# tbboot
# 명령어 추가
# /etc/rc.d/rc.local

tbsql sys/tibero

CREATE TABLESPACE TIBERO 
DATAFILE '/app/dbms/tibero/database/tibero/TIBERO.dtf' SIZE 1G
AUTOEXTEND ON NEXT 100M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K;

CREATE USER user IDENTIFIED BY P@ssw0rd! 
DEFAULT TABLESPACE TIBERO;

GRANT RESOURCE, CONNECT, DBA TO user;

quit;

<<UTF8_SETTING
CREATE DATABASE TIBERO
USER sys IDENTIFIED BY tibero
MAXDATAFILES 256
CHARACTER SET UTF8
national character set UTF8
LOGFILE 
GROUP 0 ('log001.log') SIZE 50M,
GROUP 1 ('log011.log') SIZE 50M,
GROUP 2 ('log021.log') SIZE 50M
MAXLOGFILES 100
MAXLOGMEMBERS 8
NOARCHIVELOG
DATAFILE 'system001.tdf' SIZE 512M AUTOEXTEND ON NEXT 8M MAXSIZE 3G
DEFAULT TEMPORARY  TABLESPACE TEMP TEMPFILE 'temp001.tdf' SIZE 512M AUTOEXTEND ON NEXT 8M MAXSIZE 1G EXTENT MANAGEMENT LOCAL AUTOALLOCATE
UNDO TABLESPACE UNDO DATAFILE 'undo001.tdf' SIZE 512M AUTOEXTEND ON NEXT 8M MAXSIZE 1G EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
UTF8_SETTING

# Driver Name : Tibero
# Class Name : com.tmax.tibero.jdbc.TbDriver
# URL Template : jdbc:tibero:thin:@{host}[:{port}]:{database}
# example : jdbc:tibero:thin:@127.0.0.1:8629:tibero_sid
# Default Port : 8629