Tibero 기동 및 종료

login as: tibero
tibero@192.168.56.241's password:
Last login: Thu Apr  6 14:14:37 2023 from 192.168.56.1
[tibero@T1:/home/tibero]$
[tibero@T1:/home/tibero]$
[tibero@T1:/home/tibero]$
[tibero@T1:/home/tibero]$
[tibero@T1:/home/tibero]$ tbhome
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ ls -l config/$TB_SID.tip
-rw-r--r-- 1 tibero dba 262 Apr  6 14:34 config/tibero.tip
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ grep CONTROL config/$TB_SID.tip
CONTROL_FILES="/tibero/tbdata/tibero/c1.ctl","/tibero/tbdata/tibero/c2.ctl"
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ ls -l client/config/tbdsn.tbr
-rw-r--r-- 1 tibero dba 286 Apr  6 14:32 client/config/tbdsn.tbr
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ cat client/config/tbdsn.tbr
#-------------------------------------------------
# /tibero/tibero7/client/config/tbdsn.tbr
# Network Configuration File.
# Generated by gen_tip.sh at Thu Apr  6 14:32:38 KST 2023
tibero=(
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=tibero)
    )
)
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ vi client/config/tbdsn.tbr
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ ls -al client/config/
total 32
drwxr-xr-x  2 tibero dba  231 Apr  7 09:59 .
drwxr-xr-x 10 tibero dba  105 Apr  6 14:31 ..
-rwxr-xr-x  1 tibero dba  786 Jun 24  2022 gen_esql_cfg.sh
-rw-rw-rw-  1 tibero dba    0 Apr  6 14:32 .tbc_file_id
-rw-r--r--  1 tibero dba    4 Jun 24  2022 tbc_file_id
-rw-rw-rw-  1 tibero dba    0 Apr  6 14:32 .tbco_file_id
-rw-r--r--  1 tibero dba    0 Jun 24  2022 tbco_file_id
-rw-r--r--  1 tibero dba 1406 Jun 24  2022 tbdfdump.cfg
-rw-r--r--  1 tibero dba  286 Apr  6 14:32 tbdsn.tbr
-rw-r--r--  1 tibero dba  497 Jun 24  2022 tbertl.cfg
-rw-r--r--  1 tibero dba  242 Jun 24  2022 tbimport_hl.config.default
-rw-r--r--  1 tibero dba  318 Jun 24  2022 tbpcb.cfg
-rw-r--r--  1 tibero dba  593 Jun 24  2022 tbpc.cfg
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ ls -al client/config/
total 32
drwxr-xr-x  2 tibero dba  231 Apr  7 09:59 .
drwxr-xr-x 10 tibero dba  105 Apr  6 14:31 ..
-rwxr-xr-x  1 tibero dba  786 Jun 24  2022 gen_esql_cfg.sh
-rw-rw-rw-  1 tibero dba    0 Apr  6 14:32 .tbc_file_id
-rw-r--r--  1 tibero dba    4 Jun 24  2022 tbc_file_id
-rw-rw-rw-  1 tibero dba    0 Apr  6 14:32 .tbco_file_id
-rw-r--r--  1 tibero dba    0 Jun 24  2022 tbco_file_id
-rw-r--r--  1 tibero dba 1406 Jun 24  2022 tbdfdump.cfg
-rw-r--r--  1 tibero dba  286 Apr  6 14:32 tbdsn.tbr
-rw-r--r--  1 tibero dba  497 Jun 24  2022 tbertl.cfg
-rw-r--r--  1 tibero dba  242 Jun 24  2022 tbimport_hl.config.default
-rw-r--r--  1 tibero dba  318 Jun 24  2022 tbpcb.cfg
-rw-r--r--  1 tibero dba  593 Jun 24  2022 tbpc.cfg
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ vi client/config/tbdsn.tbr
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ cat client/config/tbdsn.tbr
#-------------------------------------------------
# /tibero/tibero7/client/config/tbdsn.tbr
# Network Configuration File.
# Generated by gen_tip.sh at Thu Apr  6 14:32:38 KST 2023
tibero=(
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=tibero)
    )
)

tibero2=(
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=tibero)
    )
)

[tibero@T1:/tibero/tibero7]$ tbsql sys/tibero@tibero2

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero using tibero2.

