목차 1. TAC 구성준비사항 TAC 구성순서 VirtualBox 으로 CentOS 설치 VirtualBox 에서 TAC 구성

Similar documents
개발및운영 Tibero DB Link (Tibero To Oracle) - Local 방식

개발및운영 Tibero Perl 연동

[JEUS 7] eclipse plug-in 연동 1. 개요 Eclipse 와 JEUS 7 연동시필요한 plug-in 제공및환경설정에관한가이드제공하여 Eclipse 에서 JEUS 7 기동및 종료테스트할수있는방법을기술하였습니다. 2. Plug-in 설치 2.1 [Step

설치및환경설정 Tibero tbprobe 사용법과원격지포트체크

윈백및업그레이드 Tibero Flashback 가이드

목차 1. 노드매니저종류 Java Type SSH Type 노드설정파일및로깅 nodes.xml jeusnm.properties <servername>.properties...

Linux 권장커널파라미터 1. 커널파라미터별설명및설정방법 1.1 nofile ( max number of open files ) 설명 : 지원되는열린파일수를지정합니다. 기본설정이보통대부분의응용프로그램에대해충분합니다. 이매개 변수에설정된값이너무낮으면파일열기오류, 메모리

튜닝및모니터링 OS 별 TCP Recommend Parameter for WebtoB/JEUS

설치및환경설정 JEUS Thread State Notify 설정

목차 1. Tibero 4 설치개요 Install 전 Check 사항 H/W 요구사항 Tibero 4 설치 Tibero 설치폴더생성 Tibero 바이너리압축해제 $T

설치및홖경설정 Tibero 4 SP1 TAC 설치 - Windows 홖경

목차 1. 개요 개요 연동테스트홖경 PowerBuilder Connection Tibero ODBC Driver 설정 PowerBuilder Connection 설정 Tiber

목차 1. TABLE MIGRATOR 란? TABLE MIGRATOR 홖경설정 TABLE MIGRATOR 바이너리 Shell 설정 Migrator.Properterties 파일설정 TAB

SSL 접속테스트 본문서에서 WebtoB 가설치된디렉토리는 [WEBTOBDIR] 로표기하겠습니다.. 윈도우계열과리눅스 / 유닉스계열모두명령은동일하므로윈도우를기준으로설명하도록하겠습니다. 1. WebtoB 설정 1.1 Test 용인증서생성 SSL 접속테스트를위해 Webto

개요오라클과티베로에서 JDBC 를통해접속한세션을구분할수있도록 JDBC 접속시 ConnectionProperties 를통해구분자를넣어줄수있다. 하나의 Node 에다수의 WAS 가있을경우 DB 에서 Session Kill 등의동작수행시원하는 Session 을선택할수있다.

목차 JEUS JNLP Client Sample 가이드 JNLP 란 JNLP의이점 TEST TEST 환경 TEST Sample sample application 셋팅 (ser

튜닝및모니터링 Tibero EVENT 가이드

SSL(Secure Socket Layer) 과 TLS(Transport Layer Security) 개요 전자상거래가활발해지면서웹보안이매우중요해지고있으며, 최근정보통신망법의개정으로아무리소상공인이라 도홈페이지운영시개인정보를취급하고있다면아래와같은내용을조치하도록되어있습니다

튜닝및모니터링 HP JVM 튜닝옵션

Microsoft PowerPoint - Linux_10gRAC_3Node

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O

Copyright 2004 Sun Microsystems, Inc Network Circle, Santa Clara, CA U.S.A..,,. Sun. Sun. Berkeley BSD. UNIX X/Open Company, Ltd.. Sun, Su

목차 1. 웹서비스의예 테스트환경설치 설치전고려사항 설치할공간확보 테스트환경구축 설치파일준비 설치 Windows에서의설치 Linux 에서

목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate

본문서는 초급자들을 대상으로 최대한 쉽게 작성하였습니다. 본문서에서는 설치방법만 기술했으며 자세한 설정방법은 검색을 통하시기 바랍니다. 1. 설치개요 워드프레스는 블로그 형태의 홈페이지를 빠르게 만들수 있게 해 주는 프로그램입니다. 다양한 기능을 하는 플러그인과 디자인

Simplify your Job Automatic Storage Management DB TSC

단계

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r

.

휠세미나3 ver0.4

목 차

R50_51_kor_ch1

개발및운영 Eclipse 를이용한 ANT 활용방법

Solaris Express Developer Edition

Oracle Database 11g R2 Installation Guide for OEL5(x86) Writer : 이경호

다음 사항을 꼭 확인하세요! 도움말 안내 - 본 도움말에는 iodd2511 조작방법 및 활용법이 적혀 있습니다. - 본 제품 사용 전에 안전을 위한 주의사항 을 반드시 숙지하십시오. - 문제가 발생하면 문제해결 을 참조하십시오. 중요한 Data 는 항상 백업 하십시오.

목차 JEUS EJB Session Bean가이드 stateful session bean stateful sample 가이드 sample source 결과확인 http session에

62

Tibero

오라클 데이터베이스 10g 핵심 요약 노트

.

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper

슬라이드 1

PowerPoint 프레젠테이션

PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (

Oracle Regular Expression

Getting Started Guide

단계

Mango220 Android How to compile and Transfer image to Target

Microsoft Word - ntasFrameBuilderInstallGuide2.5.doc

Tablespace On-Offline 테이블스페이스 온라인/오프라인

Oracle Database 10g: Self-Managing Database DB TSC

Tibero

Sun Java System Messaging Server 63 64

ÃÖÁ¾PDF¿ë

ODS-FM1

목차 1. 제품 소개 특징 개요 Function table 기능 소개 Copy Compare Copy & Compare Erase

APOGEE Insight_KR_Base_3P11

Advanced Oracle Document Enterprise Manager Cloud Control 12c R1( ) [OMS Part] Author: Hyun-Ho, Jung Site: Job: Oracle

: Symantec Backup Exec System Recovery 8:

PowerPoint 프레젠테이션

untitled

Tibero

Microsoft Word - AnyLink Introduction v3.2.3.doc

Tibero

슬라이드 1

CD-RW_Advanced.PDF

FY2005 LIG

USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl C

28 THE ASIAN JOURNAL OF TEX [2] ko.tex [5]

PowerPoint 프레젠테이션

Remote UI Guide

Splentec V-WORM Quick Installation Guide Version: 1.0 Contact Information 올리브텍 주소 : 경기도성남시분당구구미로 11 ( 포인트타운 701호 ) URL: E-M

Tmax

Chapter 1

PowerChute Personal Edition v3.1.0 에이전트 사용 설명서

2012-민간네트워크-05_중국

Microsoft Word - 10g RAC on Win2k.doc

PowerPoint 프레젠테이션

세미나(장애와복구-수강생용).ppt

문서 제목

목차 1. 보안지갑 Wallet) Data 암호화 컬럼암호화 Column Encryption) 테이블스페이스암호화 Tablespace Encryption) 암호화 Package DBMS

