tibero6 ½Ì±Û ¼³Ä¡ (linux)
¢º ¹öÀü : linux centos7 - 64bit
¢º DB : tibero 6
** ¼³Ä¡ Àü Áغñ»çÇ×
- Tibero¸¦ ¼³Ä¡Çϱâ À§Çؼ´Â °¢ Ç÷§Æûº°·Î ¾à°£ÀÇ Â÷ÀÌ°¡ ÀÖÁö¸¸ ÃÖ¼Ò 2GB ÀÌ»óÀÇ Çϵåµð½ºÅ© ¿©À¯°ø°£ÀÌ ÇÊ¿äÇÕ´Ï´Ù.
- Tibero¸¦ ¼³Ä¡ÇÏ°í ³ª¼ µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÒ ¶§ ÃÖ¼Ò·Î ÇÊ¿äÇÑ Çϵåµð½ºÅ© °ø°£À» ÀǹÌÇÕ´Ï´Ù.
1) OS CPU
[root@yeojin java]# cat /proc/cpuinfo
model name : Intel(R) Core(TM) i5-6200U CPU @ 2.30GHz
2) physical RAM
[root@yeojin java]# free -h
total used free shared buff/cache available
Mem: 7.6G 563M 4.4G 10M 2.7G 6.7G
Swap: 3.7G 0B 3.7G
3) ÆÐÅ°Áö È®ÀÎ
[root@yeojin java]# rpm -qa | grep kernel
kernel-tools-3.10.0-514.el7.x86_64
kernel-tools-libs-3.10.0-514.el7.x86_64
abrt-addon-kerneloops-2.1.11-45.el7.centos.x86_64
kernel-3.10.0-514.el7.x86_64
4) JDK version
[root@yeojin java]# java -version
openjdk version "1.8.0_102"
OpenJDK Runtime Environment (build 1.8.0_102-b14)
OpenJDK 64-Bit Server VM (build 25.102-b14, mixed mode)
5) OS
[root@yeojin java]# sysctl -p
kernel.sem = 10000 32000 10000 10000
kernel.shmmax = 4294967296
kernel.shmmni = 4096
fs.file-max = 6815744
6) OS version
[root@yeojin java]# uname -a
Linux yeojin 3.10.0-514.el7.x86_64 #1 SMP Tue Nov 22 16:42:41 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
7) memory
[root@yeojin java]# top //(7ÀÚ¸®ºÎÅÍ G)
mem : 7994292(7ÀÚ¸®) : 8G ¿¹Ãø
8) disk
¡Ø ½ÇÁ¦ ¿î¿µ ȯ°æ¿¡¼´Â tibero¼³Ä¡ ½Ã ¹ÙÀ̳ʸ®°¡ ÆÐÄ¡ µÉ ¼ö Àֱ⠶§¹®¿¡ 30GÀÌ»ó(30G-50G) Àâ°í ¼³Ä¡ÇÕ´Ï´Ù.
Ƽº£·Î µð½ºÅ© ¹ÙÀ̳ʸ® º¼·ýÀ» ³ô°Ô Àâ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
[root@yeojin java]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 19G 4.5G 13G 26% /
devtmpfs 3.8G 0 3.8G 0% /dev
tmpfs 3.9G 96K 3.9G 1% /dev/shm
tmpfs 3.9G 9.1M 3.9G 1% /run
tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
/dev/sda3 14G 414M 13G 4% /home
/dev/sda1 315M 138M 161M 47% /boot
tmpfs 781M 0 781M 0% /run/user/0
tmpfs 781M 28K 781M 1% /run/user/1000
1. java ¹öÀü È®ÀÎ (Tibero¸¦ ¼³Ä¡Çϱâ Àü¿¡ JDK 1.5.17 ÀÌ»óÀÌ ¹Ýµå½Ã ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.)
[root@localhost ~]# java -version
** java°¡ ¾øÀ» ½Ã ¼³Ä¡
1) [root@localhost ~]# yum install -y java-1.8.0-openjdk-devel
2) http://www.oracle.com/technetwork/java/javase/downloads/index.html ´Ù¿î·Îµå
¨ç ÆÄÀÏ ³Ö±â (jdk-6u43-linux-x64.bin)
[root@yeojin java]# cd /usr/java
[root@yeojin java]# ./jdk-6u43-linux-x64.bin
¨è ȯ°æ¼³Á¤
[root@yeojin java]# vi /etc/profile // ¸Ç ¹Ø¿¡ Ãß°¡
export JAVA_HOME="/usr/java/jdk1.6.0_43"
export PATH="JAVA_HOME/bin:$PATH"
export CLASSPATH="$JAVA_HOME/lib:$CLASSPATH"
[root@yeojin java] . /etc/profile
¨é java ¼³Ä¡ È®ÀÎ
[root@yeojin java] java -version
openjdk version "1.8.0_102"
OpenJDK Runtime Environment (build 1.8.0_102-b14)
OpenJDK 64-Bit Server VM (build 25.102-b14, mixed mode)
2. ¿î¿µÃ¼Á¦º° ÆÐÅ°Áö ¼³Ä¡
[root@localhost ~]# yum install -y gcc gcc-c++ libgcc libstdc++ libstdc++-devel compat-libstdc++ libaio libaio-devel
3. ¿î¿µÃ¼Á¦ º° Ä¿³Î ÆĶó¹ÌÅÍ ¼³Á¤ // ¸Ç ¹Ø¿¡ Ãß°¡
[root@localhost ~]# vi /etc/sysctl.conf // ¿©·¯ ¾îÇø®ÄÉÀ̼ÇÀ» Á¦¾îÇÏ´Â ¿ªÇÒ (ÀÚ¿øÀÌ ÇÑÂÊÀ¸·Î Á¡À¯ÇÏÁö ¾Ê°Ô Á¶Á¤)
kernel.sem = 10000 32000 10000 10000 // semmsl, semmns, semopm, semmni
kernel.shmmax = 1073741824 // ÇÏµå ¸Þ¸ð¸®ÀÇ Àý¹Ý (ex. Çϵå¸Þ¸ð¸® : 20GB, 10*1024*1024*1024·Î byte ÀÔ·Â)
kernel.shmmni = 4096
fs.file-max = 6815744
[root@localhost ~]# sysctl -p // Àû¿ë È®ÀÎ
kernel.sem = 10000 32000 10000 10000
kernel.shmmax = 2147483648
kernel.shmmni = 4096
fs.file-max = 6815744
4. ¿î¿µÃ¼Á¦º° shell limits ¼³Á¤ // ¸Ç ¹Ø¿¡ Ãß°¡
[root@localhost ~]# vi /etc/security/limits.conf
tibero soft nofile 1024
tibero hard nofile 65536
tibero soft nproc 2047
tibero hard nproc 16384
¡Ø ±âŸ È®ÀλçÇ×
(1) È£½ºÆ®¸í È®ÀÎ - ¶óÀ̼±½º È£½ºÆ®¸í°ú ÀÏÄ¡
[root@localhost ~]# uname -a
Linux localhost.localdomain 3.10.0-514.el7.x86_64 #1 SMP Tue Nov 22 16:42:41 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
(2) Æ÷Æ®¹øÈ£ È®ÀÎ - ±âº»°ª : 8629 // Æ÷Æ® »ç¿ë ¿©ºÎ üũ
[tibero@localhost slog]$ netstat -na | grep 8629
tcp 0 0 0.0.0.0:8629 0.0.0.0:* LISTEN
[tibero@localhost slog]$ netstat -na | grep 8888 // ¾Æ¹«°Íµµ ¾È³ª¿À¸é ÀÌ Æ÷Æ®¸¦ ¾²Áö ¾Ê´Â °ÍÀ¸·Î È®ÀÎ
(3) localhost ¼³Á¤ È®ÀÎ
[root@localhost ~]# ping localhost
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.075 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.042 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.067 ms
[root@localhost ~]# vi /etc/hosts // Á¦´ë·Î ¼³Á¤µÇÁö ¾Ê¾Ò´Ù¸é ÆÄÀÏ ¼öÁ¤ or ±ÇÇÑ È®ÀÎ
5. ±×·ì/»ç¿ëÀÚ °èÁ¤ Ãß°¡¿Í ±ÇÇÑ ¼³Á¤
[root@localhost ~]# groupadd dba
[root@localhost ~]# useradd -g dba tibero // # pwd : /home/tibero
[root@localhost ~]# passwd tibero
6. ÆÄÀÏ ¿Å±â°í ¹ÙÀ̳ʸ®ÆÄÀÏ º¹»çÇϱâ
1) winSCP·Î ¾ÐÃàÆÄÀÏ À̵¿ ÈÄ ±ÇÇÑ ¼öÁ¤
- tibero6-bin-FS06-linux64-147777-opt-20171010111045.tar.gz // Ƽº£·Î ¼³Ä¡ÆÄÀÏ
- license.xml // ¶óÀ̼¾½º ÆÄÀÏ (È£½ºÆ®¸í ÀÏÄ¡)
[root@localhost home]# chmod -R 755 tibero
[root@localhost home]# chown -R tibero:dba tibero
2) ¾ÐÃà Ǭ ÈÄ ¶óÀ̼¾½º º¹»ç
[root@localhost home]# su - tibero // # pwd : /home/tibero
[tibero@localhost ~]$ tar -zxvf tibero6-bin-FS06-linux64-147777-opt-20171010111045.tar.gz
[tibero@localhost ~]$ ls // tibero6 Æú´õ »ý¼º
[tibero@localhost ~]$ cp license.xml tibero6/license/.
7. .bash_profile ¼öÁ¤
[tibero@localhost ~]$ vi .bash_profile
### Tibero RDBMS 6 ENV ###
export TB_HOME=/home/tibero/tibero6
export TB_SID=tibero
export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH
### Tibero ALIAS ###
alias tbhome='cd $TB_HOME'
alias tbbin='cd $TB_HOME/bin'
alias tblog='cd $TB_HOME/instance/$TB_SID/log'
alias tbcfg='cd $TB_HOME/config'
alias tbcfgv='vi $TB_HOME/config/$TB_SID.tip'
alias tbcli='cd ${TB_HOME}/client/config'
alias tbcliv='vi ${TB_HOME}/client/config/tbdsn.tbr'
#alias tbcliv='vi ${TB_HOME}/client/config/tbnet_alias.tbr'
#alias tbdata='cd $TB_HOME/tbdata'
alias tbi='cd ~/tbinary'
#alias clean='tbdown clean'
#alias dba='tbsql sys/tibero'
alias tm='cd ~/tbinary/monitor;monitor;cd -'
[tibero@localhost ~]$ . .bash_profile // .bash_profile Àû¿ë
[tibero@localhost ~]$ echo $TB_HOME // Àû¿ë È®ÀÎ : /home/tibero/tibero6
8. DB ȯ°æÆÄÀÏ ¼öÁ¤
1) TB_SID.tip (ȯ°æÆÄÀÏ)°ú tbdsn.tbr, psm_commands ÆÄÀÏ »ý¼ºÇϱâ
[tibero@localhost ~]$ cd $TB_HOME/config
[tibero@localhost config]$ ./gen_tip.sh // sh ÆÄÀÏ ½ÇÇà
Using TB_SID "tibero"
/home/tibero/Tibero/tibero6/config/tibero.tip generated
/home/tibero/Tibero/tibero6/config/psm_commands generated
/home/tibero/Tibero/tibero6/client/config/tbdsn.tbr generated.
Running client/config/gen_esql_cfg.sh
Done.
2) TB_SID.tip, tbdsn.tbr ¼öÁ¤
[tibero@localhost config]$ vi tibero.tip // TB_SID.tip
DB_NAME=tibero
LISTENER_PORT=8629
CONTROL_FILES="/home/tibero/tibero6/database/tibero/c1.ctl", "/home/tibero/tbdata/c2.ctl"
#CERTIFICATE_FILE="/home/tibero/tibero6/config/svr_wallet/tibero.crt"
#PRIVKEY_FILE="/home/tibero/tibero6/config/svr_wallet/tibero.key"
#WALLET_FILE="/home/tibero/tibero6/config/svr_wallet/WALLET"
#ILOG_MAP="/home/tibero/tibero6/config/ilog.map"
DB_CREATE_FILE_DEST="/home/tibero/tbdata"
LOG_ARCHIVE_DEST="/home/tibero/tb_arch" // archive log °æ·Î
MAX_SESSION_COUNT=20
TOTAL_SHM_SIZE=2G
MEMORY_TARGET=3G
** DB_NAME º¯°æ, LISTENER_PORT º¯°æ, CONTROL_FILES Ãß°¡, ¾ÆÄ«ÀÌºê °æ·Î Ãß°¡, DB ÆÄÀÏ °æ·Î Ãß°¡,
MAX_SESSION_COUNT, TOTAL_SHM_SIZE, MEMORY_TARGET ¼öÁ¤ ½Ã TB_SID.tip ¼öÁ¤
[tibero@localhost config]$ cd ..
[tibero@localhost tibero6]$ cd client/config
[tibero@localhost config]$ vi tbdsn.tbr
tibero=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=tibero)
)
)
** DB_NAME º¯°æ, PORT º¯°æ ½Ã tbdsn.tbr ¼öÁ¤ // Á¢¼Ó Á¤º¸¿Í °ü·ÃµÈ °ÍµéÀ» ¼³Á¤ (= oracle : tnsname.ora)
9. tibero ¼¹ö nomount ¸ðµå·Î ±âµ¿
[tibero@localhost config]$ tbboot nomount
Change core dump dir to /home/tibero/tibero6/bin/prof.
Listener port = 8629
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NOMOUNT mode).
10. µ¥ÀÌÅͺ£À̽º »ý¼º
[tibero@localhost config]$ cd /home/tibero
[tibero@localhost ~]$ mkdir work // DB »ý¼º SQLÀ» ÀúÀåÇÒ Æú´õ
[tibero@localhost ~]$ cd work
[tibero@localhost work]$ vi cre_db.sql
create database "tibero" // À̸§À» ÀûÁö ¾ÊÀ¸¸é "TB_SID"À̸§À¸·Î DB »ý¼º
user sys identified by tibero
maxinstances 8
maxdatafiles 512
character set MSWIN949 // óÀ½ µî·ÏÇÏ¸é º¯°æ ºÒ°¡, º¯°æ ½Ã Ƽº£·Î À缳ġ
national character set UTF16
logfile
group 0 ('redo01.log','redo02.log') size 300M,
group 1 ('redo11.log','redo12.log') size 300M,
group 2 ('redo21.log','redo22.log') size 300M
maxloggroups 255
maxlogmembers 8
noarchivelog
datafile 'system001.dtf' size 2G
autoextend on next 100M maxsize unlimited
default temporary tablespace TEMP
tempfile 'temp001.dtf' size 2G
autoextend on next 100M maxsize unlimited
extent management local autoallocate
undo tablespace UNDO
datafile 'undo001.dtf' size 2G
autoextend on next 100M maxsize unlimited
extent management local autoallocate;
** ¨ç Æ®·£Àè¼Ç ¾çÀÌ ¸¹´Ù¸é redo size¸¦ ´ÃÀδÙ.
¨è ´ë·®ÀÇ µ¥ÀÌÅÍ ÀÛ¾÷À» Á¤·ÄÇϱâ À§Çؼ± temp size¸¦ ´ÃÀδÙ.
¨é ´ë·®ÀÇ µ¥ÀÌÅ͸¦ insert, update, delete (DML) ÀÛ¾÷À» ÇÑ´Ù¸é undo size¸¦ ´ÃÀδÙ.
11. sys »ç¿ëÀÚ·Î Á¢¼Ó ÈÄ DB »ý¼º
[tibero@localhost work]$ tbsql sys/tibero
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> @/home/tibero/work/cre_db.sql
Database created. // DB »ý¼º ÈÄ ÀÚµ¿À¸·Î DB°¡ ³»·Á°¨
SQL> exit
Disconnected.
12. tibero DB Àç±âµ¿
[tibero@localhost work]$ tbboot
Change core dump dir to /home/tibero6/tibero6/bin/prof.
Listener port = 25010
Tibero 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).
13. SQL ÆÄÀÏ ¼öÇà // role, System user, view, package µîÀÌ »ý¼º
[tibero@localhost work]$ sh /home/tibero/tibero6/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 package specifications:
Running /home/tibero/Tibero/tibero6/scripts/pkg/pkg_standard.sql...
Running /home/tibero/Tibero/tibero6/scripts/pkg/pkg_dbms_output.sql...
Running /home/tibero/Tibero/tibero6/scripts/pkg/pkg_dbms_lob.sql...
Running /home/tibero/Tibero/tibero6/scripts/pkg/pkg_dbms_utility.sql...
......Áß°£ »ý·«......
Creating spatial meta tables and views ...
Creating internal system jobs...
Creating internal system notice queue ...
Done.
For details, check /home/tibero6/tibero6/instance/tibero/log/system
** log È®ÀÎÇϱâ (tibero 5¹öÀü : tail -f /home/tibero/tibero5/instance/$TB_SID/log/tblog/trace.log)
[tibero@localhost work]$ tblog // pwd : /home/tibero/tibero6/instance/$TB_SID/log
[tibero@localhost log]$ cd slog
[tibero@localhost slog]$ tail -f sys.log
14. tibero ÇÁ·Î¼¼½º È®ÀÎ
[tibero@localhost slog]$ ps -ef | grep tbsvr
tibero 2328 1 0 14:56 pts/0 00:00:07 tbsvr -t nomount -SVR_SID tibero
tibero 2330 2328 0 14:56 pts/0 00:00:00 tbsvr_TBMP -t nomount -SVR_SID tibero
tibero 2331 2328 0 14:56 pts/0 00:00:00 tbsvr_WP000 -t nomount -SVR_SID tibero
tibero 2332 2328 0 14:56 pts/0 00:00:00 tbsvr_WP001 -t nomount -SVR_SID tibero
tibero 2333 2328 0 14:56 pts/0 00:00:00 tbsvr_PEP000 -t nomount -SVR_SID tibero
tibero 2334 2328 0 14:56 pts/0 00:00:00 tbsvr_PEP001 -t nomount -SVR_SID tibero
tibero 2335 2328 0 14:56 pts/0 00:00:00 tbsvr_PEP002 -t nomount -SVR_SID tibero
tibero 2336 2328 0 14:56 pts/0 00:00:00 tbsvr_PEP003 -t nomount -SVR_SID tibero
tibero 2337 2328 0 14:56 pts/0 00:00:00 tbsvr_DBWR -t nomount -SVR_SID tibero
tibero 2338 2328 0 14:56 pts/0 00:00:00 tbsvr_RECO -t nomount -SVR_SID tibero
tibero 2544 2151 0 15:33 pts/0 00:00:00 grep --color=auto tbsvr
15. archive log ¸ðµå º¯°æ
[tibero@localhost slog]$ tbdown
[tibero@localhost slog]$ tbboot mount
[tibero@localhost slog]$ tbsql sys/tibero
SQL> alter database archivelog;
SQL> exit
[tibero@localhost slog]$ tbdown
[tibero@localhost slog]$ tbboot
[tibero@localhost slog]$ tbsql sys/tibero
SQL> archive log list;
SQL> select log_mod from v$database;
SQL> alter system switch logfile; // ·Î±× ÆÄÀÏ·Î ½ºÀ§Äª ¼öÇà
<ÀÚÁÖ ½Ç¼öÇÏ´Â ºÎºÐ>
1. TB_SID.tip ¿ÀŸ
2. .bash_profile ¿ÀŸ
3. system.sh ÀÇ syscat Æнº¿öµå ¿À·ù // :v$·Î ¸¸µé¾îÁö´Â °ÍÀº sysÂÊÀÌ´Ù.
SQL> select * from v$database; // µÇ´ÂÁö È®ÀÎ