Document Type | Technical Information
Category | Administration
Applicable Product Version | Tibero 7.2.2
Document Number | TADTI199
Overview
This document contains the basic information needed for users new to Tibero to check the Tibero installation environment. For detailed information about features, please refer to the manual.
Method
Environment Variables
There are environment configuration files for the OS user account (.bashrc, .bash_profile, .profile, etc.). These include environment variables for Tibero.
| Item | Description | Script |
| TB_HOME | Tibero Engine Path | $ echo $TB_HOME |
| TB_SID | Tibero Instance Name | $ echo $TB_SID |
| .profile | OS User Configuration File | $ cat ~/.bash_profile (.profile) |
Example
#TB_HOME
tb7@edu1[tb7]:/home/tb7> echo $TB_HOME
/home/tb7/tibero7
# TB_SID
tb7@edu1[tb7]:/home/tb7> echo $TB_SID
tb7
# .profile
export TB_HOME=/home/tb7/tibero7
export TB_SID=tb7
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH
Tibero Initialization Parameter
The "Tibero Initialization Parameter (.tip)" is a database environment file. Tibero parameters are configured as "Key=value".
| TIP (Tibero Initialization Parameter) | Description |
| DB_NAME | Specifies the unique name of the database |
| LISTENER_PORT | Specifies the port used for client connections |
| CONTROL_FILES | Specifies the path of the control file containing the database metadata |
| DB_CREATE_FILE_DEST | Specifies the default path where files created by the database are stored |
| LOG_ARCHIVE_DEST | Specifies the path where archivelogs are generated |
| MAX_SESSION_COUNT | Maximum number of concurrent connections allowed |
| TOTAL_SHM_SIZE | Sets the size of shared memory used by the database |
| MEMORY_TARGET | Sets the total memory size used by the database |
Example
# Tip (Location : $TB_HOME/config/$TB_SID.tip)
DB_NAME=tb7
LISTENER_PORT=8629
CONTROL_FILES="/home/tb7/tbdata/c1.ctl"
DB_CREATE_FILE_DEST="/home/tb7/tbdata"
LOG_ARCHIVE_DEST="/home/tb7/tbarch"
#CERTIFICATE_FILE="/home/tb7/tibero7/config/tb_wallet/tb7.crt"
#PRIVKEY_FILE="/home/tb7/tibero7/config/tb_wallet/tb7.key"
#WALLET_FILE="/home/tb7/tibero7/config/tb_wallet/WALLET"
#ILOG_MAP="/home/tb7/tibero7/config/ilog.map"
MAX_SESSION_COUNT=20
TOTAL_SHM_SIZE=1G
MEMORY_TARGET=2G
Tibero System files
These are system-related files required for Tibero to start up to NORMAL MODE. After Tibero installation is complete, CONTROLFILE, SYSTEM, UNDO, SYSSUB, USR, TEMP, REDOLOG, and .passwd files are basically configured. When Tibero is running normally, you can check their locations and information using SQL commands.
| Item | Description | Script |
| Controlfile | Binary file that stores the database's own metadata | SQL> select * from v$controlfile; |
| Datafiles | SYSTEM: Tablespace containing Data Dictionary (Meta Data) information UNDO: Tablespace for commit/rollback SYSSUB: Tablespace for TPR USR: General user tablespace (created by default) | SQL> select * from dba_data_files where tablespace_name in ('SYSTEM','UNDO','SYSSUB','USR') order by tablespace_name; |
| Tempfiles | Tablespace used for swapping when memory space is insufficient | SQL> select * from dba_temp_files; |
| Redo Log | Log files that store all changes occurring in the database | SQL> select * from v$log; SQL> select * from v$logfile; |
| .passwd | Used for authentication during boot in nomount and mount modes | Located in DB_CREATE_FILE_DEST |
Example
# Controlfile
SQL> set lines 200
SQL> col name for a30
SQL> select * from v$controlfile;
STATUS NAME BLKSIZE BLOCKS
---------- ------------------------------ ---------- ----------
0 /home/tb7/tbdata/c1.ctl 16384 1521
1 row selected.
# SYSTEM Datafiles
SQL> set lines 200
SQL> col file_name for a32
SQL> col tablespace_name for a10
SQL> col maxbytes for 999999999999
SQL> select *
from dba_data_files
where tablespace_name in ('SYSTEM','UNDO','SYSSUB','USR')
order by tablespace_name;
FILE_NAME FILE_ID TABLESPACE BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY ONLINE_STATUS
-------------------------------- ---------- ---------- ---------- ---------- --------- ------------ -------------- ------------- ---------- ------------ -------------
/home/tb7/tbdata/syssub001.dtf 3 SYSSUB 104857600 12800 AVAILABLE 3 YES 1073741824 131072 1280 ONLINE
/home/tb7/tbdata/system001.dtf 0 SYSTEM 104857600 12800 AVAILABLE 0 YES 1073741824 131072 1280 SYSTEM
/home/tb7/tbdata/undo001.dtf 1 UNDO 209715200 25600 AVAILABLE 1 YES 1073741824 131072 1280 ONLINE
/home/tb7/tbdata/usr001.dtf 2 USR 104857600 12800 AVAILABLE 2 YES 1073741824 131072 1280 ONLINE
# SYSTEM Tempfiles
SQL> set lines 200
SQL> col file_name for a32
SQL> col tablespace_name for a10
SQL> col maxbytes for 999999999999
SQL> select * from dba_temp_files;
FILE_NAME FILE_ID TABLESPACE BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY
---------------------------------------- ---------- ---------- ---------- ---------- --------- ------------ -------------- ------------- ---------- ------------
/home/tb7/tbdata/temp001.dtf 0 TEMP 104857600 12800 AVAILABLE 0 YES 1073741824 131072 1280
# RedoLog files
SQL> select * from v$log;
THREAD# GROUP# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- -------- ------------- ------------------------------
0 0 4 52428800 2 NO CURRENT 38511 2025/10/15 16:49:09
0 1 2 52428800 2 NO INACTIVE 2 2025/10/15 16:29:44
0 2 3 52428800 2 NO INACTIVE 2312 2025/10/15 16:32:50
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
---------- ------- ------ -----------------------------
0 NORMAL ONLINE /home/tb7/tbdata/log001.log
0 NORMAL ONLINE /home/tb7/tbdata/log002.log
1 NORMAL ONLINE /home/tb7/tbdata/log003.log
1 NORMAL ONLINE /home/tb7/tbdata/log004.log
2 NORMAL ONLINE /home/tb7/tbdata/log005.log
2 NORMAL ONLINE /home/tb7/tbdata/log006.log
# .passwd
tb7@edu1[tb7]:/home/tb7/tbdata> ls -al
total 995600
drwxr-xr-x. 3 tb7 dba 4096 Oct 15 16:50 .
drwxr-xr-x. 5 tb7 dba 141 Oct 15 16:19 ..
-rw-r--r--. 1 tb7 dba 44 Oct 15 16:30 .passwd
-rw-------. 1 tb7 dba 75743232 Oct 15 17:15 c1.ctl
drwx------. 3 tb7 dba 17 Oct 15 16:50 java
-rw-------. 1 tb7 dba 52428800 Oct 15 17:11 log001.log
-rw-------. 1 tb7 dba 52428800 Oct 15 17:11 log002.log
-rw-------. 1 tb7 dba 52428800 Oct 15 16:32 log003.log
-rw-------. 1 tb7 dba 52428800 Oct 15 16:32 log004.log
-rw-------. 1 tb7 dba 52428800 Oct 15 16:49 log005.log
-rw-------. 1 tb7 dba 52428800 Oct 15 16:49 log006.log
-rw-------. 1 tb7 dba 104857600 Oct 15 16:50 syssub001.dtf
-rw-------. 1 tb7 dba 104857600 Oct 15 17:11 system001.dtf
-rw-------. 1 tb7 dba 104857600 Oct 15 16:29 temp001.dtf
-rw-------. 1 tb7 dba 209715200 Oct 15 17:11 undo001.dtf
-rw-------. 1 tb7 dba 104857600 Oct 15 16:50 usr001.dtf
Tibero Instance Logs
Once Tibero is installed, logs are generated by default in the $TB_HOME/instance/$TB_SID/log directory. You can change the location through the parameter (tip).
| File | Remark |
| slog | This file is for debugging. It records important tasks performed by the server and is used to find causes of server performance degradation or to fix bugs in Tibero itself. |
| dlog | This file records information more important than that recorded in the system log file, such as server startup and shutdown, and execution of DDL statements. |
| Ilog | System logs for events set per thread are recorded in this file. To view internal logs, use tbiv. |
| lsnr | This file is for listener debugging. It records important events occurring in the listener and is used to fix listener bugs. |
| act | This log file is created when the server's activity monitor detects that an arbitrary thread has been stopped for a long time while checking other threads' operations. It is used for analyzing causes of long inactivity of threads. |
| audit | This file records the audit trail of database users using system privileges or schema object privileges. |
Example
# Location : $TB_HOME/instance/$TB_SID/log
tb7@edu1[test]:/home/tb7> cd $TB_HOME/instance/$TB_SID/log
tb7@edu1[test]:/home/tb7/tibero7/instance/test/log> ll
total 288
drwxr-xr-x. 9 tb7 dba 113 Oct 15 16:36 .
drwxr-xr-x. 6 tb7 dba 70 Oct 15 16:32 ..
drwxr-xr-x. 2 tb7 dba 21 Oct 15 16:24 act
drwxr-xr-x. 2 tb7 dba 23 Oct 15 16:24 audit
drwxr-xr-x. 2 tb7 dba 22 Oct 15 16:24 diag
drwxr-xr-x. 2 tb7 dba 22 Oct 15 16:24 dlog
drwxr-xr-x. 3 tb7 dba 8192 Oct 15 16:49 ilog
drwxr-xr-x. 2 tb7 dba 28 Oct 15 16:24 lsnr
drwxr-xr-x. 2 tb7 dba 21 Oct 15 16:24 slog
Tibero Client Connection
5.1 tbsql
An interactive utility provided by Tibero for processing SQL statements.
# No alias defaults to TB_SID
tb7@edu1[tb7]:/home/tb7/tibero7> tbsql sys/tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL>
# tbdsn.tbr alias usage
tb7@edu1[tb7]:/home/tb7/tibero7> tbsql sys/tibero@tb7
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero using tb7.
SQL>
5.2 tbdsn.tbr
An environment file that sets connection information for the client to access the Tibero server.
| Parameter | Description |
| HOST | Server IP address |
| PORT | Server port number |
| DB_NAME | Database name |
# Location : $TB_HOME/client/config/tbdsn.tbr
tb7=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=tb7)
)
)
example)
tibero7=(
(INSTANCE=(HOST=192.168.56.101)
(PORT=8629)
(DB_NAME=tb7)
)
)