개발자의 끄적끄적

[sql] Tibero6 티베로6 수동설치 [펌] 본문

개발/sql

[sql] Tibero6 티베로6 수동설치 [펌]

효벨 2019. 11. 21. 02:00
728x90
반응형

[sql] Tibero6 티베로6 수동설치 [펌]

 

Tibero6 티베로6 버전 수동 설치를 해야되서

 

검색던중 참고할만한 자료라 퍼왔습니다!

 

출처는 맨아래 명시 했습니다!!

 


고객지원 - tibero - 온라인매뉴얼
https://technet.tmaxsoft.com/upload/download/online/tibero/pver-20150504-000001/index.html


tibero 6
수동 설치 [ 3.3.2. UNIX 환경 ]

바이너리 실행 파일(tar.gz)
라이선스 파일(license.xml)

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
alias th='cd $TB_HOME'
alias sql='tbsql sys/tibero'

cat > $TB_HOME/license/license.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<tmax_license>
        <license version="1.0">
                <product version="6">Tibero</product>
                <serial_ID>1531286864</serial_ID>
                <issue_date>2018/07/11</issue_date>
                <licensee>xx123xx</licensee>
                <edition>enterprise</edition>
                <type>demo</type>
                <demo_duration>184</demo_duration>
                <identified_by_host>xx123xx</identified_by_host>
                <signature>orzsdpY1eUEr4RE2fKh5FI/uLf/bQ6WxuVHzJwQetUI=</signature>
        </license>
</tmax_license>

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.

tbboot nomount
=> Tibero instance started up (NOMOUNT mode).
tbsql sys/tibero
SQL>
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;
SQL> quit

tbboot
=> Tibero instance started up (NORMAL mode).
$TB_HOME/scripts/system.sh
== 암호 입력 및 Y/N
Enter SYS password:
Enter SYSCAT password:
Create default system users & roles?(Y/N):
Create system tables related to profile?(Y/N):
Create TPR tables?(Y/N):
Register dbms_stats job to Job Scheduler?(Y/N):


SQL> show parameter db_cr

NAME                         TYPE     VALUE                                  
---------------------------- -------- ----------------------------------------
DB_CREATE_FILE_DEST          DIRNAME  /home/tibero/tibero6/database/tibero/

SQL> select * from v$dbfile;
     FILE# NAME                                                        
---------- ------------------------------------------------------------
         0 /home/tibero/tibero6/database/tibero/system001.dtf
         1 /home/tibero/tibero6/database/tibero/undo001.dtf
         2 /home/tibero/tibero6/database/tibero/usr001.dtf
         3 /home/tibero/tibero6/database/tibero/tpr_ts.dtf

4 rows selected.

 

출처 : http://iotn.co.kr/power/zboard.php?tab_num=3&id=9_7_tibero&page=1&sn1=&divpage=1&sn=off&ss=on&sc=off&select_arrange=headnum&desc=asc&no=17

반응형
저작자표시 비영리 변경금지

'개발 > sql' 카테고리의 다른 글

[sql] sqlgate tibero 22003 error 해결방법  (0) 2019.11.22
[sql] Oracle 테이블 생성 및 코멘트 삽입예제 [펌]  (0) 2019.11.22
[sql] mssql alter table 방법  (0) 2019.11.19
[sql] MariaDB 데이터베이스 생성, 계정생성, 권한 주기 [펌]  (0) 2019.11.18
[sql] MSSQL NULL값 체크 (ISNULL) 함수 사용법 & 예제  (0) 2019.11.16
'개발/sql' Related Articles more
Comments