SQL> q
Disconnected.
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$
[tibero@T1:/tibero/tibero7]$ cd /
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$ tbsql sys/tibero@localhost:8629/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> q
Disconnected.
[tibero@T1:/]$
[tibero@T1:/]$ tbsql

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

SQL> CONNECT sys/tibero@localhost:8629/tibero
Connected to Tibero.

SQL> DISCONNECT
Disconnected.
SQL>
SQL> EXIT
[tibero@T1:/]$
[tibero@T1:/]$ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> QUIT
Disconnected.
[tibero@T1:/]$ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> select 1 from dual;

         1
----------
         1

1 row selected.

SQL> SELECT 1 FROM DUAL;

         1
----------
         1

1 row selected.

SQL>  select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/tibero/tbdata/tibero/system001.dtf
/tibero/tbdata/tibero/undo001.dtf
/tibero/tbdata/tibero/usr001.dtf
/tibero/tbdata/tibero/syssub001.dtf

4 rows selected.

SQL> show parameter DB_CREATE_FILE_DEST

NAME                         TYPE     VALUE                            
---------------------------- -------- ----------------------------------------
DB_CREATE_FILE_DEST          DIRNAME  /tibero/tbdata/tibero/

SQL> Q
Disconnected.
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$ ls -l instance/$TB_SID
ls: cannot access instance/tibero: No such file or directory
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$ ls $TB_HOME/instance/$TB_SID/log
dlog  ilog  lsnr  slog  system_init.log
[tibero@T1:/]$ cd slog
-bash: cd: slog: No such file or directory
[tibero@T1:/]$ ls $TB_HOME/instance/$TB_SID/log/slog
sys.log
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$ tail -n10 $TB_HOME/instance/$TB_SID/log/slog/sys.log
[2023-04-07T00:01:00.928115] [DDL-99] [I] Executing DDL: drop table sys.tmp_20230407000100837281000_ purge
[2023-04-07T00:01:01.021350] [DDL-99] [I] DDL execution succeeded
[2023-04-07T00:01:02.073716] [DDL-99] [I] Executing DDL: create global temporary table sys.tmp_20230407000102073573000_ on commit preserve rows cache as select  "OBJ_ID" , "LINE_NO" , "SERIAL_NO" , "SRC"  from "SYS"."_DD_SRC" where 1 = 0
[2023-04-07T00:01:02.094251] [DDL-99] [I] DDL execution succeeded
[2023-04-07T00:01:02.119409] [DDL-99] [I] Executing DDL: drop table sys.tmp_20230407000102073573000_ purge
[2023-04-07T00:01:02.129841] [DDL-99] [I] DDL execution succeeded
[2023-04-07T00:01:05.679714] [DDL-99] [I] Executing DDL: create global temporary table sys.tmp_20230407000105679608000_ on commit preserve rows cache as select  "SNAP_ID" , "THREAD#" , "JCNT#" , "NUM" , "SIZE" , "TIME" , "MAX_TIME"  from "SYS"."_TPR_JCNTSTAT" where 1 = 0
[2023-04-07T00:01:05.683506] [DDL-99] [I] DDL execution succeeded
[2023-04-07T00:01:05.701125] [DDL-99] [I] Executing DDL: drop table sys.tmp_20230407000105679608000_ purge
[2023-04-07T00:01:05.716839] [DDL-99] [I] DDL execution succeeded
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$ ps -ef | grep tbsvr
tibero    7174     1  0 Apr06 pts/2    00:00:40 tbsvr          -t NORMAL -SVR_SID tibero
tibero    7176  7174  0 Apr06 pts/2    00:00:00 tbsvr_MGWP     -t NORMAL -SVR_SID tibero
tibero    7177  7174  0 Apr06 pts/2    00:00:00 tbsvr_FGWP000  -t NORMAL -SVR_SID tibero
tibero    7178  7174  0 Apr06 pts/2    00:01:58 tbsvr_FGWP001  -t NORMAL -SVR_SID tibero
tibero    7179  7174  0 Apr06 pts/2    00:00:00 tbsvr_PEWP000  -t NORMAL -SVR_SID tibero
tibero    7180  7174  0 Apr06 pts/2    00:00:00 tbsvr_PEWP001  -t NORMAL -SVR_SID tibero
tibero    7181  7174  0 Apr06 pts/2    00:00:00 tbsvr_PEWP002  -t NORMAL -SVR_SID tibero
tibero    7182  7174  0 Apr06 pts/2    00:00:00 tbsvr_PEWP003  -t NORMAL -SVR_SID tibero
tibero    7183  7174  0 Apr06 pts/2    00:00:00 tbsvr_PEWP004  -t NORMAL -SVR_SID tibero
tibero    7184  7174  0 Apr06 pts/2    00:00:00 tbsvr_PEWP005  -t NORMAL -SVR_SID tibero
tibero    7185  7174  0 Apr06 pts/2    00:01:12 tbsvr_AGNT     -t NORMAL -SVR_SID tibero
tibero    7186  7174  0 Apr06 pts/2    00:01:18 tbsvr_DBWR     -t NORMAL -SVR_SID tibero
tibero    7187  7174  0 Apr06 pts/2    00:00:04 tbsvr_RCWP     -t NORMAL -SVR_SID tibero
tibero   31562 24596  0 11:07 pts/3    00:00:00 grep --color=auto tbsvr
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$ ps -ef | grep tblisten
tibero    7175  7174  0 Apr06 pts/2    00:00:00 /tibero/tibero7/bin/tblistener -n 11 -t NORMAL -SVR_SID tibero
tibero   31586 24596  0 11:07 pts/3    00:00:00 grep --color=auto tblisten
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$
[tibero@T1:/]$ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL>
SQL> DESC V$SESSION;

