Tibero 5 설치 가이드

개발 환경 

OS : CentOS release 6.5

JDK : OpenJDK Runtime Environment (rhel-2.4.7.1.el6_5-x86_64 u55-b13)

Tibero : Tibero_5_SP1

Step1. 라이센스 신청 및 다운로드

일단 tibero 공식사이트에서 데모 license신청 및 다운로드를 진행 해야 합니다.

http://technet.tmaxsoft.com/ko/front/main/main.do

신청 후 license.xml 파일 및 파일을 다운받습니다.

[tibero@juno ~]$ ./Tibero_5_SP1_S1427_Linux_x86_64.bin

Please wait a moment...

======================================================

Introduction

--------------------------

Tibero Installer will guide you through the installation of Tibero 5 SP1.

It is strongly recommended that you quit all programs before

continuing with this installation.

Respond to each prompt to proceed to the next step in the

installation.

You may cancel this installation at any time by typing

'quit'. PRESS <ENTER> TO CONTINUE:

======================================================

Choose Install Folder

--------------------------

Please specify a base location for Tibero to be installed.

Tibero will be installed under TB_HOME directory.

-> Default Install Path: /home/tibero/Tibero/tibero5

   ( TB_HOME : /home/tibero/Tibero/tibero5 )

ENTER AN ABSOLUTE PATH,

OR PRESS <ENTER> TO ACCEPT THE DEFAULT :

======================================================

SID

---------------------------

Each instance is uniquely identified by SID,

and the database is references by the instance.

TB SID (DEFAULT: tibero):

======================================================

Select Installation Type

--------------------------

Please select the Installation Type to install.

->      1- Typical <default>

        2- Custom

ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS

<ENTER> TO ACCEPT THE DEFAULT :

======================================================

Character Set Configuration

--------------------------

Please select the default character set.

1. MSWIN949 <Default>

2. UTF8

3. ASCII

4. EUC-KR

5. SHIFT-JIS

6. JA16SJIS

7. JA16SJISTILDE

8. JA16EUC

9. JA16EUCTILDE

10. VN8VN3

11. CL8MSWIN1251

12. WE8MSWIN1252

13. WE8ISO8859P1

14. EE8ISO8859P2

15. WE8ISO8859P9

16. WE8ISO8859P15

17. ZHT16HKSCS

>2

======================================================

TB_NSL_LANG Character Set Configuration

--------------------------

Please select the default TB_NLS_LANG character set.

0. Noting<Default>

1. MSWIN949

2. UTF8

3. ASCII

4. EUC-KR

5. SHIFT-JIS

6. JA16SJIS

7. JA16SJISTILDE

8. JA16EUC

9. JA16EUCTILDE

10. VN8VN3

11. CL8MSWIN1251

12. WE8MSWIN1252

13. WE8ISO8859P1

14. EE8ISO8859P2

15. WE8ISO8859P9

16. WE8ISO8859P15

17. ZHT16HKSCS

>2

======================================================

Account Configuration

--------------------------

Please set the password for Administrator Accounts.

Sys password :

Confirm Sys password :

Do you want to use the Sys password for Syscat, Tibero and Tibero1?(y/n) y

======================================================

Pre-Installation Summary

-------------------------

Please Review the Following Information Before Continuing.

Product Name                        : Tibero 5 SP1

TB_HOME                             : /home/tibero/Tibero/tibero5

TB_SID                              : tibero

Install Folder                      : /home/tibero/Tibero/tibero5

Install Set                         : Typical(Tibero 5 SP1, tbAdmin, help files)

Listener Port                       : 8629

DATA FILE PATH                      : /home/tibero/Tibero/tibero5/database/tibero

Character Set                       : UTF8

TB_NSL_LANG                         : UTF8

Is this information correct?(y/n) y

======================================================

Installing Tibero 5 SP1

--------------------------

(100) Tibero 5 SP1 uncompressed completely

(100) tbAdmin uncompressed completely

(100) Help files uncompressed completely

0         50        100 (%)

|========= |========= |

Installation completed

Step3. DB 생성

