티베로 설치해보자!! 6.0

1. 티베로 설치해보자!! 6.0

2. TbMigrator 설치 및 실행

3. Tibero RDBMS Utility Guide

4. 티베로 초기 설정방법

 

티베로 설치해보자!! 6.0


/*------------------------------*/
/* Linux 환경 확인 및 구성                         */
/*------------------------------*/

** 패키지 설치여부 확인

 

$ rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' \ 
    gcc \ 
    gcc-c++ \ 
    libgcc \ 
    libstdc++ \ 
    libstdc++-devel \ 
    compat-libstdc++ \ 
    libaio \ 
    libaio-devel 

** 패키지 설치

$ yum install -y \ 
    gcc \ 
    gcc-c++ \ 
    libgcc \ 
    libstdc++ \ 
    libstdc++-devel \ 
    compat-libstdc++ \ 
    libaio \ 
    libaio-devel

** 커널 파라미터 확인
$ sysctl -a

** 커널 파라미터 변경하거나 추가함

$ vi /etc/sysctl.conf 
    kernel.shmmni = 4096 
    kernel.shmmax = 4398046511104 
    kernel.shmall = 4294967296 
    kernel.sem = 10000 32000 10000 10000 
    kernel.msgmni = 512 
    kernel.sysrq = 0 
    kernel.core_uses_pid = 1 
    kernel.msgmnb = 65536 
    kernel.msgmax = 65536 
    fs.aio-max-nr = 1048576 
    fs.file-max = 6815744 
    net.ipv4.ip_local_port_range = 1024 65500 
    net.core.rmem_default = 262144 
    net.core.rmem_max = 4194304 
    net.core.wmem_default = 262144 
    net.core.wmem_max = 1048586 

** 커널 파라미터 적용
$ sysctl -p

** 계정 자원제한 설정(아래쪽에 추가함)

$ vi /etc/security/limits.conf 
    * soft nproc 131072 
    * hard nproc 131072 
    * soft nofile 131072 
    * hard nofile 131072 
    * soft core unlimited 
    * hard core unlimited 
    * soft memlock 50000000 
    * hard memlock 50000000 

** 계정 인증 보안 설정(session 항목 첫라인에 추가함)
$ vi /etc/pam.d/login
    session     required    pam_limits.so

** SELinux 설정 해제(변경처리)
$ setenforce 0
$ vi /etc/selinux/config
    SELINUX=disabled


** hostname 확인 및 변경
$ hostname
    localhost.localdomain

$ hostnamectl set-hostname gampol
$ echo gampol > /proc/sys/kernel/hostname
$ hostname
    gampol

/*------------------------------*/
/* Tibero 계정생성                                    */
/*------------------------------*/
$ groupadd dba
$ useradd tibero -g dba -G dba

/*------------------------------*/
/* 환경변수 추가                                       */
/*------------------------------*/
$ su - tibero
[tibero@gampol ~]$ vi .bash_profile
    ### Java Env
    export JAVA_HOME=/usr/local/jdk
    export JDK_HOME=$JAVA_HOME
    export PATH=$JAVA_HOME/bin:$PATH

    ### Tibero Env
    export TB_BASE=/home/tibero
    export TB_HOME=$TB_BASE/tibero6
    export TBGW_HOME=$TB_HOME/client/gateway
    export TB_SID=TDBMS
    export NLS_LANG=KOREAN_KOREA.KO16MSWIN949
    #export NLS_LANG=AMERICAN_AMERICA.UTF8
    #export NLS_LANG=MSWIN949
    export TB_PROF_DIR=$TB_HOME/bin/prof
    export ORACLE_HOME=$TB_HOME/instantclient_11_2
    export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$ORACLE_HOME:$LD_LIBRARY_PATH
    export SHLIB_PATH=$LD_LIBRARY_PATH
    export LIBPATH=$LD_LIBRARY_PATH
    export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$ORACLE_HOME:$PATH


    ### TBinary Env
    export TBINARY_PATH=$TB_BASE/tbinary
    export PATH=$TBINARY_PATH/monitor:$PATH
    export LANG=ko_KR.eucKR

    ### Tibero Alias
    alias tbbase="cd $TB_BASE"
    alias tbhome="cd $TB_HOME"
    alias tbcfg="cd $TB_HOME/config"
    alias tbcli="cd $TB_HOME/client"
    alias tbscr="cd $TB_HOME/scripts"
    alias tbcfgv="vi $TB_HOME/config/$TB_SID.tip"
    alias tbcliv="vi $TB_HOME/client/config/tbdsn.tbr"
    alias tblog="cd $TB_BASE/log/$TB_SID"
    alias tbi='cd $TB_BASE/tbinary/'
    alias tm='cd $TB_BASE/tbinary/monitor;monitor;cd -'

    PS1='\e[0m[\e[1;31m\h\e[0m:\e[1;32m\u\e[0m@\e[1;33m$TB_SID\e[0m:\e[1;32m$NLS_LANG\e[0m \w]\n\$ '