chapter1,2.doc

MySQL-Ch10

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including any operat

슬라이드 1

1217 WebTrafMon II

기술교육 SSL 설정및변환방법

Assign an IP Address and Access the Video Stream - Installation Guide

untitled

ENT5_ora11g_R2_ hwp

Install stm32cubemx and st-link utility

Copyright 0, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT RIGHTS Programs, software, databases, and related

Oracle Database 11g R2 Installation Guide for RHEL5(x86) Writer : 이경호

Advanced Product Service

소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를 제공합니다. 제품은 계속 업데이트되므로, 이 설명서의 이미지 및 텍스트는 사용자가 보유 중인 TeraStation 에 표시 된 이미지 및 텍스트와 약간 다를 수

Orcad Capture 9.x

H_AR_ P

untitled

PowerPoint Presentation

Transcription:

설치및환경설정 VirtualBox TAC 구성가이드 2015. 08. 04

목차 1. TAC 구성준비사항... 3 2. TAC 구성순서... 3 2.1 VirtualBox 으로 CentOS 설치... 3 2.2 VirtualBox 에서 TAC 구성... 40 2

1. TAC 구성준비사항 1. CentOS-5.9 64bit 2. Tibero 5 SP1 FS01 Linux 64bit Binary 3. VirtualBox 5.0 2. TAC 구성순서 2.1 VirtualBox 으로 CentOS 설치 1. VirtualBox 5.0 를설치합니다. 2. 아래옵션을선택합니다. 이름 : tac1 종류 : Linux 버전 : Linux 2.6 / 3.x / 4.x (64-bit) 메모리 : 2048 MB 3

3. 아래옵션을선택합니다. 파일크기 : 20 GB Hard Disk File type : VDI Storage on physical hard disk : 동적할당 4. 생성한 tac1 가상화머신을선택후설정화면을선택합니다. 4

5. 설정옵션을변경합니다. 시스템 플로피디스크해제오디오 오디오사용하기해제네트워크 어댑터 1 ( 호스트전용어댑터 ), 어댑터 2 ( 내부네트워크 ) USB USB 컨트롤러사용하기해제 5

6. 저장소 광학드라이브에서 CentOS-5.9-x86_64-bin-DVD-1of2.iso 파일을선택합니다. 6

7. tac1 가상머신을시작합니다. 8. ENTER 버튼을누릅니다. 7

9. CD Media test 는 Skip 합니다. 10. Next 를누릅니다. 11. 언어는 English 으로선택합니다. 8

12. System keyboard 는 English 으로선택합니다. 13. Create custom layout. 을선택합니다. 9

14. Device Layout 은아래와같이설정합니다. Device Size (MB) Type /boot 100 MB Ext3 /tibero 10240 MB Ext3 swap 2048 MB Swap / 8087 MB Ext3 10

15. Next 를선택합니다. 16. Network Device 를설정합니다. eth0 Host-Only Network 는 Windows cmd 에서 VirtualBox Host-Only Network IP Address 를확인한후같은 대역대로설정합니다. Device IP Gateway eth0 192.168.XX.XX/24 192.168.56.XX eth1 10.10.10.XX/24-11

17. Asia/Seoul 을선택합니다. 18. root 패스워드기입후 Next 를선택합니다. 12

19. Software management 에서 Customize now 를선택합니다. 20. 아래와같이선택또는해체를합니다. 13

14

15

21. CentOS 설치를시작합니다. 16

22. CentOS 설치완료후 reboot 을수행합니다. 17

23. Forward 를선택합니다. 24. Firewall 을 Disabled 합니다. 18

25. SELinux 를 Disabled 합니다. 26. Forward 를선택합니다. 19

