centos7 tibero maneual install

 

 

 

 

 

 

1. 필요패키지  설치

gcc-3.4.6-11
gcc-c++-3.4.6-11
libgcc-3.4.6-11
libstdc++-3.4.6-11
libstdc++-devel-3.4.6-11
compat-libstdc++-33-3.2.3-47.3
libaio-0.3.105-2
libaio-devel-0.3.105-2

 

 

2. 서버 환경설정(sysctl.conf 및 limits.conf)

# vi /etc/sysctl.conf

kernel.shmmni = 4096
#kernel.shmall = ceil(shmmax/PAGE_SIZE) : 2147483648/1024
kernel.shmall = 2097152
#kernel.shmmax = 물리적인 메모리의 절반(현재 4G)
kernel.shmmax = 2147483648
kernel.sem = 10000 32000 10000 10000

fs.file-max = 6815744

net.ipv4.ip_local_port_range = 1024 65500

# vi /etc/security/limits.conf

#setting for tibero
tibero           soft    nproc           2047
tibero           hard    nproc           16384
tibero           soft    nofile          1024
tibero           hard    nofile          65536

# vi /etc/sysyemd/logind.conf

RemoveIPC=no

# systemctl daemon-reload

# systemctl restart systemd-logind

RHEL 7.2이상버전의 DB시스템에서는 반드시 설정이 필요

bugzilla.redhat.com/show_bug.cgi?id=1287618

1287618 – Wrong definition of default value in man page logind.conf

bugzilla.redhat.com/show_bug.cgi?id=1264533

1264533 – Oracle Grid 12c Failed to stat() POSIX shared memory segment

수정후 재시작

 

 

3. 계정 추가(tibero)

# useradd tibero

 

4. tibero 다운로드 후 압축풀기

# cd ~tibero

# tar -xvzf tibero6-bin-FS07_CS_2005-linux64-186930-opt-tested.tar.gz

 

5. 환경변수 추가(/etc/profile)

# vi /etc/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 /etc/profile

 

6. 발급된 라이센스 파일 복사

# cp license.xml $TB_HOME/license

 

7. 설치

# cd $TB_HOME/config

# ./gen_tip.sh 
Using TB_SID "tibero"
/home/tibero/tibero6/config/tibero.tip generated
/home/tibero/tibero6/config/psm_commands generated
/home/tibero/tibero6/client/config/tbdsn.tbr generated.
Running client/config/gen_esql_cfg.sh
Done.

 

8. NOMOUNT모드 기동

# tbboot nomount
Listener port = 8629

Tibero 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NOMOUNT mode).

 

 

9. database생성(tibero)

SQL> create database "tibero"
   2 user sys identified by tibero 
   3   maxinstances 8 
   4   maxdatafiles 100 
   5   character set MSWIN949 
   6   national character set UTF16 
   7   logfile 
   8     group 1 'log001.log' size 100M, 
   9     group 2 'log002.log' size 100M, 
  10     group 3 'log003.log' size 100M 
  11   maxloggroups 255 
  12   maxlogmembers 8 
  13   noarchivelog 
  14     datafile 'system001.dtf' size 100M autoextend on next 100M maxsize unlimited 
  15     default temporary tablespace TEMP 
  16       tempfile 'temp001.dtf' size 100M autoextend on next 100M maxsize unlimited 
  17       extent management local autoallocate 
  18     undo tablespace UNDO 
  19       datafile 'undo001.dtf' size 100M autoextend on next 100M maxsize unlimited 
  20       extent management local autoallocate;

Database created.

 

10. tibero기동

# tbboot 
Listener port = 8629

Tibero 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).

 

11. system.sh 실행

# ./system.sh 
Enter SYS password: 

Enter SYSCAT password: 

Dropping agent table...
Creating text packages table ...
Creating the role DBA...
Create default system users & roles?(Y/N): 
y