/*------------------------------*/
/* Tibero 설치 작업                                   */
/*------------------------------*/
** 현재위치 확인
[tibero@gampol ~]$ cd $TB_BASE
[tibero@gampol ~]$ pwd
    /home/tibero


** $TB_HOME 압축 풀기
[tibero@gampol ~]$ tar xvzf tibero6-bin-FS06-linux64-152596-opt-20180306165737.tar.gz


** 확인
[tibero@gampol ~]$ ls -l $TB_HOME
    합계 12
    drwxr-xr-x.  3 tibero dba 4096  7월 26 12:54 bin/
    drwxr-xr-x. 10 tibero dba  105  7월 26 12:54 client/
    drwxr-xr-x.  2 tibero dba 4096  7월 26 12:54 config/
    drwxr-xr-x.  3 tibero dba  249   7월 26 12:55 lib/
    drwxr-xr-x.  3 tibero dba   26   7월 26 12:55 license/
    drwxr-xr-x.  3 tibero dba   22   7월 26 12:55 nls/
    drwxr-xr-x.  3 tibero dba 4096  7월 26 12:55 scripts/


** 기본 디렉토리 생성
[tibero@gampol ~]$ mkdir -p $TB_HOME/data/$TB_SID
[tibero@gampol ~]$ mkdir -p $TBGW_HOME


** 초기 환경파일 생성
[tibero@gampol ~]$ cd $TB_HOME/config
[tibero@gampol ~]$ ./gen_tip.sh
    Using TB_SID "TDBMS"
    /home/tibero/tibero6/config/TDBMS.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.


** Tibero 파라미터 수정
[tibero@gampol ~]$ vi $TB_HOME/config/$TB_SID.tip
    DB_NAME=TDBMS
    LISTENER_PORT=8629
    CONTROL_FILES="/home/tibero/tibero6/tbdata/TDBMS/c1.ctl","/home/tibero/tibero6/tbdata/TDBMS/c2.ctl"
    DB_CREATE_FILE_DEST="/data1/tibero6/data/TDBMS"
    #CERTIFICATE_FILE="/home/tibero/tibero6/config/svr_wallet/TDBMS.crt"
    #PRIVKEY_FILE="/home/tibero/tibero6/config/svr_wallet/TDBMS.key"
    #WALLET_FILE="/home/tibero/tibero6/config/svr_wallet/WALLET"
    #ILOG_MAP="/home/tibero/tibero6/config/ilog.map"
    MAX_SESSION_COUNT=200
    TOTAL_SHM_SIZE=4G
    MEMORY_TARGET=8G


