Testing Tibero Database on your own

For the ones that does not know about Tibero or TmaxSoft, here the main websites to  know and information:

Official Website: https://www.tmaxsoft.com/products/tibero/

Support Website: https://support.tmaxsoft.com/

  • Software Download
  • 6-Months demo license
  • Community Support (free)

Official Documentation: https://technet.tmaxsoft.com/upload/download/online/tibero/pver-20150504-000002/index.html

The fastest way to try out Tibero, it is our free PLSQL-as-a-Service or SQLaaS. You have instantly a schema in our Tibero test DB and you are truly isolated from other users and your data is encrypted as if you configure Tibero encryption on-premises.

Or to deploy it automatically with the Cloud. After deployment, you would need to create the database still.

Please note that sometimes the image in the Cloud contains a expired license from the time it was built. In this case, refer to support website and exchange the license key for a new one and you would be able to continue.

If the options above are NOT your interest and you want to prepare and install from scratch a machine to run Tibero Database, this is your post.

Requirements and Recommendations

  • Recommended OS: RHEL +6.5 or CentOS +6.5 for testing.
  • Min RAM: 4 GB
  • Min CPU or vCPU: 2
  • Database Home: 1-2 GB is enough. Recommended to allocate at least 5 GB as minimum for Production environments.

Prepare the server

As root or sudo user execute the following:

  • Install required linux packages
  • Install OpenJDK
  • Set Kernel parameters
  • Set Shell parameters
  • Set NTP Server
yum clean all
yum repolist
yum -y update

# Install necessary packages (Tibero 6)
yum -y install java-1.8.0-openjdk-devel.x86_64 libibverbs net-tools ntp bc gcc \
gcc-c++ libgcc libstdc++ libstdc++-devel \
compat-libstdc++ libaio libaio-devel net-tools \
kernel-headers kernel-devel perl make systemd tree bc
### /etc/sysctl.conf ###
# kernel parameters
fs.file-max = 6815744
kernel.sem = 100000 100000 100000 100000
kernel.shmall = 24706143
kernel.shmmax = 101196361728
fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 67108864
net.core.wmem_max = 67108864
### /etc/security/limits.conf ###
*    -    nofile    65536
*    -    nproc     65536
groupadd -g 500 dba
useradd -g dba tibero
# JDK Selection
# as root, select the latest OpenJDK installed. Save the path for next command.
# (Example: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.181-7.b13.el7.x86_64)
java -version

echo "export JAVA_HOME=___________HERE_YOUR_PATH_____________" 
>> /home/tibero/.bash_profile
#NTP Slewness Option
echo '
# Enabling Slewing Option
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid -g"
' > /etc/sysconfig/ntpd

systemctl start ntpd
systemctl enable ntpd
systemctl status ntpd

systemctl restart ntpd.service
ps -ef | grep ntpd
#You should be able to see ntpd running with "-x" as parameter.

Extra, Optional configuration:

# Tibero .bash_profile
export TB_SID=t6a
export TB_HOME=/home/tibero/tibero6
export TB_CONFIG=$TB_HOME/config
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
#Optional: SQL> SAVE CREDENTIAL;  --When DB is created.
#export ISQL_WALLET_PATH=~/wallet.dat

export PS1='[SID=$TB_SID \u@\h:\w]$ '

#Cluster Manager (Cluster env. only)
#export CM_SID=cm0
#export CM_HOME=$TB_HOME

# Aliases (Optional)
alias ll='ls -lart'

alias talert='ls -l $TB_HOME/instance/$TB_SID/log/slog/sys.log && tail -f $TB_HOME/instance/$TB_SID/log/slog/sys.log'
alias config='cd $TB_CONFIG && ls -l *.tip'
alias tip='cat $TB_CONFIG/$TB_SID.tip && ls -l $TB_CONFIG/$TB_SID.tip'
alias dsn='cat $TB_HOME/client/config/tbdsn.tbr && ls -l $TB_HOME/client/config/tbdsn.tbr'
# Tibero .bash_profile

Installation

Ensure you have downloaded the latest version of Tibero and you have requested a demo license. The demo license should be placed in $TB_HOME/license/license.xml or the default lookup location is: $HOME/license.xml

#Example
cp license.xml $TB_HOME/license/license.xml

Tibero license is issued as per server in the manual fashion. (Bulk and automatic licensing is for existing customers only). While requesting a license, ensure that you fulfill your hostname with the output of the following command:

uname -n

Extract the Software

cd /home/tibero
tar -xzvf tibero6-*

Creating your first Tibero Database

If this is your first Tibero DB, you are good to continue. If you seek to test Production-ready environment, better check the documentation.

  • On-Premises, you can test a shared-disk cluster architecture or you can test 2-tier database architecture or Tibero Zeta.
#Relogin as tibero, so aliases take effect.
$TB_CONFIG/gen_tip.sh
$TB_HOME/bin/tb_create_db.sh

You can provide a good amount of parameters to this script. In case it is continuously requesting for passwords.
You can open another session and use the following:

#Optional: SQL> SAVE CREDENTIAL;  --When DB is created.
#export ISQL_WALLET_PATH=~/wallet.dat

To start using the database, simply use:

tbsql sys/tibero

Enjoy Tibero !!

Next Steps

  • Develop: Connect using an IDE. Download Tibero Admin from TmaxSoft Support page.
    • Upgrade your JDK to the latest version and ensure your JAVA_PATH and PATH are up to date.
  • Migrate to Tibero? You can use T-Up. It is located in $TB_HOME/client/bin. You have to unzip T-Up to use it.
  • Monitor and Admin GUI? Tibero Admin is the single-database develop and administration tool.
    The enterprise administration tool for large-scale environments is a free-of-charge Software called DB Manager or Tibero Manager.

Migrate to Tibero? T-Up

For extended information, Check Official docs. This is a quick guide.

T-Up is the migration assistant from Tibero. You can connect Source and Destination, make a compatibility analysis and do a one-off migration.

T-Up is located in $TB_HOME/client/bin directory.

Before migrating from Oracle DB, you should copy all JDBC jar files to T-Up/lib folder.

cd $TB_HOME/client/bin
unzip T-Up.zip
cd T-Up

cp $ORACLE_HOME/jdbc/lib/* $TB_HOME/client/bin/lib/

Now you can start T-Up and perform a migration.

#For Linux x86_64
$TB_HOME/client/bin/T-Up.x86_64 &

Some Cool stuff (Easy)

Continue your Journey (Advanced/Medium level)