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>
더디가도 함께가자