리눅스 Tibero5 설치

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 참고[ | ]