2019.02.15 / 19:11
¸®´ª½º Tibero5 ¼³Ä¡
hanulbit
Ãßõ ¼ö 164
- Tibero 5 ¼³Ä¡
¸ñÂ÷
1 ´Ù¿î·Îµå[ÆíÁý]
- https://technet.tmaxsoft.com Á¢¼Ó
- ȸ¿ø°¡ÀÔ ¹× ·Î±×ÀÎ
- ´Ù¿î·Îµå --- µ¥ÀÌÅͺ£À̽º --- Tibero Ŭ¸¯
- 'Tibero 5' ¿À¸¥ÂÊ [´Ù¿î·Îµå] Ŭ¸¯
- ÇÏ´Ü¿¡¼ Linux Ŭ¸¯
- Linux (x86) 64-bit Ŭ¸¯
- [ÀüüÆÄÀÏ ´Ù¿î·Îµå] Ŭ¸¯ÇÏ¿© ÆÄÀÏ ´Ù¿î·Îµå
- tibero5-bin-5_rel_S1419-linux64-86442-tested-opt.tar.gz (194.43 MB)
2 ´ë»ó¼¹ö È£½ºÆ®¸í È®ÀÎ[ÆíÁý]
- µ¥¸ð ¶óÀ̼±½º ¹ß±Þ½Ã ÀÔ·ÂÇÒ È£½ºÆ®¸í È®ÀÎ
[root@zetawiki ~]# hostname
zetawiki.example.com
3 µ¥¸ð¶óÀ̼±½º ¹ß±Þ[ÆíÁý]
- ¿ÞÂÊ [µ¥¸ð¶óÀ̼±½º ½Åû] Ŭ¸¯
- Á¦Ç°¸í: Tibero
- Version: 5.0
- Host Name: È£½ºÆ®¸í
- Edition: Enterprise
- ȸ»ç¸í, »ç¿ë¸ñÀû ÀÔ·Â
- [Á¦ÃâÇϱâ] Ŭ¸¯
¶óÀ̼±½º Á¤º¸°¡ ÀÔ·ÂÇÑ À̸ÞÀÏ·Î Àü´ÞµÊ
- ¸ÞÀÏÁ¦¸ñ: 'Tibero 5.0 Demo license Information'
- Expiration Date: 6 months from the date issued
÷ºÎÆÄÀÏ license.xml ´Ù¿î·Îµå
4 °èÁ¤ »ý¼º ¹× ȯ°æº¯¼ö ¼³Á¤[ÆíÁý]
- tibero °èÁ¤ »ý¼ºÇÏ°í °èÁ¤ Àüȯ
[root@zetawiki ~]# useradd tibero
[root@zetawiki ~]# su - tibero
[tibero@zetawiki ~]$
- .bashrc ÆÄÀÏ ÇÏ´Ü¿¡ ³»¿ë Ãß°¡
[tibero@zetawiki ~]$ vi .bashrc
export TB_HOME=/home/tibero/Tibero/tibero5
export TB_SID=tibero
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
[tibero@zetawiki ~]$ echo $TB_HOME
[tibero@zetawiki ~]$ source .bashrc
[tibero@zetawiki ~]$ echo $TB_HOME
/home/tibero/Tibero/tibero5
5 ¾÷·Îµå ¹× ¾ÐÃàÇØÁ¦[ÆíÁý]
- Tibero Æú´õ »ý¼º
[tibero@zetawiki ~]$ mkdir Tibero
[tibero@zetawiki ~]$ cd Tibero/
[tibero@zetawiki Tibero]$
- ¼³Ä¡ÆÄÀÏ + ¶óÀ̼±½ºÆÄÀÏ ¾÷·Îµå
[tibero@zetawiki Tibero]$ ll
total 199096
-rw-r--r--. 1 tibero tibero 483 Jun 14 22:48 license.xml
-rw-r--r--. 1 tibero tibero 203870160 Jun 14 22:46 tibero5-bin-5_rel_S1419-linux64-86442-tested-opt.tar.gz
- ¾ÐÃàÇØÁ¦
[tibero@zetawiki Tibero]$ tar xvzf tibero5-bin-5_rel_S1419-linux64-86442-tested-opt.tar.gz
... (»ý·«)
tibero5/license/oss_licenses/oss_licenses.txt
tibero5/license/oss_licenses/BSD_license.txt
tibero5/license/oss_licenses/Apache_v2.txt
- ¶óÀ̼±½º ÆÄÀÏ º¹»ç
[tibero@zetawiki Tibero]$ cp license.xml tibero5/license/
[tibero@zetawiki Tibero]$
6 TIP ÆÄÀÏ »ý¼º[ÆíÁý]
[tibero@zetawiki Tibero]$ cd tibero5/config/
[tibero@zetawiki config]$ ./gen_tip.sh
Using TB_SID "tibero"
/home/tibero/Tibero/tibero5/config/tibero.tip generated
/home/tibero/Tibero/tibero5/config/psm_commands generated
/home/tibero/Tibero/tibero5/client/config/tbdsn.tbr generated.
Running client/config/gen_esql_cfg.sh
Done.
7 NOMOUNT ¸ðµå ±âµ¿[ÆíÁý]
[tibero@zetawiki config]$ cd ../bin/
[tibero@zetawiki bin]$ tbboot nomount
Listener port = 8629
Tibero 5
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NOMOUNT mode).
8 DB Á¢¼Ó ¹× µ¥ÀÌÅͺ£À̽º »ý¼º[ÆíÁý]
[tibero@zetawiki bin]$ tbsql sys/tibero
tbSQL 5
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> create database "tibero"
user sys identified by tibero
maxinstances 8
maxdatafiles 100
character set MSWIN949
logfile group 1 'log001.log'
size 100M,
group 2 'log002.log'
size 100M,
group 3 'log003.log'
size 100M
maxloggroups 255
maxlogmembers 8
noarchivelog
datafile 'system001.dtf'
size 100M
autoextend on next 100M
maxsize unlimited
default temporary tablespace TEMP
tempfile 'temp001.dtf'
size 100M
autoextend on next 100M
maxsize unlimited
extent management local autoallocate
undo tablespace UNDO
datafile 'undo001.dtf'
size 100M
autoextend on next 100M
maxsize unlimited
extent management local autoallocate;
Database created.
SQL> quit
Disconnected.
[tibero@zetawiki bin]$
- ¡æ SQL ¹® ºÙ¿©³ÖÀ» ¶§ ¹º°¡ ¼ýÀÚ¿ÀÌ ÂïÈ÷´Âµ¥... Çà¹øÈ£°¡ ÇÑÁÙ·Î ¹¶Ãļ ³ª¿À´Â °Í °°À½... µ¿ÀÛ¿¡´Â ¹®Á¦ ¾øÀ¸´Ï ¹«½Ã
9 NORMAL ¸ðµå ±âµ¿[ÆíÁý]
[tibero@zetawiki bin]$ tbboot
Listener port = 8629
Tibero 5
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
10 system.sh ½ÇÇà[ÆíÁý]
- system.sh¸¦ ½ÇÇàÇϸé...
- ÇöÀç µð·ºÅ͸®¿¡ ÀÖ´Â SQL ÆÄÀÏÀÌ ¼öÇàµÇ¸ç role, System user, view, package µîÀÌ »ý¼ºµÊ
- SYS ¹× SYSCAT °èÁ¤¿¡ ´ëÇÑ ±âº» Æнº¿öµå´Â °¢°¢ tibero, syscatÀÓ... ÀÌÈÄ´Â Y ½Å°ø
[tibero@zetawiki bin]$ cd ../scripts/
[tibero@zetawiki scripts]$ ./system.sh
Enter SYS password:
tibero
Enter SYSCAT password:
syscat
Creating the role DBA...
Create default system users & roles?(Y/N):
Y
Creating system users & roles...
Creating virtual tables(1)...
Creating virtual tables(2)...
Granting public access to _VT_DUAL...
Creating the system generated sequences...
Creating internal dynamic performance views...
Creating outline table...
Creating system packages:
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_standard.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_output.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_lob.sql...
... (»ý·«)
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_seaf.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_debug_jdwp.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_expression.sql...
Creating packages for sql:
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_types.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_sql.sql...
Creating public synonyms for system packages...
Creating auxiliary tables used in static views...
Creating system tables related to job...
Create system tables related to profile?(Y/N):
Y
Creating system tables related to profile...
Creating static views...
Creating static view descriptions...
Creating packages for statistics:
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_sys_util.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_stats_internal.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_stats.sql...
Register dbms_stats job to Job Scheduler?(Y/N):
Y
Registering dbms_stats job to Job Scheduler...
Creating packages for log errors:
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_errlog.sql...
Creating packages for mview:
Running /home/tibero/Tibero/tibero5/scripts/rewrite_table.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_mview_util.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_mview.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_mview_refresh_util.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_redefinition_stats.sql...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_redefinition.sql...
Creating packages for text:
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_text.sql...
Creating remaining public synonyms for system packages...
Running /home/tibero/Tibero/tibero5/scripts/iparam_desc_gen.sql...
Running /home/tibero/Tibero/tibero5/scripts/trace_event_desc_gen.sql...
Creating dynamic performance views...
Creating dynamic performance view descriptions...
Check APM status..
Stop APM
Create APM tables?(Y/N):
Y
Dropping tables used in APM...
Creating auxiliary tables used in APM...
Replenish APM Tables if Updates Exist
Running /home/tibero/Tibero/tibero5/scripts/apm_replenish.sql...
Creating packages for APM...
Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_apm.sql...
Start APM
Creating spatial meta tables and views ...
Creating internal system tables...
Done.
For details, check /home/tibero/Tibero/tibero5/instance/tibero/log/system_init.log.
11 ÇÁ·Î¼¼½º È®ÀÎ[ÆíÁý]
[tibero@zetawiki scripts]$ ps -ef | grep tbsvr
tibero 22139 22138 0 10:05 pts/1 00:00:00 tbsvr -n 4 -t NORMAL -SVR_SID tibero
tibero 22140 22139 0 10:05 pts/1 00:00:00 tbsvr_WT001 -n 4 -t NORMAL -SVR_SID tibero
tibero 22141 22139 1 10:05 pts/1 00:00:05 tbsvr_WT002 -n 4 -t NORMAL -SVR_SID tibero
tibero 22142 22139 0 10:05 pts/1 00:00:00 tbsvr_WT003 -n 4 -t NORMAL -SVR_SID tibero
tibero 22143 22139 0 10:05 pts/1 00:00:00 tbsvr_SEQW -n 4 -t NORMAL -SVR_SID tibero
tibero 22144 22139 0 10:05 pts/1 00:00:00 tbsvr_LOGW -n 4 -t NORMAL -SVR_SID tibero
tibero 22145 22139 0 10:05 pts/1 00:00:00 tbsvr_LOGA -n 4 -t NORMAL -SVR_SID tibero
tibero 22146 22139 0 10:05 pts/1 00:00:00 tbsvr_CKPT -n 4 -t NORMAL -SVR_SID tibero
tibero 22147 22139 0 10:05 pts/1 00:00:00 tbsvr_BLKW000 -n 4 -t NORMAL -SVR_SID tibero
tibero 22148 22139 0 10:05 pts/1 00:00:00 tbsvr_BLKW001 -n 4 -t NORMAL -SVR_SID tibero
tibero 22149 22139 0 10:05 pts/1 00:00:00 tbsvr_BLKW002 -n 4 -t NORMAL -SVR_SID tibero
tibero 22150 22139 0 10:05 pts/1 00:00:00 tbsvr_BLKW003 -n 4 -t NORMAL -SVR_SID tibero
tibero 23239 20275 0 10:12 pts/1 00:00:00 grep --color=auto tbsvr
12 (Optional) ¸®´ª½º ÄÚ¾î´ýÇÁ ºñÈ°¼ºÈ[ÆíÁý]
- ¸®´ª½º ÄÚ¾î´ýÇÁ ºñÈ°¼ºÈ ¹®¼¸¦ Âü°íÇϽʽÿÀ.
- ÄÚ¾î´ýÇÁ ±â´ÉÀº ½Ã½ºÅÛ ¼º´ÉÀ» ÀúÇϽÃų ¼ö ÀÖ¾î ±ÇÀåµÇÁö ¾ÊÀ½
13 ¼³Á¤[ÆíÁý]
- ÀÏ¹Ý ¼³Á¤ÀÇ ±âº» °ü¸® (shared memory Å©±â, ÃÖ´ë ¼¼¼Ç Ä«¿îÆ®, DB À̸§, ¸®½º³Ê Æ÷Æ® µî)
- À¯´Ð½º °è¿: $TB_HOME/config/$TB_SID.tip
- À©µµ¿ì °è¿: %TB_HOME%\config\%TB_SID%.tip
- Ŭ¶óÀ̾ðÆ® Á¢¼Ó Á¤º¸ÀÇ ±âº» °ü¸®
- À¯´Ð½º °è¿: $TB_HOME/client/config/tbdsn.tbr
- À©µµ¿ì °è¿: %TB_HOME%\client\config\tbdsn.tbr
14 °°ÀÌ º¸±â[ÆíÁý]
15 Âü°í[ÆíÁý]