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

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [43]
DB2 [79]
ORACLE [2973]
PSQL [133]
기타정보 [155]
운영체제 [600]
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,930


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


  LIST

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

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

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
09/27
[ORACLE]
auto compile [ dba_objects LAS....
by 최길호
09/25
[ORACLE]
verify_queryable_inventory ret....
by 최길호
09/11
[운영체제]
ntfy.sh / 푸시 알림 보내기.
by 최길호