27. 날짜및시간설정후 Forward 를선택합니다. 28. 별도의 User 를생성하지않고 Forward 를선택합니다. 20

29. 설정을마친후 reboot 이수행됩니다. 30. Root 계정으로 login 한후 tibero User 를생성합니다. 21

31. Tibero User 를생성합니다. [root@tac1 ~]# groupadd dba [root@tac1 ~]# useradd -g dba -d /tibero tibero [root@tac1 ~]# passwd tibero [root@tac1 ~]# chown -R tibero:dba /tibero 32. /etc/hosts 를편집합니다. [root@tac1 ~]# vi /etc/hosts # Public Network 192.168.xx.xx tac1 192.168.xx.xx tac2 # VIP Network 192.168.xx.xx tac1-vip 192.168.xx.xx tac2-vip 22

# Interconnect Network 10.10.xx.xx tac1-inter 10.10.xx.xx tac2-inter 33. /etc/sysctl.conf 에서권장세마포어값을설정합니다. [root@tac1 ~]# vi /etc/sysctl.conf kernel.shmmax = 1073741824 kernel.shmall = 2097152 kernel.sem = 10000 32000 10000 10000 kernel.shmmni = 4096 fs.file-max = 6815744 net.ipv4.ip_local_port_range = 1024 65000 34. /etc/security/limits.conf 를수정합니다. [root@tac1 ~]# vi /etc/security/limits.conf tibero soft nproc 2047 tibero hard nproc 16384 tibero soft nofile 1024 tibero hard nofile 65536 23

35. root user 의.bash_profile 을수정합니다. [root@tac1 ~]# vi ~/.bash_profile #.bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then. ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:/usr/bin:/etc:/usr/sbin:/usr/bin/X11:/sbin export PATH unset USERNAME ######## Profile ENV Config ############### umask 027 ulimit -c 0 set -o vi stty erase ^H export EDITOR=vi export TERM=vt100 export PS1='[$LOGNAME@'`uname -n`':$pwd]# ' export LANG=ko_KR.euckr ### TIBERO RDBMS 5 ENV ### export TB_HOME=/tibero/tibero5 export TB_SID=tac1 export TB_PROF_DIR=$TB_HOME/bin/prof export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH 24

36. tibero user 의.bash_profile 을수정합니다. [tibero@tac1:/tibero]$ vi ~/.bash_profile #.bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then. ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:/usr/bin:/etc:/usr/sbin:/usr/bin/X11:/sbin export PATH unset USERNAME ######## Profile ENV Config ############### umask 027 ulimit -c 0 set -o vi stty erase ^H export EDITOR=vi export TERM=vt100 export PS1='[$LOGNAME@'`uname -n`':$pwd]$ ' export LANG=ko_KR.euckr ### TIBERO RDBMS 5 ENV ### export TB_HOME=/tibero/tibero5 export TB_SID=tac1 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 ######## 25

alias tbhome='cd $TB_HOME' alias tbbin='cd $TB_HOME/bin' alias tblog='cd /tibero/tiblog/pimg/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 cmf='tail -f /tibero/tiblog/pimg/log/cm/trace_list.log' alias tracef='tail -f /tibero/tiblog/pimg/log/tracelog/trace.log' alias tbi='cd ~/tbinary' alias tm='cd ~/tbinary/monitor;monitor;cd -' 37. 불필요한프로세스를종료합니다. [root@tac1:/root]# chkconfig --level 123456 xinetd off [root@tac1:/root]# chkconfig --level 123456 sendmail off [root@tac1:/root]# chkconfig --level 123456 cups off [root@tac1:/root]# chkconfig --level 123456 cups-config-daemon off [root@tac1:/root]# chkconfig --level 123456 smartd off 26

[root@tac1:/root]# chkconfig --level 123456 isdn off [root@tac1:/root]# chkconfig --level 123456 iptables off 38. Tibero 5SP1 Binary 및 License 를 FTP 으로전송합니다. 39. Tibero Binary 전송이완료되었으면, 가상머신복제를위해서 shutdown 을수행합니다. 27

40. 설치완료한 tac1 가상머신을복제합니다. 41. 복제가완료된 tac2 가상머신을시작합니다. 28

42. tac2 가상머신의네트워크설정을변경합니다. Device IP Gateway eth0 192.168.xx.xx/24 192.168.xx. eth1 10.10.xx.xx/24 - [root@tac1:/root]# neat 29

30

43. 네트워크서비스를재기동합니다. [root@tac1:/root]# service network restart [root@tac1:/root]# uname -n [root@tac1:/root]# ifconfig -a 31

44. tac2 가상머신을종료합니다. 45. 공유스토리지를추가합니다. cd C:\Program Files\Oracle\VirtualBox VBoxManage createhd --filename "D:\VirtualBox VMs\shared_disk\sharedisk1.vdi" --size 5120 --format VDI --variant Fixed 32

