f debian-10.4.0 使用Tibero 6 ~ 迪貝之家

debian-10.4.0 使用Tibero 6

必要套件安裝 :
apt-get install build-essential libncurses5 libaio1
系統參數 /etc/sysctl.conf:
kernel.sem = 10000 32000 10000 10000
net.ipv4.ip_local_port_range= 1024 65000
fs.file-max=6815744
kernel.shmmni=4096
建立user tibero:
1.mkdir /home/tibero
2.useradd -d /home/tibero tibero
3. chown -R tibero:tibero /home/tibero
切換tibero 身分,解壓縮tibero binary 壓縮檔:
tar xvf tibero6-bin-FS07_CS_1912-linux64-174424-opt.tar.gz

編輯 .bash_profile:
export TB_HOME=/home/tibero/tibero6
export TB_SID=tibero
export PATH=$TB_HOME/bin:$TB_HOME/config:$TB_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH

產出資料庫參數檔:
. .bash_profile
gen_tip.sh
cp license.xml $TB_HOME/license
建置資料庫:
1.啟動instance
tbboot nomount
2.command line 登入instance,建立資料庫
tbsql sys/tibero
SQL>create database "tibero"
user sys identified by tibero
maxinstances 8
maxdatafiles 100
character set ZHT16MSWIN950
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;
3.建立internal view
sys與syscat的預設密碼為tibero及syscat
執行下列指令時,依序敲入密碼
$TB_HOME/scripts/system.sh
4.上述指令執行完會自動shutdown 資料庫
所以我們要手動把資料庫帶起來
tbboot
5. 登入測試
tibero
有趣的是,其實原本沒有tbdown指令
是system.sh指令執行完之後
它才做了一個softlink
tibero