I am glad to introduce Tibero is a relational database management system. It is able to do everything that others do and more. Active active cluster , Active passive disaster recovery solutions, row level locking and additional security abilities etc.
In this step-by-step aricle you will find detailed instructions on how to install stand alone tibero RDBMS installation. For details and setup files you can visit technet.tmaxsoft.com
Operating system : Scientific Linux 7.1 x86_64
Tibero : tibero6-bin-6_rel_FS02-linux64-109628-opt-tested.tar.gz
Memory : 3G
Server : Virtual machine on VirtualBox
Preparing operating system
Required rpm packages
|
1 2 3 4 5 6 7 8 |
rpm -qa | grep gcc-* rpm -qa | grep gcc-c++-* rpm -qa | grep libgcc-* rpm -qa | grep libstdc++-* rpm -qa | grep libstdc++-devel-* rpm -qa | grep compat-libstdc++-* rpm -qa | grep libaio-* rpm -qa | grep libaio-devel-* |
install required packages
|
1 2 3 4 5 6 7 8 |
yum install -y gcc-*l yum install -y gcc-c++-* yum install -y libgcc-* yum install -y libstdc++-* yum install -y libstdc++-devel-* yum install -y compat-libstdc++-* yum install -y libaio-* yum install -y libaio-devel-* |
Kernel parameters
firstly backing up config files
|
1 2 |
cp /etc/security/limits.conf /etc/security/limits.conf_bck echo -e 'tibero hard nofile 65536\ntibero soft nofile 4096\ntibero soft nproc 4096\ntibero hard nproc 16384' >> /etc/security/limits.conf |
|
1 2 |
cp /etc/pam.d/login /etc/pam.d/login_bck echo session required pam_limits.so >> /etc/pam.d/login |
|
1 2 |
cp /etc/sysctl.conf /etc/sysctl.conf_bck echo -e 'kernel.shmmni = 4096\nkernel.sem = 10000 32000 10000 10000\nfs.file-max = 6553600\nnet.ipv4.ip_local_port_range = 1024 65000\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max = 1048576' >> /etc/sysctl.conf |
For RHEL 6x
|
1 2 |
service iptables stop chkconfig iptables off |
For RHEL 7x
|
1 2 |
systemctl stop firewalld systemctl disable firewalld |
Adding groups/user
|
1 2 3 |
/usr/sbin/groupadd -g 502 dba /usr/sbin/useradd -u 502 -g dba tibero passwd tibero --> tibero |
Directories
|
1 2 3 |
mkdir /Tibero tar -xvf /tmp/tibero6-bin-6_rel_FS02-linux64-109628-opt-tested.tar.gz -C /Tibero/ chown -R tibero:dba /Tibero |
ntp configuration
|
1 2 |
cp /etc/ntp.conf /etc/ntp.conf_bck echo -e 'server 0.tr.pool.ntp.org\nserver 1.tr.pool.ntp.org\nserver 2.tr.pool.ntp.org\nserver 3.tr.pool.ntp.org' >> /etc/ntp.conf |
You should change ntp server addresses according to your requirements
Adding “-x” option
|
1 2 3 |
vi /etc/sysconfig/ntpd OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid -g" service ntpd restart |
Adding Tibero environment settings to .bash_profile
|
1 |
echo -e 'TB_HOME=/Tibero/tibero6; export TB_HOME\nTB_SID=tibero; export export TB_SID\nLD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib; export LD_LIBRARY_PATH\nexport PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin' >> /home/tibero/.bash_profile |
demo license needed for installation you can obtain it from technet.tmaxsoft.com
|
1 2 |
chown tibero:dba /tmp/license.xml cp /tmp/license.xml file to /Tibero/tibero6/license/ |
Following steps will be done with tibero user
Installing and running Tibero
|
1 2 3 |
$TB_HOME/config/gen_tip.sh tbboot nomount tbsql sys/tibero |
Please note that you should change character set according to software requirements
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
create database "tibero" user sys identified by tibero maxinstances 8 maxdatafiles 100 character set WE8ISO8859P9 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; exit |
Running system.sh
|
1 2 |
tbboot $TB_HOME/scripts/system.sh |
passwords
sys –> tibero
syscat –> syscat
to monitor what is going on
|
1 |
tail -f /Tibero/tibero6/instance/tibero/log/dbmslog |
testing installation
|
1 |
tbsql sys/tibero |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SELECT i.version, bd.value "Build Ver" , i.instance_name , d.name "DB name" , i.status, ch.value "NLS_CHARACTERSET" , d.log_mode , d.create_date "DB create_date" , d.current_tsn , d.ckpt_tsn , l.edition, l.expire_date, l.limit_user, l.limit_cpu FROM _vt_instance i, v$database d, _vt_license l, (SELECT value FROM _vt_version WHERE name='BUILD_NUMBER') bd , (SELECT value FROM _dd_props WHERE name='NLS_CHARACTERSET') ch; |
to drop database
|
1 2 |
tbdown rm -rf $TB_HOME/database/TB_SID/* |
Queries
13 March 2019