Tibero 6 설치하기 ( centos 7 Linux)

확인

[root@tibero ~]# uname -a
Linux tibero 4.14.35-1902.300.11.el7uek.x86_64 #2 SMP Tue Mar 17 17:11:47 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux

 

그륩 tibero 유저생성

groupadd dba
[root@tibero ~]# adduser -d /home/tibero -g dba tibero

 

파일질라 또는 모반텀에서 패키지,라이센습 발급후 올리기

[root@tibero test]# ll
total 16324
-rw-r--r--. 1 root root      479 Aug 28 11:04 license (3).xml
-rw-r--r--. 1 root root 15990784 Aug 28 11:04 tibero6-bin-FS07_PS02-linux64_3.10-277759-20240826115837.tar.gz

 

tibero 계정으로  옮김.

 

• tibero 계정으로 옮기기

[root@tibero test]# mv * /home/tibero/

 

권한 설정 및 tibero 계정에서 패키지 설치

chown -R tibero:dba /home/tibero
tar -xvf  tibero6-bin-FS07_PS02-linux64_3.10-277759-20240826115837.tar.gz
/home/tibero/tibero6

 

tibero 계정 : /.bash_profile

export TB_HOME=/home/tibero/tibero6
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

 

환경변수 적용

• 적용

source .bash_profile

 

 

• $TB_HOME/config/gen_tip.sh 

[tibero@tibero config]$ ll
total 56
-rw-r--r--. 1 tibero dba  474 Aug 23 01:09 cm.template
-rwxr-xr-x. 1 tibero dba 4433 May 29 20:11 gen_psm_cmd.sh
-rwxr-xr-x. 1 tibero dba 8476 Aug 23 01:09 gen_tip_for_tac.sh
-rwxr-xr-x. 1 tibero dba 4886 May 29 20:11 gen_tip.sh
-rw-r--r--. 1 tibero dba 1796 May 29 20:11 ilog.map.example
-rwxr-xr-x. 1 tibero dba 1621 Aug 28 11:18 psm_commands
-rw-r--r--. 1 tibero dba  675 Aug 23 01:09 tac.template
-rw-r--r--. 1 tibero dba  694 Aug 28 11:18 tibero.tip
-rw-r--r--. 1 tibero dba  525 Aug 23 01:09 tip.template
-rw-r--r--. 1 tibero dba    4 Aug 25 22:58 variant
[tibero@tibero config]$ 

 

• nomount 모드로 실행후

tbboot nomount
sys / tibero 

 

• 데이터베이스 생성

create database "tibero" 
  user sys identified by tibero 
  maxinstances 8 
  maxdatafiles 100 
  character set MSWIN949 
  national character set UTF16 
  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;

• $TB_HOME/scripts 운영에 필요한 객체를 생성하는 작업

[tibero@tibero scripts]$ sh system.sh
system.sh             system_users_sod.sql  system_users.sql

 

 

tbsql sys / tibero

SQL> select * from dual;

DUMMY
-----
X