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