tibero 계정 생성
groupadd dba
useradd -d /tibero -g dba tibero
passwd tibero
profile 수정
su - tibero
vi .bash_profile
.bash_profile 가장 하단에 아래의 내용을 추가함
export TB_HOME=/tibero/tibero5
export TB_SID=tibero
export TB_PROF_DIR=$TB_HOME/bin/prof
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
TB_HOME : tibero 설치 디렉터리
TB_SID : tibero service id
tibero 압축 풀기
> tar -xvf tibero5-bin-FS05_CS_1902-linux64-166170-opt.tar.gz
[tibero@server02 ~]$ tar -xvf tibero5-bin-FS05_CS_1902-linux64-166170-opt.tar.gz
tibero5/bin/alterdd.sh
tibero5/bin/update/system_sh_pkgonly.sh
tibero5/bin/update/psm_recompile_all.sh
> ls -ltr
[tibero@server02 ~]$ ls -ltr
합계 278952
-rw-r--r--. 1 tibero dba 285645543 7월 14 00:49 tibero5-bin-FS05_CS_1902-linux64-166170-opt.tar.gz
drwxr-xr-x. 8 tibero dba 86 7월 14 01:31 tibero5
라이센스 파일 업로드
$TB_HOME/license 에 license.xml 파일을 업로드 하자
[tibero@server02 license]$ cd $TB_HOME/license
[tibero@server02 license]$ pwd
/tibero/tibero5/license
[tibero@server02 license]$ ls -ltr
합계 4
drwxr-xr-x. 2 tibero dba 117 7월 14 01:31 oss_licenses
-rw-r--r--. 1 root root 486 7월 14 01:33 license.xml
gen_tip.sh 실행
환경 파일(.tip)과 tbdsn.tbr, psm_commands 파일이 생성된다
[tibero@server02 config]$ cd $TB_HOME/config
[tibero@server02 config]$ ./gen_tip.sh
Using TB_SID "tibero"
/tibero/tibero5/config/tibero.tip generated
/tibero/tibero5/config/psm_commands generated
/tibero/tibero5/client/config/tbdsn.tbr generated.
Running client/config/gen_esql_cfg.sh
Done.
'NOMOUNT 모드'로 기동
( tibero 부팅 모드에는 여러가지가 있음 )
[tibero@server02 config]$ tbboot nomount
Listener port = 8629
Warning: The initialization parameter 'MEMORY_TARGET' value is greater than the physical system memory size. MEMORY_TARGET: 1073741824 Physical System Memory Size: 1021906944 Excessive memory consumption may cause the system to slow down or malfunction. It is recommended to set the MEMORY_TARGET to a value less than the physical system memory size.
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).
포트 : 8629 확인
sys 사용자로 접속하기
sys : tibero 관리자
[tibero@server02 config]$ tbsql sys/tibero
tbSQL 5 SP1
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL>
데이터베이스를 생성
tibero로 생성
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.
Tibero를 다시 기동
[tibero@server02 config]$ tbboot
Listener port = 8629
Warning: The initialization parameter 'MEMORY_TARGET' value is greater than the physical system memory size. MEMORY_TARGET: 1073741824 Physical System Memory Size: 1021906944 Excessive memory consumption may cause the system to slow down or malfunction. It is recommended to set the MEMORY_TARGET to a value less than the physical system memory size.
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@server02 scripts]$ cd $TB_HOME/scripts
[tibero@server02 scripts]$ ./system.sh
Enter SYS password:
Enter SYSCAT password:
Dropping agent table...
Creating the role DBA...
Create default system users & roles?(Y/N):
...
Creating agent table...
Done.
For details, check /tibero/tibero5/instance/tibero/log/system_init.log.
계속 Y 입력하면 됨.
기본 암호
id : sys , pw : tibero
id : syscat , pw : syscat
프로세스 확인하기
tibero 2773 1 0 01:47 pts/0 00:00:00 /tibero/tibero5/bin/tblistener -t NORMAL -SVR_SID tibero
tibero 2774 2773 0 01:47 pts/0 00:00:00 tbsvr -n 4 -t NORMAL -SVR_SID tibero
tibero 2779 2774 0 01:47 pts/0 00:00:00 tbsvr_WT001 -n 4 -t NORMAL -SVR_SID tibero
tibero 2780 2774 0 01:47 pts/0 00:00:06 tbsvr_WT002 -n 4 -t NORMAL -SVR_SID tibero
tibero 2781 2774 0 01:47 pts/0 00:00:00 tbsvr_WT003 -n 4 -t NORMAL -SVR_SID tibero
tibero 2782 2774 0 01:47 pts/0 00:00:00 tbsvr_PEP001 -n 4 -t NORMAL -SVR_SID tibero
tibero 2783 2774 0 01:47 pts/0 00:00:00 tbsvr_PEP002 -n 4 -t NORMAL -SVR_SID tibero
tibero 2784 2774 0 01:47 pts/0 00:00:00 tbsvr_PEP003 -n 4 -t NORMAL -SVR_SID tibero
tibero 2785 2774 0 01:47 pts/0 00:00:00 tbsvr_PEP004 -n 4 -t NORMAL -SVR_SID tibero
tibero 2786 2774 0 01:47 pts/0 00:00:00 tbsvr_SEQW -n 4 -t NORMAL -SVR_SID tibero
tibero 2787 2774 0 01:47 pts/0 00:00:01 tbsvr_LOGW -n 4 -t NORMAL -SVR_SID tibero
tibero 2788 2774 0 01:47 pts/0 00:00:00 tbsvr_LOGA -n 4 -t NORMAL -SVR_SID tibero
tibero 2789 2774 0 01:47 pts/0 00:00:00 tbsvr_CKPT -n 4 -t NORMAL -SVR_SID tibero
tibero 2790 2774 1 01:47 pts/0 00:00:08 tbsvr_BLKW000 -n 4 -t NORMAL -SVR_SID tibero
포트 확인
[tibero@server02 scripts]$ netstat -an | grep 8629
tcp 0 0 0.0.0.0:8629 0.0.0.0:* LISTEN
계정 설명
SYS
데이터베이스 관리를 위한 계정으로서 시스템 패키지, 동의어, 사용자, 역할, 가상 테이블, 시퀀스, 동적 뷰 등을 생성하고 관리한다.
SYSCAT
데이터베이스 관리를 위한 정적 카탈로그 뷰를 생성하고 관리하는 계정이다.
'CentOS' 카테고리의 다른 글
CentOS - g++ 설치하기 (0) | 2019.08.31 |
---|---|
CentOS - gcc 설치하기 (0) | 2019.08.31 |
CentOS - 티베로(tibero) 5 설치하기 (1) (0) | 2019.07.14 |
CentOS - hostname 변경하기 (0) | 2019.07.14 |
CentOS - java 환경변수 설정하기 (0) | 2019.07.14 |