VBoxManage createhd --filename "D:\VirtualBox VMs\shared_disk\sharedisk2.vdi" --size 5120 --format VDI --variant Fixed VBoxManage createhd --filename "D:\VirtualBox VMs\shared_disk\sharedisk3.vdi" --size 5120 --format VDI --variant Fixed VBoxManage createhd --filename "D:\VirtualBox VMs\shared_disk\sharedisk4.vdi" --size 5120 --format VDI --variant Fixed VBoxManage storageattach tac1 --storagectl "SATA" --port 1 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk1.vdi" --mtype shareable VBoxManage storageattach tac1 --storagectl "SATA" --port 2 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk2.vdi" --mtype shareable VBoxManage storageattach tac1 --storagectl "SATA" --port 3 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk3.vdi" --mtype shareable VBoxManage storageattach tac1 --storagectl "SATA" --port 4 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk4.vdi" --mtype shareable VBoxManage modifyhd "D:\VirtualBox VMs\shared_disk\sharedisk1.vdi" --type shareable VBoxManage modifyhd "D:\VirtualBox VMs\shared_disk\sharedisk2.vdi" --type shareable VBoxManage modifyhd "D:\VirtualBox VMs\shared_disk\sharedisk3.vdi" --type shareable VBoxManage modifyhd "D:\VirtualBox VMs\shared_disk\sharedisk4.vdi" --type shareable VBoxManage storageattach tac2 --storagectl "SATA" --port 1 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk1.vdi" --mtype shareable VBoxManage storageattach tac2 --storagectl "SATA" --port 2 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk2.vdi" --mtype shareable VBoxManage storageattach tac2 --storagectl "SATA" --port 3 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk3.vdi" --mtype shareable VBoxManage storageattach tac2 --storagectl "SATA" --port 4 --device 0 --type hdd -- medium "D:\VirtualBox VMs\shared_disk\sharedisk4.vdi" --mtype shareable 46. tac1, tac2 가상머신을시작합니다. 33

47. 추가한공유스토리지가할당되었는지확인합니다. [root@tac1:/root]# fdisk -l /dev/sdb [root@tac1:/root]# fdisk -l /dev/sdc [root@tac1:/root]# fdisk -l /dev/sdd [root@tac1:/root]# fdisk -l /dev/sde 48. fdisk 를수행합니다. [root@tac1:/root]# fdisk /dev/sdb [root@tac1:/root]# fdisk /dev/sdc 34

[root@tac1:/root]# fdisk /dev/sdd [root@tac1:/root]# fdisk /dev/sde [root@tac1:/root]# ls -rlt /dev/sd[b-e]1 49. Physical Volumn 을생성합니다.. [root@tac1:/root]# pvcreate /dev/sdb1 /dev/sdc1 [root@tac1:/root]# pvcreate /dev/sdd1 /dev/sde1 [root@tac1:/root]# pvdisplay 35

50. Volumn Group 을생성합니다.. [root@tac1:/root]# vgcreate vg1 /dev/sdb1 /dev/sdc1 [root@tac1:/root]# vgcreate vg2 /dev/sdd1 /dev/sde1 [root@tac1:/root]# vgdisplay 36

51. Logical Volumn 을생성합니다. (mount 하기위해서는 Cluster File Sytem 이필요하므로 mount 를하지않습니다.). lvcreate -L 10M -n vol_tbcm_001 vg1 lvcreate -L 20M -n vol_control_001 vg1 lvcreate -L 128M -n vol_128m_001 vg1 lvcreate -L 128M -n vol_128m_002 vg1 lvcreate -L 128M -n vol_128m_003 vg1 lvcreate -L 128M -n vol_128m_004 vg1 lvcreate -L 128M -n vol_128m_005 vg1 lvcreate -L 128M -n vol_128m_006 vg1 lvcreate -L 128M -n vol_128m_007 vg1 lvcreate -L 128M -n vol_128m_008 vg1 lvcreate -L 128M -n vol_128m_009 vg1 lvcreate -L 128M -n vol_128m_010 vg1 lvcreate -L 128M -n vol_128m_011 vg1 lvcreate -L 128M -n vol_128m_012 vg1 lvcreate -L 128M -n vol_128m_013 vg1 lvcreate -L 128M -n vol_128m_014 vg1 lvcreate -L 128M -n vol_128m_015 vg1 lvcreate -L 512M -n vol_512m_001 vg1 lvcreate -L 512M -n vol_512m_002 vg1 lvcreate -L 512M -n vol_512m_003 vg1 lvcreate -L 512M -n vol_512m_004 vg1 lvcreate -L 512M -n vol_512m_005 vg1 lvcreate -L 512M -n vol_512m_006 vg1 lvcreate -L 512M -n vol_512m_007 vg1 lvcreate -L 512M -n vol_512m_008 vg1 lvcreate -L 512M -n vol_512m_009 vg1 lvcreate -L 512M -n vol_512m_010 vg1 lvcreate -L 512M -n vol_512m_011 vg1 lvcreate -L 512M -n vol_512m_012 vg1 lvcreate -L 512M -n vol_512m_013 vg1 lvcreate -L 512M -n vol_512m_014 vg1 37

