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 ÃÖ±æÈ£