[tibero@gampol ~]$ tbboot nomount
      *************************************************************************
      * ERROR: Can't open the license file!!
      * (1) Check the license file - /home/tibero/tibero6/license/license.xml
      *************************************************************************

    (라이선스가 없다면 https://technet.tmaxsoft.com/ 데모라이선스 신청하고 받은 라이선스 파일은 $TB_HOME/license 위치에 복사하도록 한다.)


[tibero@gampol ~]$ tbboot nomount
    Change core dump dir to /home/tibero/tibero6/bin/prof.
    Listener port = 8629

    Tibero 6

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


[tibero@gampol ~]$ tbsql sys/tibero



# 기본 시스템 데이터 베이스 생성(서버 설치 PATH 확인후 실행한다.)
SQL> CREATE DATABASE "TDBMS"
        USER SYS IDENTIFIED BY tibero
        MAXINSTANCES 8
        MAXDATAFILES 100
        CHARACTER SET MSWIN949
        LOGFILE GROUP 1 '/data1/tibero6/data/TDBMS/log001.log' SIZE 500M,
                GROUP 2 '/data1/tibero6/data/TDBMS/log002.log' SIZE 500M,
                GROUP 3 '/data1/tibero6/data/TDBMS/log003.log' SIZE 500M
        MAXLOGGROUPS 255
        MAXLOGMEMBERS 8
        NOARCHIVELOG
               DATAFILE '/data1/tibero6/data/TDBMS/system001.dtf' SIZE 100M  AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED  DEFAULT TEMPORARY TABLESPACE TEMP
               TEMPFILE '/data1/tibero6/data/TDBMS/temp001.dtf'   SIZE 100M  AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL AUTOALLOCATE
        UNDO TABLESPACE UNDO
               DATAFILE '/data1/tibero6/data/TDBMS/undo001.dtf'   SIZE 100M  AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

SQL> exit;

[tibero@gampol ~]$ tbdown
    tbdown failed. proc info file is deleted.
    Hint: Please check if the tbsvr instance was already stopped.

[tibero@gampol ~]$ tbboot
    Change core dump dir to /home/tibero/tibero6/bin/prof.
    Listener port = 8629

    Tibero 6

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



[tibero@gampol ~]$ $TB_HOME/scripts/system.sh
    Enter SYS password:
    tibero

    Enter SYSCAT password:
    syscat

    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...


/*------------------------------*/
/* Tibero 일반 계정 생성                            */
/*------------------------------*/
** 시스템 계정 접속
[tibero@gampol ~]$ tbsql sys/tibero


/* 기존 유저 삭제 */
DROP USER gampol CASCADE;

/* 기존 작업 테이블 스페이스 삭제 */
DROP TABLESPACE ts_gampol INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

/* 테이블 스페이스 생성 */
CREATE TABLESPACE ts_gampol
DATAFILE '/data1/tibero6/data/TDBMS/ts_gampol.dtf' SIZE 500M
AUTOEXTEND ON NEXT 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;


/* 유저 생성 */
CREATE USER gampol IDENTIFIED BY gampol
DEFAULT TABLESPACE ts_gampol
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;

GRANT CONNECT
     ,RESOURCE
     ,SELECT ANY DICTIONARY
     ,SELECT ANY TABLE
     ,ALTER ANY PROCEDURE
     ,ALTER SESSION
     ,CREATE ANY SYNONYM
     ,CREATE VIEW
     ,CREATE DATABASE LINK
     ,CREATE SEQUENCE
     ,CREATE SESSION
     ,CREATE SYNONYM
     ,CREATE TABLE
     ,CREATE ANY TYPE
     ,DELETE ANY TABLE
     ,DROP ANY INDEX
     ,DROP ANY PROCEDURE
     ,DROP ANY SYNONYM
     ,DROP ANY TABLE
     ,DROP ANY TRIGGER
     ,DROP ANY VIEW
     ,DROP ANY TYPE
TO gampol;



/*--------------------------------------*/
/* Oracle Client 설치(최초 설치시)                             */
/*--------------------------------------*/
** Oracle 클라이언트 다운로드
https://www.oracle.com/database/technologies/instant-client/downloads.html

ttp://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html


* 오라클 클라이언트 최소 패키지 설치(오라클 서버나 별도 클라이언트가 설치 되지 않았다면) 
[tibero@gampol ~]$ unzip instantclient-basic-linux.x64-11.2.0.4.0.zip
[tibero@gampol ~]$ mv instantclient_11_2 $TB_HOME
[tibero@gampol ~]$ ls -l $TB_HOME
[tibero@gampol ~]$ mkdir -p $ORACLE_HOME/network/admin
[tibero@gampol ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora
    #---- 테스트 ----#
    TDBMS_10g = (
       DESCRIPTION =
           (ADDRESS = (PROTOCOL = TCP) (HOST = 오라클서버 IP) (PORT = 1521))
           (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl10))
    )



** tbdsn.tbr 추가
[tibero@gampol ~]$ vi $TB_HOME/client/config/tbdsn.tbr
    #---- 테스트 ----#
    TDBMS_10g=(
        (GATEWAY=
            (LISTENER= (HOST=127.0.0.1) (PORT=9999))
            (TARGET=TDBMS_10g)
            (TX_MODE=GLOBAL)
        )
    )



** tbgw.cfg 생성
[tibero@gampol ~]$ vi $TB_HOME/client/config/tbgw.cfg
    LOG_DIR=$TBGW_HOME/oracle/log
    LOG_LVL=2
    LSNR_PORT=9999
    MAX_LOG_SIZE=1000
    MAX_LOG_CNT=5
    FETCH_SIZE=32000




/*--------------------------------*/
/* gw4orcl_XXg  서비스 등록                        */
/*--------------------------------*/
** Gateway 바이러리 복사
[tibero@gampol ~]$ cp $TB_HOME/client/bin/gw4orcl_11g $TBGW_HOME/gw4orcl
[tibero@gampol ~]$ ldd $TBGW_HOME/gw4orcl  (Not found 여부 확인)

[tibero@gampol ~]$ $TBGW_HOME/gw4orcl
[tibero@gampol ~]$ tbsql ssoview/ssolink@SSO
SQL> exit;

[tibero@gampol ~]$ tbsql piview_eval/piview_eval@INSA
SQL> exit;

[tibero@gampol ~]$ tbsql lftpmapp/ghktjd0906@EHOZO
SQL> exit;


** db-link 생성(gampol Tibero 계정 접속)
[tibero@gampol ~]$ tbsql gampol/gampol
SQL> CREATE DATABASE LINK TDBMS_10g CONNECT TO '오라클 계정명'     IDENTIFIED BY '계정 비밀번호'  USING 'TDBMS_10g';
SQL> SELECT COUNT(*) FROM 테스트테이블명@TDBMS_10g ;



/*--------------------------------------------------*/
/* Tibero Java 패키지 생성작업(PSM, PL/SQL)                                 */
/*--------------------------------------------------*/
** 암호화 모듈은 kisa에서 제공하는 lib를 활용하여 별도로 만들었으니
   필요한 java lib를 적용코자 한다면 설치 방법만 참고하시기 바랍니다.

** 자바 lib 저장 디렉토리 생성
[tibero@gampol ~]$ mkdir -p $TB_HOME/instance/$TB_SID/java


** 자바 lib 복사
[tibero@gampol ~]$ cd $TB_HOME/instance/$TB_SID/java
[tibero@gampol ~]$ ls -l

    commons-codec-1.10.jar
    kisaOraLib.jar


** 자바 패키지 적용 환경설정 추가
[tibero@gampol ~]$ vi $TB_HOME/config/$TB_SID.tip
        _PSM_BOOT_JEPA=Y
        JAVA_CLASS_PATH=/home/tibero/tibero6/instance/TDBMS/java


** JEPA 연결정보 추가
[tibero@gampol ~]$ vi $TB_HOME/client/config/tbdsn.tbr
        epa=(
                (
                    EXTPROC=(LANG=JAVA)
                    (
                        LISTENER=(HOST=localhost)
                        (PORT=9390)
                    )
                )
        )



** JEPA 환경설정 수정(기본정보 확인)
[tibero@gampol ~]$ cat $TB_HOME/client/epa/java/config/epa.cfg




** psmjava 클래스패스 추가
[tibero@gampol ~]$ vi $TB_HOME/bin/psmjavac
    codec=$TB_HOME/instance/TDBMS/java/commons-codec-1.10.jar
    kisa=$TB_HOME/instance/TDBMS/java/kisaOraLib.jar

    .......:${codec}:${kisa}:${classpath} ${src}


** tbjavaepa 클래스패스 추가
[tibero@gampol ~]$ vi $TB_HOME/client/bin/tbjavaepa
        :
    codec=$TB_HOME/instance/TDBMS/java/commons-codec-1.10.jar
    kisa=$TB_HOME/instance/TDBMS/java/kisaOraLib.jar
        :
    echo "....:$config:$codec:$kisa $mainclass ...."
        :
    echo "....:$config:$codec:$kisa $mainclass ...."



* 패키지 생성 및 테스트
    CREATE OR REPLACE PACKAGE crypto
        AS
            FUNCTION encrypt(str VARCHAR2) RETURN VARCHAR2;
            FUNCTION decrypt(str VARCHAR2) RETURN VARCHAR2;
            FUNCTION sha256(str  VARCHAR2) RETURN VARCHAR2;
        END;
        /

    CREATE OR REPLACE PACKAGE BODY crypto
        AS
            FUNCTION encrypt(str VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'kr.re.nsr.cbc.SeedCBC.encrypt(java.lang.String) return java.lang.String';
            FUNCTION decrypt(str VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'kr.re.nsr.cbc.SeedCBC.decrypt(java.lang.String) return java.lang.String';
            FUNCTION sha256(str  VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'kr.re.nsr.sha.SHA256.encrypt(java.lang.String) return java.lang.String';
        END;
        /

    SELECT crypto.encrypt('암호화 테스트!!') "TestEnc"
              ,crypto.decrypt('8mVH5wJNP9FHE0AmWsgkVQ==') "TestDec"
              ,crypto.sha256('암호화 테스트!!') "TestSHA256"
    FROM DUAL;

 

 

 

1. 티베로 설치해보자!! 6.0

2. TbMigrator 설치 및 실행

3. Tibero RDBMS Utility Guide

4. 티베로 초기 설정방법

 

티베로 초기 설정방법

출처 : 발췌글: https://gampol.tistory.com/entry/Tibero-6-설치!Oracle-DBLink-Java-모듈-적용 [유효하지 않네]