login as: tibero
tibero@192.168.56.241's password:
Last login: Mon Apr 10 14:29:25 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]$
[tibero@T1:/home/tibero]$ cd /tibero
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$ which tbsql
/tibero/tibero7/client/bin/tbsql
[tibero@T1:/tibero]$ tbsql
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
SQL>
SQL> ED /tibero/edu1.sql
SQL> !cat /tibero/edu1.sql
SELECT COUNT(*) FROM DBA_USERS;
SELECT COUNT(*) FROM V$DATABASE;
SQL>
SQL> !ls -l /tibero/edu1.sql
-rw-r--r-- 1 tibero dba 65 Apr 11 09:54 /tibero/edu1.sql
SQL> @/tibero/edu1.sql
TBS-70004: Not connected to the server.
TBS-70004: Not connected to the server.
SQL> CONN SYS/TIBERO
Connected to Tibero.
SQL> @/tibero/edu1.sql
COUNT(*)
----------
6
1 row selected.
COUNT(*)
----------
1
1 row selected.
SQL> Q
Disconnected.
[tibero@T1:/tibero]$ ls -l
total 662064
-rwxr-x--- 1 tibero dba 815 Apr 6 14:20 CREATE_DATABASE.sql
-rw-r--r-- 1 tibero dba 65 Apr 11 09:54 edu1.sql
-rwxr-x--- 1 tibero dba 471 Apr 6 14:17 license.xml
-rw------- 1 tibero dba 19467264 Apr 7 13:45 log-t0-r0-s5.arc
-rwxr-x--- 1 tibero dba 901 Apr 6 14:24 PROFILE.txt
lrwxrwxrwx 1 tibero dba 11 Jan 17 2019 s -> /media/sf_s
drwxr-xr-x 3 tibero dba 42 Apr 7 14:01 tbdata
drwxr-xr-x 10 tibero dba 113 Apr 6 14:34 tibero7
-rwxr-x--- 1 tibero dba 658461618 Apr 6 14:17 tibero7-bin-FS02-linux64_3.10-202626-20220624131800.tar.gz
-rwxr-x--- 1 tibero dba 262 Apr 6 14:21 tibero.tip
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$ tbsql
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
SQL> conn tibero/tmax
Connected to Tibero.
SQL> @edu1
COUNT(*)
----------
6
1 row selected.
COUNT(*)
----------
1
1 row selected.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> start edu1
COUNT(*)
----------
6
1 row selected.
COUNT(*)
----------
1
1 row selected.
SQL> start /tibero/edu1.sql
COUNT(*)
----------
6
1 row selected.
COUNT(*)
----------
1
1 row selected.
SQL>
SQL>
SQL>
SQL> help
HELP
----
Displays the Help.
{H[ELP]|?} topic
where topic is
! {exclamation} % {percent} @ {at} @@{double at}
/ {slash} ACCEPT APPEND ARCHIVE LOG
CHANGE CLEAR COLUMN CONNECT
DEFINE DEL DESCRIBE DISCONNECT
EDIT EXECUTE EXIT EXPORT
HELP HISTORY HOST INPUT
LIST LOADFILE LOOP LS
PASSWORD PAUSE PING PRINT
PROMPT QUIT RESTORE RUN
SAVE SET SHOW TBDOWN
SPOOL START UNDEFINE VARIABLE
WHENEVER
SQL>
SQL>
SQL>
SQL>
SQL> help
HELP
----
Displays the Help.
{H[ELP]|?} topic
where topic is
! {exclamation} % {percent} @ {at} @@{double at}
/ {slash} ACCEPT APPEND ARCHIVE LOG
CHANGE CLEAR COLUMN CONNECT
DEFINE DEL DESCRIBE DISCONNECT
EDIT EXECUTE EXIT EXPORT
HELP HISTORY HOST INPUT
LIST LOADFILE LOOP LS
PASSWORD PAUSE PING PRINT
PROMPT QUIT RESTORE RUN
SAVE SET SHOW TBDOWN
SPOOL START UNDEFINE VARIABLE
WHENEVER
SQL>
SQL>
SQL>
SQL>
SQL> help
HELP
----
Displays the Help.
{H[ELP]|?} topic
where topic is
! {exclamation} % {percent} @ {at} @@ {double a}
/ {slash} ACCEPT APPEND ARCHIVE LOG
CHANGE CLEAR COLUMN CONNECT
DEFINE DEL DESCRIBE DISCONNECT
EDIT EXECUTE EXIT EXPORT
HELP HISTORY HOST INPUT
LIST LOADFILE LOOP LS
PASSWORD PAUSE PING PRINT
PROMPT QUIT RESTORE RUN
SAVE SET SHOW TBDOWN
SPOOL START UNDEFINE VARIABLE
WHENEVER
SQL> q
Disconnected.
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$ which tbdown
/tibero/tibero7/bin/tbdown
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$ which tbboot
/tibero/tibero7/bin/tbboot
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$
[tibero@T1:/tibero]$ tbsql
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
SQL> tbdown immediate
SQL>
SQL>
SQL> conn sys/tibero
Connected to Tibero.
SQL> tbdown immediate
DB instance was terminated.
SQL>
SQL> !tbboot
Change core dump dir to /tibero/tibero7/bin/prof.
Listener port = 8629
Tibero 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
SQL>
SQL>
SQL> CONNECT SYS/TIBERO
Connected to Tibero.
SQL> SELECT SYSDATE FROM DUAL;
SYSDATE
--------------------------------------------------------------------------------
2023/04/11
1 row selected.
SQL> SHOW ALL
PARAMETER VALUE
---------------- ---------------------------------------------------------------
AUTOCOMMIT OFF
AUTOTRACE OFF
BLOCKTERMINATOR "." (0x2E)
COLSEP " " (0x20)
CONCAT "." (0x2E)
DDLSTATS OFF
DEFINE "&" (0x26)
DESCRIBE DEPTH 10
ECHO OFF
EDITFILE ".tbedit.sql"
ESCAPE OFF
EXITCOMMIT ON
FEEDBACK 0
HEADING ON
HEADSEP "|" (0x7C)
HISTORY 50
INTERVAL 1
LINESIZE 80
LONG 80
MARKUP HTML OFF HEAD "<style type='text/css'> body {font:10pt Arial,He
lvetica,sans-serif; color:black; background:White;} p {font:10p
t Arial,Helvetica,sans-serif; color:black; background:White;} t
able,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black;
background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px
0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#33
6699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16
pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background
-color:White; border-bottom:1px solid #cccc99; margin-top:0pt;
margin-bottom:0pt; padding:0px 0px 0px 0px;} h2 {font:bold 10pt
Arial,Helvetica,Geneva,sans-serif; color:#336699; background-c
olor:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Ari
al,Helvetica,sans-serif; color:#663300; background:#ffffff; mar
gin-top:0pt; margin-bottom:0pt; vertical-align:top;}</style><ti
tle>TBSQL Report</title>" BODY "" TABLE "border='1' width='90%'
align='center' summary='Script output'" SPOOL OFF ENTMAP ON PR
EFORMAT OFF
NUMFORMAT ""
NEWPAGE 1
NUMWIDTH 10
PAGESIZE 24
PAUSE OFF
RECSEP WRAPPED
RECSEPCHAR " " (0x20)
ROWS ON
SERVEROUTPUT OFF
SQLCODE 0
SQLPROMPT "SQL> "
SQLTERMINATOR ";" (0x3B)
SUFFIX "sql"
TERMOUT ON
TIME OFF
TIMEOUT 3
TIMING OFF
TRIMOUT ON
TRIMSPOOL OFF
UNDERLINE "-" (0x2D)
VERIFY ON
WRAP ON
SQL>