COLUMN_NAME                              TYPE               CONSTRAINT 
---------------------------------------- ------------------ --------------------
SID                                      NUMBER
SERIAL#                                  NUMBER
AUDSID                                   NUMBER
USER#                                    NUMBER
USERNAME                                 VARCHAR(128)
IPADDR                                   VARCHAR(46)
COMMAND                                  NUMBER
STATUS                                   VARCHAR(32)
SCHEMA#                                  NUMBER
SCHEMANAME                               VARCHAR(128)
TYPE                                     VARCHAR(15)
SQL_ID                                   VARCHAR(13)
SQL_CHILD_NUMBER                         NUMBER
PREV_SQL_ID                              VARCHAR(13)
PREV_CHILD_NUMBER                        NUMBER
SQL_ET                                   NUMBER
LOGON_TIME                               DATE
STATE                                    VARCHAR(25)
WLOCK_WAIT                               VARCHAR(18)
WAIT_EVENT                               NUMBER
WAIT_TIME                                NUMBER
PGA_USED_MEM                             NUMBER
SQL_TRACE                                VARCHAR(8)
PROG_NAME                                VARCHAR(30)
CLIENT_PID                               NUMBER
PID                                      NUMBER
WTHR_ID                                  NUMBER
OS_THR_ID                                NUMBER
OSUSER                                   VARCHAR(128)
MACHINE                                  VARCHAR(64)
TERMINAL                                 VARCHAR(15)
MODULE                                   VARCHAR(64)
ACTION                                   VARCHAR(64)
CLIENT_INFO                              VARCHAR(64)
CLIENT_IDENTIFIER                        VARCHAR(64)
PDML_ENABLED                             VARCHAR(3)
PDML_STATUS                              VARCHAR(8)
PDDL_STATUS                              VARCHAR(8)
PQ_STATUS                                VARCHAR(8)
ROW_WAIT_OBJ_ID                          NUMBER
ROW_WAIT_FILE_NO                         NUMBER
ROW_WAIT_BLOCK_NO                        NUMBER
ROW_WAIT_ROW_NO                          NUMBER
CONSUMER_GROUP                           VARCHAR(32)
CONSUMED_CPU_TIME                        NUMBER

SQL> SELECT SID , USERNAME, PROGNAME FROM V$SESSION;
TBR-8026: Invalid identifier.
at line 1, column 25 of null:
SELECT SID , USERNAME, PROGNAME FROM V$SESSION
                       ^

SQL> SELECT SID , USERNAME, PROG_NAME FROM V$SESSION;

       SID
----------
USERNAME
--------------------------------------------------------------------------------
PROG_NAME
------------------------------
        89
SYS
tbsql


1 row selected.

SQL> SELECT SID , USERNAME, PROG_NAME FROM V$SESSION;

       SID
----------
USERNAME
--------------------------------------------------------------------------------
PROG_NAME
------------------------------
        89
SYS
tbsql

        90
TIBERO
tbsql


2 rows selected.

SQL>