lvcreate -L 512M -n vol_512m_015 vg1 lvcreate -L 512M -n vol_512m_016 vg1 lvcreate -L 10M -n vol_tbcm_002 vg2 lvcreate -L 20M -n vol_control_002 vg2 lvcreate -L 128M -n vol_128m_001 vg2 lvcreate -L 128M -n vol_128m_002 vg2 lvcreate -L 128M -n vol_128m_003 vg2 lvcreate -L 128M -n vol_128m_004 vg2 lvcreate -L 128M -n vol_128m_005 vg2 lvcreate -L 128M -n vol_128m_006 vg2 lvcreate -L 128M -n vol_128m_007 vg2 lvcreate -L 128M -n vol_128m_008 vg2 lvcreate -L 128M -n vol_128m_009 vg2 lvcreate -L 128M -n vol_128m_010 vg2 lvcreate -L 128M -n vol_128m_011 vg2 lvcreate -L 128M -n vol_128m_012 vg2 lvcreate -L 128M -n vol_128m_013 vg2 lvcreate -L 128M -n vol_128m_014 vg2 lvcreate -L 128M -n vol_128m_015 vg2 lvcreate -L 512M -n vol_512m_001 vg2 lvcreate -L 512M -n vol_512m_002 vg2 lvcreate -L 512M -n vol_512m_003 vg2 lvcreate -L 512M -n vol_512m_004 vg2 lvcreate -L 512M -n vol_512m_005 vg2 lvcreate -L 512M -n vol_512m_006 vg2 lvcreate -L 512M -n vol_512m_007 vg2 lvcreate -L 512M -n vol_512m_008 vg2 lvcreate -L 512M -n vol_512m_009 vg2 lvcreate -L 512M -n vol_512m_010 vg2 lvcreate -L 512M -n vol_512m_011 vg2 lvcreate -L 512M -n vol_512m_012 vg2 lvcreate -L 512M -n vol_512m_013 vg2 lvcreate -L 512M -n vol_512m_014 vg2 lvcreate -L 512M -n vol_512m_015 vg2 lvcreate -L 512M -n vol_512m_016 vg2 [root@tac1:/root]# lvdisplay 38

52. Device 생성및소유권확인. (udev rule 설정을통하여 ownership 관리가이루어져야하나테스트용임으로간편하게 /etc/rc.local 파일을수정하도록합니다.). [root@tac1:/root]# vi /etc/rc.local chown tibero:dba /dev/mapper/vg* 39

53. Tac2 가상머신의 root, tibero User 의 TB_SID 를변경합니다. [root@tac2:/root]# vi ~/.bash_profile Export TB_SID=tac2 2.2 VirtualBox 에서 TAC 구성 1. Tibero 5 SP1 바이너리압축을해제합니다. [tibero@tac1:/tibero]$ ls -rlt /tibero [tibero@tac1:/tibero]$ gzip -dc tibero5-bin-fs01-linux64-107040-opt- 20150717210857.tar.gz tar -xvf - 40

2. gen_tip 실행및설정합니다. [tibero@tac1:/tibero]$./tibero5/config/gen_tip.sh Using TB_SID "tac1" /tibero/tibero5/config/tac1.tip generated /tibero/tibero5/config/psm_commands generated /tibero/tibero5/client/config/tbdsn.tbr generated. Running client/config/gen_esql_cfg.sh Done. 3. 초기화파라미터설정값을변경합니다. [tibero@tac1:/tibero]$ vi $TB_HOME/config/$TB_SID.tip [tibero@tac1:/tibero]$ cat $TB_HOME/config/$TB_SID.tip ## Database Identification DB_NAME=tac LISTENER_PORT=8629 ## File Configuration DB_CREATE_FILE_DEST="/tibero/tbdata" CONTROL_FILES="/dev/mapper/vg1-vol_control_001","/dev/mapper/vg2-vol_control_002" ## Memory & Session TOTAL_SHM_SIZE=768M MEMORY_TARGET=1280M MAX_SESSION_COUNT=50 41

## Undo and Rollback Segments UNDO_RETENTION=900 _USGMT_UNIFORM_EXTSIZE=64 _USGMT_ONLINE_MIN=30 _USGMT_ONLINE_MAX=100 UNDO_TABLESPACE="UNDOTBS1" ## Cache and I/O DB_BLOCK_SIZE=8192 DB_FILE_MULTIBLOCK_READ_COUNT=64 ## Archive Log Mode LOG_ARCHIVE_FORMAT="arcTAC%t_%s_%r.arc" LOG_ARCHIVE_DEST="/tibero/tibarch" _ARCHIVE_LAG_TARGET=21600 _ARCHIVE_CLOSED_THREAD=Y _ARCHIVE_CLOSED_THREAD_DIE_ON_FAIL=N ## Statistics AUDIT_TRAIL=NONE AUDIT_SYS_OPERATIONS=N AUDIT_FILE_DEST="/tibero/tiblog/tac/audit" ## APM Report AUTOMATIC_PERFORMANCE_MONITORING=Y APM_SNAPSHOT_SAMPLING_INTERVAL=60 APM_SNAPSHOT_RETENTION=7 APM_SNAPSHOT_TOP_SQL_CNT=10 ## Checkpoint _LOG_INC_CHECKPOINT_TIMEOUT=1 _LOG_INC_CKPT_LAG_LIMIT_PCT=25 ## Log Dest CM_LOG_DEST="/tibero/tiblog/tac/log/cm" DBMS_LOG_DEST="/tibero/tiblog/tac/log/dbmslog" EVENT_TRACE_DEST="/tibero/tiblog/tac/log/event" LSNR_LOG_DEST="/tibero/tiblog/tac/log/lsnr" SQL_TRACE_DEST="/tibero/tiblog/tac/log/sqltrace" TRACE_DUMP_DEST="/tibero/tiblog/tac/dump/tracedump" TRACE_LOG_DEST="/tibero/tiblog/tac/log/tracelog" ## Cluster Database CLUSTER_DATABASE=Y THREAD=0 LOCAL_CLUSTER_ADDR=10.10.XX.xx 42

