必要套件安裝 : |
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. 登入測試 |
有趣的是,其實原本沒有tbdown指令 |
是system.sh指令執行完之後 |
它才做了一個softlink |