Tibero Basics (I)

Startup

From the shell

tbboot [ -t <mode> ]

modes available: NOMOUNT MOUNT RECOVERY NORMAL RESETLOGS ALTERDD READONLY FAILOVER

 

Show license information

[tibero@demo ~]$ tbboot -l
        ############################
             License Information   
        ############################
          License Version:  1.0
                 Licensee:  demo
             License Type:  demo
             Product Name:  Tibero
          Product Version:  6
                  Edition:  enterprise
                   Module: 
               Issue Time:  2022/03/08
          Expiration Time:  2022/09/07
               Limit User:  UNLIMITED
                Limit CPU:  UNLIMITED
    Identification Method:  Hostname=demo

What happens when your license expires?

If your instance is running, it won’t be stopped.

If your instance crashed or it is manually stopped, you would be able to start only after a valid license file is place in the default location.

  • Location: $TB_HOME/license/license.xml
  • Please note that the file should be name “license.xml“

[tibero@demo ~]$ tbboot
  *************************************************************************
* ERROR: License expired!!
* (2) Check the license file - /home/tibero/tibero6/license/license.xml
  *************************************************************************

Shutdown

From the shell

tbdown [ -t <mode> ]

modes available: NORMAL, POST_TX, IMMEDIATE, ABORT.

 

Inside tbSQL

SQL> tbdown immediate
DB instance was terminated.

Switching between Archivelog Modes

  • tbdown
  • tbboot -t mount
  • Access tbSQL, and execute: ALTER DATABASE [ ARCHIVELOG | NOARCHIVELOG ];

 

Check Archivelog mode:

SQL> archive log list
NAME                            VALUE                                          
------------------------------- ------------------------------------------------
Database log mode               Archive Mode
Archive destination             /home/tibero/tibero6/database/tibero/archive/
Oldest online log sequence      1
Next log sequence to archive    1
Current log sequence            1
SQL> select log_mode from v$database;
LOG_MODE   
------------
ARCHIVELOG

Note: When switching between ARCHIVELOG modes, the previous backups get invalid. Therefore, make a full backup immediately after switching the mode.

 

Summary

Action
Oracle
Tibero
Check process status ps -ef | grep pmon ps -ef | grep svr
Configuration directory (init files, etc) $ORACLE_HOME/dbs $TB_HOME/config
Network config dir (TNSNAMES => DSN)

$ORACLE_HOME/rdbms/admin

= $TNS_ADMIN

$TB_HOME/client/config/tbdsn.tbr

= $TBDSN
Network (TNS) Aliases = DSN Aliases Case insensitive They are case sensitive