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.<\/p>\n
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<\/p>\n
Operating system<\/strong> : Scientific Linux 7.1 x86_64 <\/p>\n Preparing operating system<\/strong><\/span> Kernel parameters<\/strong> For RHEL 6x<\/strong> For RHEL 7x<\/strong> Directories<\/strong> ntp configuration<\/strong> Adding Tibero environment settings to .bash_profile<\/strong> demo license needed for installation you can obtain it from technet.tmaxsoft.com Installing and running Tibero<\/strong> [crayon] Running system.sh<\/strong> passwords<\/strong> testing installation<\/strong> [crayon] I am glad to introduce Tibero is a relational database management system. <\/p>\n","protected":false},"author":1,"featured_media":2622,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[383,338],"tags":[345],"class_list":["post-2621","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dba_i","category-oracle-tr","tag-oracle"],"_links":{"self":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/comments?post=2621"}],"version-history":[{"count":1,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2621\/revisions"}],"predecessor-version":[{"id":4819,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2621\/revisions\/4819"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/media?parent=2621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/categories?post=2621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/tags?post=2621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nTibero<\/strong> : tibero6-bin-6_rel_FS02-linux64-109628-opt-tested.tar.gz
\nMemory<\/strong> : 3G
\nServer<\/strong> : Virtual machine on VirtualBox<\/p>\n
\nRequired rpm packages<\/strong>
\n[crayon]
\nrpm -qa | grep gcc-*
\nrpm -qa | grep gcc-c++-*
\nrpm -qa | grep libgcc-*
\nrpm -qa | grep libstdc++-*
\nrpm -qa | grep libstdc++-devel-*
\nrpm -qa | grep compat-libstdc++-*
\nrpm -qa | grep libaio-*
\nrpm -qa | grep libaio-devel-*
\n[\/crayon]
\ninstall required packages<\/strong>
\n[crayon]
\nyum install -y gcc-*l
\nyum install -y gcc-c++-*
\nyum install -y libgcc-*
\nyum install -y libstdc++-*
\nyum install -y libstdc++-devel-*
\nyum install -y compat-libstdc++-*
\nyum install -y libaio-*
\nyum install -y libaio-devel-*
\n[\/crayon]<\/p>\n
\nfirstly backing up config files
\n[crayon]
\ncp \/etc\/security\/limits.conf \/etc\/security\/limits.conf_bck
\necho -e ‘tibero hard nofile 65536\\ntibero soft nofile 4096\\ntibero soft nproc 4096\\ntibero hard nproc 16384’ >> \/etc\/security\/limits.conf
\n[\/crayon]
\n[crayon]
\ncp \/etc\/pam.d\/login \/etc\/pam.d\/login_bck
\necho session required pam_limits.so >> \/etc\/pam.d\/login
\n[\/crayon]
\n[crayon]
\ncp \/etc\/sysctl.conf \/etc\/sysctl.conf_bck
\necho -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
\n[\/crayon]<\/p>\n
\n[crayon]
\nservice iptables stop
\nchkconfig iptables off
\n[\/crayon]<\/p>\n
\n[crayon]
\nsystemctl stop firewalld
\nsystemctl disable firewalld
\n[\/crayon]
\nAdding groups\/user<\/strong>
\n[crayon]
\n\/usr\/sbin\/groupadd -g 502 dba
\n\/usr\/sbin\/useradd -u 502 -g dba tibero
\npasswd tibero –> tibero
\n[\/crayon]<\/p>\n
\n[crayon]
\nmkdir \/Tibero
\ntar -xvf \/tmp\/tibero6-bin-6_rel_FS02-linux64-109628-opt-tested.tar.gz -C \/Tibero\/
\nchown -R tibero:dba \/Tibero
\n[\/crayon]<\/p>\n
\n[crayon]
\ncp \/etc\/ntp.conf \/etc\/ntp.conf_bck
\necho -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
\n[\/crayon]
\nYou should change ntp server addresses according to your requirements
\nAdding “-x” option<\/strong>
\n[crayon]
\nvi \/etc\/sysconfig\/ntpd
\nOPTIONS=”-x -u ntp:ntp -p \/var\/run\/ntpd.pid -g”
\nservice ntpd restart
\n[\/crayon]<\/p>\n
\n[crayon]
\necho -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
\n[\/crayon]<\/p>\n
\n[crayon]
\nchown tibero:dba \/tmp\/license.xml
\ncp \/tmp\/license.xml file to \/Tibero\/tibero6\/license\/
\n[\/crayon]
\nFollowing steps will be done with tibero user<\/p>\n
\n[crayon]
\n$TB_HOME\/config\/gen_tip.sh
\ntbboot nomount
\ntbsql sys\/tibero
\n[\/crayon]
\nPlease note that you should change character set according to software requirements<\/p>\n
\ncreate database “tibero”
\nuser sys identified by tibero
\nmaxinstances 8
\nmaxdatafiles 100
\ncharacter set WE8ISO8859P9
\nlogfile group 1 ‘log001.log’ size 100M,
\ngroup 2 ‘log002.log’ size 100M,
\ngroup 3 ‘log003.log’ size 100M
\nmaxloggroups 255
\nmaxlogmembers 8
\nnoarchivelog
\ndatafile ‘system001.dtf’ size 100M
\nautoextend on next 100M
\nmaxsize unlimited
\ndefault temporary tablespace TEMP
\ntempfile ‘temp001.dtf’ size 100M
\nautoextend on next 100M
\nmaxsize unlimited
\nextent management local autoallocate
\nundo tablespace UNDO
\ndatafile ‘undo001.dtf’ size 100M
\nautoextend on next 100M
\nmaxsize unlimited
\nextent management local autoallocate;
\nexit
\n[\/crayon]<\/p>\n
\n[crayon]
\ntbboot
\n$TB_HOME\/scripts\/system.sh
\n[\/crayon]<\/p>\n
\nsys –> tibero
\nsyscat –> syscat
\nto monitor what is going on
\n[crayon]
\ntail -f \/Tibero\/tibero6\/instance\/tibero\/log\/dbmslog
\n[\/crayon]<\/p>\n
\n[crayon]
\ntbsql sys\/tibero
\n[\/crayon]<\/p>\n
\nSELECT i.version,
\nbd.value “Build Ver” ,
\ni.instance_name ,
\nd.name “DB name” ,
\ni.status,
\nch.value “NLS_CHARACTERSET” ,
\nd.log_mode ,
\nd.create_date “DB create_date” ,
\nd.current_tsn ,
\nd.ckpt_tsn ,
\nl.edition,
\nl.expire_date,
\nl.limit_user,
\nl.limit_cpu
\nFROM _vt_instance i,
\nv$database d,
\n_vt_license l,
\n(SELECT value
\nFROM _vt_version
\nWHERE name=’BUILD_NUMBER’) bd ,
\n(SELECT value
\nFROM _dd_props
\nWHERE name=’NLS_CHARACTERSET’) ch;
\n[\/crayon]
\nto drop database
\n[crayon]
\ntbdown
\nrm -rf $TB_HOME\/database\/TB_SID\/*
\n[\/crayon]<\/p>\n","protected":false},"excerpt":{"rendered":"