LOCAL_CLUSTER_PORT=8631 LOCAL_CLUSTER_VIP=192.168.xx.xx LOCAL_CLUSTER_NIC=eth0 LOCAL_CLUSTER_VIP_NETMASK=255.255.xxx.xx LOCAL_CLUSTER_VIP_BROADCAST=192.168.xx.xx ## TBCM Parameter CM_CLUSTER_MODE=ACTIVE_SHARED CM_FILE_NAME="/dev/mapper/vg1-vol_tbcm_001","/dev/mapper/vg2-vol_tbcm_002" CM_PORT=8632 CM_HEARTBEAT_EXPIRE=30 CM_WATCHDOG_EXPIRE=25 CM_AUTO_VIP_FAILBACK=N CM_ENABLE_CM_DOWN_NOTIFICATION=Y CM_ENABLE_FAST_NET_ERROR_DETECTION=Y CM_FENCE=Y _CM_ENABLE_VIP_ALIAS_CHECK=N _CM_ENABLE_VIP_ALIAS_RETRY=N _CM_REBOOT_RETRY_COUNT=3 ## Miscellaneous ACTIVE_SESSION_HISTORY=Y USE_NET_KEEPALIVE=Y USE_RECYCLEBIN=Y NLS_DATE_FORMAT="YYYY/MM/DD HH24:MI:SS" BIND_VARIABLE_CAPTURE=Y JOB_HISTORY_LOG=Y --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- [tibero@tac2:/tibero]$ cat $TB_HOME/config/$TB_SID.tip ## Database Identification DB_NAME=tac LISTENER_PORT=8629 ## File Configuration DB_CREATE_FILE_DEST="/tibero/tbdata" CONTROL_FILES="/dev/mapper/vg1-vol_control_001","/dev/mapper/vg2-vol_control_002" ## Memory & Session TOTAL_SHM_SIZE=768M MEMORY_TARGET=1280M MAX_SESSION_COUNT=50 ## Undo and Rollback Segments UNDO_RETENTION=900 _USGMT_UNIFORM_EXTSIZE=64 _USGMT_ONLINE_MIN=30 _USGMT_ONLINE_MAX=100 43

UNDO_TABLESPACE="UNDOTBS2" ## Cache and I/O DB_BLOCK_SIZE=8192 DB_FILE_MULTIBLOCK_READ_COUNT=64 ## Archive Log Mode LOG_ARCHIVE_FORMAT="arcTAC%t_%s_%r.arc" LOG_ARCHIVE_DEST="/tibero/tibarch" _ARCHIVE_LAG_TARGET=21600 _ARCHIVE_CLOSED_THREAD=Y _ARCHIVE_CLOSED_THREAD_DIE_ON_FAIL=N ## Statistics AUDIT_TRAIL=NONE AUDIT_SYS_OPERATIONS=N AUDIT_FILE_DEST="/tibero/tiblog/tac/audit" ## APM Report AUTOMATIC_PERFORMANCE_MONITORING=Y APM_SNAPSHOT_SAMPLING_INTERVAL=60 APM_SNAPSHOT_RETENTION=7 APM_SNAPSHOT_TOP_SQL_CNT=10 ## Checkpoint _LOG_INC_CHECKPOINT_TIMEOUT=1 _LOG_INC_CKPT_LAG_LIMIT_PCT=25 ## Log Dest CM_LOG_DEST="/tibero/tiblog/tac/log/cm" DBMS_LOG_DEST="/tibero/tiblog/tac/log/dbmslog" EVENT_TRACE_DEST="/tibero/tiblog/tac/log/event" LSNR_LOG_DEST="/tibero/tiblog/tac/log/lsnr" SQL_TRACE_DEST="/tibero/tiblog/tac/log/sqltrace" TRACE_DUMP_DEST="/tibero/tiblog/tac/dump/tracedump" TRACE_LOG_DEST="/tibero/tiblog/tac/log/tracelog" ## Cluster Database CLUSTER_DATABASE=Y THREAD=1 LOCAL_CLUSTER_ADDR= LOCAL_CLUSTER_PORT=8631 LOCAL_CLUSTER_VIP= LOCAL_CLUSTER_NIC=eth0 LOCAL_CLUSTER_VIP_NETMASK= LOCAL_CLUSTER_VIP_BROADCAST= ## TBCM Parameter 44

CM_CLUSTER_MODE=ACTIVE_SHARED CM_FILE_NAME="/dev/mapper/vg1-vol_tbcm_001","/dev/mapper/vg2-vol_tbcm_002" CM_PORT=8632 CM_HEARTBEAT_EXPIRE=30 CM_WATCHDOG_EXPIRE=25 CM_AUTO_VIP_FAILBACK=N CM_ENABLE_CM_DOWN_NOTIFICATION=Y CM_ENABLE_FAST_NET_ERROR_DETECTION=Y CM_FENCE=Y _CM_ENABLE_VIP_ALIAS_CHECK=N _CM_ENABLE_VIP_ALIAS_RETRY=N _CM_REBOOT_RETRY_COUNT=3 ## Miscellaneous ACTIVE_SESSION_HISTORY=Y USE_NET_KEEPALIVE=Y USE_RECYCLEBIN=Y NLS_DATE_FORMAT="YYYY/MM/DD HH24:MI:SS" BIND_VARIABLE_CAPTURE=Y JOB_HISTORY_LOG=Y 4. tbdsn.tbr 파일을변경합니다. [tibero@tac1:/tibero]$ cat $TB_HOME/client/config/tbdsn.tbr #------------------------------------------------- # /tibero/tibero5/client/config/tbdsn.tbr # Network Configuration File. # Generated by gen_tip.sh at 2015. 08. 04. ( 15:08:31 KST tac1=( (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) ) tac1_sp=( (INSTANCE=(HOST= ) (PORT=8630) (DB_NAME=tac) ) ) tac2=( (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) ) tac=( (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) (LOAD_BALANCE=N) (USE_FAILOVER=N) ) 45