Creating system users & roles...
Creating example users...
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 tables related to dbms_job...
Creating system tables related to dbms_lock...
Creating system tables related to scheduler...
Creating system tables related to server_alert...
Creating system tables related to tpm...
Creating system tables related to tsn and timestamp...
Creating system tables related to rsrc...
Creating system tables related to workspacemanager...
Creating system tables related to statistics...
Creating system tables related to mview...
Create system tables related to crypto_system...
Creating system package specifications:
    Running /home/tibero/tibero6/scripts/pkg/pkg_standard.sql...
    Running /home/tibero/tibero6/scripts/pkg/pkg_standard_extension.sql...
   중간 생략..
Creating auxiliary tables used in static views...
Create system tables related to profile?(Y/N): 
y

Creating system tables related to profile...
Creating internal system tables...
Check TPR status..
Stop TPR
Create TPR tables?(Y/N): 
y

Dropping tables used in TPR...
Creating auxiliary tables used in TPR...
Creating static views...
Creating static view descriptions...
Creating objects for sph:
    Running /home/tibero/tibero6/scripts/iparam_desc_gen.sql...
Creating dynamic performance views...
Creating dynamic performance view descriptions...
Creating package bodies:
    Running /home/tibero/tibero6/scripts/pkg/_pkg_db2_standard.tbw...
    Running /home/tibero/tibero6/scripts/pkg/_pkg_dbms_aq.tbw...
    중간 생략..
Creating public synonyms for system packages...
Creating remaining public synonyms for system packages...
Register dbms_stats job to Job Scheduler?(Y/N):
y

Registering dbms_stats job to Job Scheduler...
Creating audit event pacakge...
    Running /home/tibero/tibero6/scripts/pkg/_pkg_dbms_audit_event.tbw...
Creating packages for TPR...
    Running /home/tibero/tibero6/scripts/pkg/pkg_dbms_tpr.sql...
    Running /home/tibero/tibero6/scripts/pkg/_pkg_dbms_tpr.tbw...
    Running /home/tibero/tibero6/scripts/pkg/_pkg_dbms_apm.tbw...
Start TPR
Create tudi interface
    Running /home/tibero/tibero6/scripts/odci.sql...
Creating spatial meta tables and views ...
Creating internal system jobs...
Creating Japanese Lexer epa source ...
Creating internal system notice queue ...
Creating sql translator profiles ...
Creating agent table...
Done.
For details, check /home/tibero/tibero6/instance/tibero/log/system_init.log.

 

12. 프로세스 확인

# ps -ef | grep tbsvr
root      4467     1  0 14:41 pts/0    00:00:01 tbsvr          -t NORMAL -SVR_SID tibero
root      4469  4467  0 14:41 pts/0    00:00:00 tbsvr_MGWP     -t NORMAL -SVR_SID tibero
root      4470  4467 13 14:41 pts/0    00:00:55 tbsvr_FGWP000  -t NORMAL -SVR_SID tibero
root      4471  4467  0 14:41 pts/0    00:00:00 tbsvr_FGWP001  -t NORMAL -SVR_SID tibero
root      4472  4467  0 14:41 pts/0    00:00:00 tbsvr_PEWP000  -t NORMAL -SVR_SID tibero
root      4473  4467  0 14:41 pts/0    00:00:00 tbsvr_PEWP001  -t NORMAL -SVR_SID tibero
root      4474  4467  0 14:41 pts/0    00:00:00 tbsvr_PEWP002  -t NORMAL -SVR_SID tibero
root      4475  4467  0 14:41 pts/0    00:00:00 tbsvr_PEWP003  -t NORMAL -SVR_SID tibero
root      4476  4467  0 14:41 pts/0    00:00:00 tbsvr_AGNT     -t NORMAL -SVR_SID tibero
root      4477  4467  0 14:41 pts/0    00:00:02 tbsvr_DBWR     -t NORMAL -SVR_SID tibero
root      4478  4467  0 14:41 pts/0    00:00:00 tbsvr_RCWP     -t NORMAL -SVR_SID tibero

 

 

참고 : technet.tmaxsoft.com/ko/front/download/viewDownloadManual.do?cmProductCode=0301&version_seq=PVER-20150504-000001&doc_type_cd=MN#

Message