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-184.108.40.206-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
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:
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
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.
To start using the database, simply use:
Enjoy Tibero !!
- 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)
- Interesting to review in official Tibero Administrator Guide.
- 5.5. Network Access Control
- 5.5.3. Dynamically Adding and Deleting a Listener Port
- Data Encryption
- 11.4.1. Creating an Encrypted Tablespace
- Communication Encryption
- 1.5.3. Encrypting Connection String
- Backups (RMGR)
- Block Change Tracking (Static Parameter + Best Practice)
- Tibero Performance Repository (TPR ~ AWR+ASH)
- External Tables in HDFS or HBase
- tbdsn.tbr (~Tnsnames)
Load Balancing & Connection Failover