| 必要套件安裝 : |
| 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 |