[tibero@tac2:/tibero]$ cat $TB_HOME/client/config/tbdsn.tbr # /tibero/tibero5/client/config/tbdsn.tbr # Network Configuration File. # Generated by gen_tip.sh at 2015. 08. 04. ( 15:20:06 KST tac2=( (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) ) tac2_sp=( (INSTANCE=(HOST= ) (PORT=8630) (DB_NAME=tac) ) ) tac1=( (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) ) tac=( (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) (INSTANCE=(HOST= ) (PORT=8629) (DB_NAME=tac) ) (LOAD_BALANCE=N) (USE_FAILOVER=N) ) 5. Tibero License 파일을저장합니다. [tibero@tac1:/tibero]$ cat /tibero/tibero5/license/license.xml <?xml version="1.0" encoding="iso-8859-1"?> <tmax_license> <license version="1.0"> <product version="5sp1">tibero</product> <serial_id>1438328432</serial_id> <issue_date>2015/07/31</issue_date> <licensee>tac1</licensee> <edition>enterprise</edition> <type>demo</type> <demo_duration>184</demo_duration> <identified_by_host>tac1</identified_by_host> <signature>tzggo5y1euer4re2fkh5fcsaijrbq6wxuvhzjwqetui=</signature> </license> </tmax_license> [tibero@tac2:/tibero]$ cat /tibero/tibero5/license/license.xml <?xml version="1.0" encoding="iso-8859-1"?> <tmax_license> <license version="1.0"> <product version="5sp1">tibero</product> <serial_id>1438678840</serial_id> <issue_date>2015/08/04</issue_date> <licensee>tac2</licensee> 46

<edition>enterprise</edition> <type>demo</type> <demo_duration>184</demo_duration> <identified_by_host>tac2</identified_by_host> <signature>wuhe75y1euer4re2fkh5fh8u4kjbq6wxuvhzjwqetui=</signature> </license> </tmax_license> 6. root User 으로 tbcm 을기동합니다. [root@tac1:/root]# tbcm -c SUCCESS [root@tac1:/root]# tbcm -b CM file created! Keep booting CM-guard demon started up. I/O fence enabled. Tibero 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero cluster manager CM started up. Local node name is (cm@xx.xx.xx.xx:8632). [root@tac2:/root]# tbcm -b There exists valid CM file. Keep booting CM-guard demon started up. I/O fence enabled. Tibero 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero cluster manager CM started up. Local node name is (cm@ xx.xx.xx.xx:8632). 7. tibero5 directory 소유권을변경합니다 [root@tac1:/root]# chown -R tibero:dba /tibero/tibero5 [root@tac1:/root]# chown -R tibero:dba /tibero/tiblog [root@tac2:/root]# chown -R tibero:dba /tibero/tibero5 [root@tac2:/root]# chown -R tibero:dba /tibero/tiblog 47

8. tibero user 으로 nomount 으로기동합니다. [root@tac1:/root]# su - tibero [tibero@tac1:/tibero]$ tbboot -t nomount Listener port = 8629 Change core dump dir to /tibero/tibero5/bin/prof. Tibero 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NOMOUNT mode). 9. Database 를생성합니다. [tibero@tac1:/tibero]$ tbsql sys/tibero@tac1_sp tbsql 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> create database "tac" user sys identified by tibero character set MSWIN949 logfile group 0 ('/dev/mapper/vg1-vol_128m_001','/dev/mapper/vg2-vol_128m_001') size 127M, group 1 ('/dev/mapper/vg1-vol_128m_002','/dev/mapper/vg2-vol_128m_002') size 127M, group 2 ('/dev/mapper/vg1-vol_128m_003','/dev/mapper/vg2-vol_128m_003') size 127M, group 3 ('/dev/mapper/vg1-vol_128m_004','/dev/mapper/vg2-vol_128m_004') size 127M, group 4 ('/dev/mapper/vg1-vol_128m_005','/dev/mapper/vg2-vol_128m_005') size 127M maxdatafiles 5120 maxlogfiles 100 maxlogmembers 8 noarchivelog datafile '/dev/mapper/vg1-vol_512m_001' size 511M autoextend off default tablespace USR datafile '/dev/mapper/vg1-vol_128m_013' size 127M autoextend off default temporary tablespace TEMP tempfile '/dev/mapper/vg1-vol_512m_004' size 511M autoextend off extent management local AUTOALLOCATE undo tablespace UNDOTBS1 datafile '/dev/mapper/vg1-vol_512m_002' size 511M autoextend off extent management local UNIFORM SIZE 128K ; Database created. 48

