http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
기타정보 [150]
운영체제 [577]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: Tibero

 회원가입

tibero6 수동 설치
최길호 [LIST]   2018-07-11 15:03:23, 조회 : 25,031


고객지원 - 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.
3.235.78.122


  LIST

제목 작성자 작성일 조회
Troubleshoot  ERROR: bind error (port=8200) [Address already in use]    최길호 2022/02/18 85
Admin  Tibero 5 , SP1, patch, downgrad 메모    최길호 2021/02/10 1635
Admin  tibero jdbc driver version 확인    최길호 2021/02/01 327
Admin  rename db name / TB_SID    최길호 2021/02/01 279
Troubleshoot  T-UP / SELECT COUNT(*) FROM ALL_TYPES WHERE TYPE_NAME = 'XMLTYPE'    최길호 2021/02/01 4941
Backup and Recovery  alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N    최길호 2021/01/29 263
Troubleshoot  interal dd update failed!! [ patch 필요 ]    최길호 2020/12/20 40903
Backup and Recovery  TBR-1024 : Database needs media recovery    최길호 2020/12/20 2303
Troubleshoot  * Cannot get semaphore:errno=28    최길호 2019/03/06 3926
Backup and Recovery  tbexport TBR-90401: JDBC-90401:Connection refused by the server. - Connection refused    최길호 2019/02/15 3311
Troubleshoot  TBR-8033: Specified schema object was not found.    최길호 2018/07/11 107172
Admin  tibero6 수동 설치    최길호 2018/07/11 25031
Backup and Recovery  TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted    최길호 2017/11/26 2622
Admin  Tibero SQL Trace [ SQL_TRACE / DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION / SET AUTOTRACE ON / v$sql_plan ]    최길호 2017/09/06 15926
Admin  Tibero 모니터링 가이드 - TechNet    최길호 2017/09/05 16103
Troubleshoot  java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword    최길호 2016/08/25 3206
Troubleshoot  Oracle dblink Tibero UTF8 DB 한글처리    최길호 2015/09/08 10570

    목록보기   다음페이지 1 [2]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호