DB 생성을 위해 control file과 db create file을 별도의 tbdata라는 디렉토리로 설정하는 것이 좋다.

tip파일에서 경로 수정이 가능하다.

/Tibero/tibero5/config/tibero.tip

DB_NAME=tibero

LISTENER_PORT=8629

MAX_SESSION_COUNT=20

TOTAL_SHM_SIZE=512M

MEMORY_TARGET=1G

CONTROL_FILES="/home/tibero/tbdata/c1.ctl"

DB_CREATE_FILE_DEST="/home/tibero/tbdata"

DB_BLOCK_SIZE=8K

Tip파일 설정 후 cre_db.sql 파일을 생성한다.

cre_db.sql

CREATE DATABASE "tibero"

USER SYS IDENTIFIED BY TIBERO

MAXDATAFILES 4096

CHARACTER SET UTF8

LOGFILE GROUP 0 ('redo01.redo') SIZE 50M,

GROUP 1 ('redo11.redo') SIZE 50M,

GROUP 2 ('redo21.redo') SIZE 50M

MAXLOGFILES 100

MAXLOGMEMBERS 8

NOARCHIVELOG

DATAFILE 'system001.dtf' SIZE 256M

AUTOEXTEND ON NEXT 16M MAXSIZE 3072M

DEFAULT TABLESPACE USR

DATAFILE 'usr001.dtf' SIZE 128M

AUTOEXTEND ON NEXT 16M MAXSIZE 3072M

DEFAULT TEMPORARY TABLESPACE TEMP

TEMPFILE 'temp001.dtf' SIZE 512M

AUTOEXTEND ON NEXT 16M MAXSIZE 10240M

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

UNDO TABLESPACE UNDO

DATAFILE 'undo001.dtf' SIZE 512M

AUTOEXTEND ON NEXT 16M MAXSIZE 10240M

EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

준비가 되었다면 DB에 접속하여 tibero DB를 생성한다.

$ tbsql sys/tibero

tbsql sys/tibero

tbSQL 5 SP1

TmaxData Corporation Copyright (c) 2008-. All rights reserved.

Connected to Tibero.

SQL> @cre_db

Database created.

File finished.

$ cd ~/tibero5/scripts

$ ./system.sh

Enter SYS password:

Enter SYSCAT password:

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

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_utility.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_obfuscation.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_transaction.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_space_admin.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_space.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_random.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_lock.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_system.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_job.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_raw.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_i18n.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_file.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_str.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_tb_utility.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_rowid.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_repair.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_application_info.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_java.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_encode.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_url.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_http_internal.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_http.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_utl_tcp.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_session.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_crypto.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_tool_utility.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_psm_sql_result_cache.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_htp.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_htf.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_result_cache.sql...

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_flashback.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 system tables related to statistics...

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

    Running /home/tibero/Tibero/tibero5/scripts/pkg/pkg_dbms_xplan.sql...

Creating spatial meta tables and views ...

Creating internal system tables...

Done.

For details, check /home/tibero/Tibero/tibero5/instance/tibero/log/system_init.log.

테이블 생성 확인.

$ tbsql sys/TIBERO

tbSQL 5 SP1

TmaxData Corporation Copyright (c) 2008-. All rights reserved.

Connected to Tibero.

SQL> LS

NAME                               SUBNAME                  OBJECT_TYPE

---------------------------------- ------------------------ --------------------

APM_REPORT_DIR                                              DIRECTORY

APM_TIP_DIR                                                 DIRECTORY

NULL_VERIFY_FUNCTION                                        FUNCTION

VERIFY_FUNCTION                                             FUNCTION

_GET_PART_BOUND_STR                                         FUNCTION

DRC$IDX_KEY                                                 INDEX

.

.

.

설치가 완료 되었습니다.

자세한 내용은 첨부파일을 참고 하시기 바랍니다. ( 다른 OS 설치 방법도 나와있음 )

TINP003_INSTALL_2.1.1.pdf

Tibero 5 설치 가이드.

Tibero 5 Administrator's Guide_v2.1.4.pdf

Tibero 5 관리 가이드.