10. Tibero 기동후 Thread 1 의 UNDO & REDO 를추가후활성화합니다. SQL> quit [tibero@tac1:/tibero]$ tbboot Listener port = 8629 Change core dump dir to /tibero/tibero5/bin/prof. Tibero 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). [tibero@tac1:/tibero]$ tbsql sys/tibero tbsql 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> create undo tablespace UNDOTBS2 datafile '/dev/mapper/vg1-vol_512m_003' size 511M autoextend off extent management local UNIFORM SIZE 128K ; Tablespace 'UNDOTBS2' created. SQL> alter database add logfile thread 1 group 5 ('/dev/mapper/vg1- vol_128m_006','/dev/mapper/vg2-vol_128m_006') size 127M; 49

Database altered. SQL> alter database add logfile thread 1 group 6 ('/dev/mapper/vg1- vol_128m_007','/dev/mapper/vg2-vol_128m_007') size 127M; Database altered. SQL> alter database add logfile thread 1 group 7 ('/dev/mapper/vg1- vol_128m_008','/dev/mapper/vg2-vol_128m_008') size 127M; Database altered. SQL> alter database add logfile thread 1 group 8 ('/dev/mapper/vg1- vol_128m_009','/dev/mapper/vg2-vol_128m_009') size 127M; Database altered. SQL> alter database add logfile thread 1 group 9 ('/dev/mapper/vg1- vol_128m_010','/dev/mapper/vg2-vol_128m_010') size 127M; Database altered. SQL> alter database enable public thread 1; Database altered. 50

11. APM Tablespace 를생성합니다. SQL> create tablespace _apm_ts datafile '/dev/mapper/vg1-vol_128m_014' size 127m autoextend off; Tablespace '_APM_TS' created. 12. $TB_HOME/scripts 디렉터리에서 system.sh 명령어를입력하여 data dictionary 와 system 패키지를생성합니다. [tibero@tac1:/tibero]$ sh $TB_HOME/scripts/system.sh -p1 tibero -p2 syscat -a1 y -a2 y -a3 y -a4 y 51

13. tac2 tibero 를기동후 Instance 상태를확인합니다. [tibero@tac2:/tibero]$ tbboot Listener port = 8629 Change core dump dir to /tibero/tibero5/bin/prof. Tibero 5 SP1 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). [tibero@tac1:/tibero]$ tbcm s [tibero@tac1:/tibero]$ tbsql sys/tibero SQL> SELECT * FROM V$INSTANCE; 52

53

Copyright 2015 TmaxSoft Co., Ltd. All Rights Reserved. Trademarks Tmax, WebtoB, WebT, JEUS, ProFrame, SysMaster and OpenFrame are registered trademarks of TmaxSoft Co., Ltd. Other products, titles or services may be registered trademarks of their respective companies. Contact Information TmaxSoft can be contacted at the following addresses to arrange for a consulting team to visit your company and discuss your options. Korea TmaxSoft Co., Ltd 5, Hwangsaeul-ro 329beon-gil, Bundang-gu, Seongnam-si, Gyeonggi-do. South Korea Tel: +82-31-8018-1000 Fax: +82-31-8018-1115 Email: info@tmax.co.kr Web (Korean): http://www.tmaxsoft.com Technical Support: http://technet.tmaxsoft.com USA TmaxSoft, Inc. 560 Sylvan Avenue Englewood Cliffs, NJ 07632. U.S.A Tel: +1-201-567-8266 Fax: +1-201-567-7339 Email: info@tmaxsoft.com Web (English): http://www.tmaxsoft.com Russia Tmax Russia L.L.C. Grand Setun Plaza, No A204 Gorbunova st.2, Moscow, 121596 Tel: +7(495)970-01-35 Email: info.rus@tmaxsoft.com Web (Russian): http://ru.tmaxsoft.com Singapore Tmax Singapore Pte. Ltd. 430 Lorong 6, Toa Payoh #10-02, OrangeTee Building. Singapore 319402 Tel: +65-6259-7223 Email: info.sg@tmaxsoft.com United Kingdom TmaxSoft UK Ltd. Surrey House, Suite 221, 34 Eden Street, Kingston-Upon- Thames, KT1 1ER United Kingdom Tel: + 44-(0)20-8481-3776 Email: info.uk@tmaxsoft.com Web (English): http:/www.tmaxsoft.com Japan TmaxSoft Japan Co., Ltd. 5F Sanko Bldg, 3-12-16 Mita, Minato-Ku, Tokyo, 108-0073 Japan Tel: +81-3-5765-2550 Fax: +81-3-5765-2567 Email: info.jp@tmaxsoft.com Web (Japanese): http://www.tmaxsoft.co.jp China TmaxSoft China Co., Ltd. Beijing Silver Tower, RM 1508, 2 North Rd Dong San Huan, Chaoyang District, Beijing, China, 100027. China Tel: +86-10-6410-6145~8 Fax: +86-10-6410-6144 Email: info.cn@tmaxsoft.com Web (Chinese): http://www.tmaxsoft.com.cn Brazil TmaxSoft Brazil Avenida Copacabana, 177-3 andar 18 do Forte Empresarial, Alphaville - Barueri, Sao Paulo, SP-Brasil CEP 06472-001 Email: contato.brasil@tmaxsoft.com TD-TRCF-E0804001 54