[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / êꪤҳàõªòàõªÎÒ¿Ö˪˪·ª¿ð¨ÏÐñ«ëùìíÜâÏÚªÎ?ð¤àõªòÍëãÒªËìãªá¡¢Þóñªª·ªÊª±ªìªÐªÊªéªÊª¤. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [72]
02.File Book
File ÀÚ·á½Ç [96]
Site Link [14]
°³ÀÎÆú´õ [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3207]
PSQL [143]
CUBRID [5]
±âŸÁ¤º¸ [194]
¿î¿µÃ¼Á¦ [634]
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, Á¶È¸ : 26,009


°í°´Áö¿ø - 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.
216.73.216.190


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  error code[-18001] : System call error : 112 (SetEndOfFile())    ÃÖ±æÈ£ 2024/08/27 32
Troubleshoot  ERROR: bind error (port=8200) [Address already in use]    ÃÖ±æÈ£ 2022/02/18 225
Admin  Tibero 5 , SP1, patch, downgrad ¸Þ¸ð    ÃÖ±æÈ£ 2021/02/10 2330
Admin  tibero jdbc driver version È®ÀΠ   ÃÖ±æÈ£ 2021/02/01 603
Admin  rename db name / TB_SID    ÃÖ±æÈ£ 2021/02/01 1004
Troubleshoot  T-UP / SELECT COUNT(*) FROM ALL_TYPES WHERE TYPE_NAME = 'XMLTYPE'    ÃÖ±æÈ£ 2021/02/01 5615
Backup and Recovery  alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N    ÃÖ±æÈ£ 2021/01/29 487
Troubleshoot  interal dd update failed!! [ patch ÇÊ¿ä ]    ÃÖ±æÈ£ 2020/12/20 70550
Backup and Recovery  TBR-1024 : Database needs media recovery    ÃÖ±æÈ£ 2020/12/20 3217
Troubleshoot  * Cannot get semaphore:errno=28    ÃÖ±æÈ£ 2019/03/06 4409
Backup and Recovery  tbexport TBR-90401: JDBC-90401:Connection refused by the server. - Connection refused    ÃÖ±æÈ£ 2019/02/15 3863
Troubleshoot  TBR-8033: Specified schema object was not found.    ÃÖ±æÈ£ 2018/07/11 158054
Admin  tibero6 ¼öµ¿ ¼³Ä¡    ÃÖ±æÈ£ 2018/07/11 26009
Backup and Recovery  TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted    ÃÖ±æÈ£ 2017/11/26 3057
Admin  Tibero SQL Trace [ SQL_TRACE / DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION / SET AUTOTRACE ON / v$sql_plan ]    ÃÖ±æÈ£ 2017/09/06 16281
Admin  Tibero ¸ð´ÏÅ͸µ °¡À̵å - TechNet    ÃÖ±æÈ£ 2017/09/05 16309
Troubleshoot  java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword    ÃÖ±æÈ£ 2016/08/25 3463

    ¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö 1 [2]
       

Copyright 1999-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
ÃÖ±Ù °Ô½Ã¹°
07/03
[ORACLE]
create type ORA-39083 ORA-0230....
by ÃÖ±æÈ£
07/03
[ORACLE]
sms recovery check ORA-00278 ....
by ÃÖ±æÈ£
07/02
[¿î¿µÃ¼Á¦]
rsync -auv.
by ÃÖ±æÈ£