기술문서 tibero 7 install for linux

2023.11.06 16:44

구피천사 조회 수:19

티맥스 테크넷 사이트에서 아래 설치파일을 다운 받아서 올린다

수동 설치 기준입니다.

티베로 계정을 추가하고

아래와 같이 환경변수를 추가 합니다.

[root@guppy ~]# adduser tibero

[root@guppy ~]# su - tibero

[tibero@guppy:/home/tibero]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

stty erase

### User ENV ###

export PS1="[`whoami`@`hostname`:\$PWD]$ "

### JAVA ENV

export JAVA_HOME=/home/java

export JDK_HOME=$JAVA_HOME

export PATH=$JAVA_HOME/bin:$PATH

### TIBERO ENV

#export TB_BASE=/tibero/examples

#export TB_HOME=$TB_BASE/tibero6

export TB_BASE=/tibero7

export TB_HOME=/tibero7

export TB_SID=tibero

export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib

export SHLIB_PATH=$LD_LIBRARY_PATH

export LIBPATH=$LD_LIBRARY_PATH

export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH

export TB_PROF_DIR=$TB_HOME/bin/prof

### TBINARY ENV

export TBINARY_PATH=$TB_BASE/tbinary

export PATH=$TBINARY_PATH/monitor:$PATH

### TIBERO Alias

alias tbbase="cd $TB_BASE"

alias tbhome="cd $TB_HOME"

alias tbcfg="cd $TB_HOME/config"

alias tbcli="cd $TB_HOME/client"

alias tbscr="cd $TB_HOME/scripts"

alias tbcfgv="vi $TB_HOME/config/$TB_SID.tip"

alias tbcliv="vi $TB_HOME/client/config/tbdsn.tbr"

alias tblog="cd $TB_BASE/log/$TB_SID"

alias tbi='cd $TB_BASE/tbinary/'

alias tm='cd $TB_BASE/tbinary/monitor;monitor;cd -'

alias tbsql='rlwrap tbsql'

[tibero@guppy:/home/tibero]$

설치 파일이 아닌 압축된 수동설치본을 받아서 압축을 풀기 합니다

[root@guppy ~]# tar zxvf tibero7-bin-FS02-linux64_3.10-258363-20230223192334.tar.gz

[root@guppy ~]# mv tibero7 /

[root@guppy ~]#

아래 hostname 기준으로 사이트에서 데모 라이센스를 신청해서 서버에 올려 놓습니다.

[root@guppy ~]# hostname

guppy

[root@guppy ~]#

[root@guppy ~]# cd /tibero7/bin

[root@guppy bin]# ls

alterdd.sh cm_res_exec.sh internal_svr_env.sh sm_sysmon_network_io.sh svr_rename.sh tbboot tbctl

asboot cmrctl psmjavac sm_sysmon_network_state.sh sysalloc_summary.sh tbcm tbdown

asdown crfconf sm_sysmon_disk_io.sh sm_sysmon_ps.sh tb_cert_manager tbcmbin tbinfo

base_env.sh dbctl_for_cm.sh sm_sysmon_disk_state.sh svr_env.sh tb_create_db.sh tbcmobs tbiv

[root@guppy bin]# ./tbinfo

IPADDR : 192.168.219.70

HOSTNAME : guppy

HOSTID : 0xc50fad8e

NCPU : 4

UNAME : Linux guppy 4.18.0-305.el8.x86_64 #1 SMP Thu Apr 29 08:54:30 EDT 2021 x86_64

[root@guppy bin]# cd ../

[root@guppy tibero7]# ls

bin client config lib license nls scripts

[root@guppy tibero7]# cd license/

[root@guppy license]# ls

oss_licenses

[root@guppy license]# cp /root/tibero/license.xml ./

[root@guppy license]#

[root@guppy license]# ls

license.xml oss_licenses

[root@guppy license]# ls -la

합계 4

drwxr-xr-x 3 tibero tibero 45 11월 6 04:44 .

drwxr-xr-x 9 tibero tibero 97 11월 6 02:13 ..

-rw-r--r-- 1 root root 475 11월 6 04:44 license.xml

drwxr-xr-x 2 tibero tibero 171 11월 6 02:13 oss_licenses

[root@guppy license]# su - tibero

[tibero@guppy:/home/tibero]$

[tibero@guppy:/home/tibero]$ cd /tibero7

[tibero@guppy:/tibero7]$ ls

bin client config lib license nls scripts

[tibero@guppy:/tibero7]$ cd bin

[tibero@guppy:/tibero7/bin]$ ls

alterdd.sh cm_res_exec.sh internal_svr_env.sh sm_sysmon_network_io.sh svr_rename.sh tbboot tbctl

asboot cmrctl psmjavac sm_sysmon_network_state.sh sysalloc_summary.sh tbcm tbdown

asdown crfconf sm_sysmon_disk_io.sh sm_sysmon_ps.sh tb_cert_manager tbcmbin tbinfo

base_env.sh dbctl_for_cm.sh sm_sysmon_disk_state.sh svr_env.sh tb_create_db.sh tbcmobs tbiv

[tibero@guppy:/tibero7/bin]$ cd /tibero7/

[tibero@guppy:/tibero7]$ ls

bin client config lib license nls scripts

[tibero@guppy:/tibero7]$ cd config

[tibero@guppy:/tibero7/config]$ ls

cm.template gen_tip.sh gen_tip_for_tac.sh ilog.map.example tac.template tibero.template tip_jenkins.

gen_psm_cmd.sh gen_tip_for_ssvr.sh gen_tip_for_zeta.sh ssvr.template tas.template tip.template variant

[tibero@guppy:/tibero7/config]$ cat gen_tip.sh

#!/bin/sh

# TIP file generation for server, client

. base_env.sh

prog=`basename $0`

usage="\

Usage: $prog [-t template_file_name] [-s <SID>] [-c control_file_path1,...]

If SID is not given, Environment variable $svr_sid is used.

Control files example)

-c '\"/tibero/database/tibero/c1.ctl\",\"/tibero/database/tibero/c2.ctl\",\"/tibero/database/tibero/c3.ctl\"'

template=tip.template

# processing options

while [ -n "$1" ]; do

case "$1" in

-t)

if test -z "$2"

then

echo "Template file is not specified." >&2

echo "$usage" >&2

exit 1

template=$2

shift

;;

-s)

if test -z "$2"

then

echo "SID is not specified." >&2

echo "$usage" >&2

exit 1

SID=$2

shift

;;

-c)

ctrl_file_paths=$2

shift

;;

echo "Invalid option: $1" >&2

echo "$usage" >&2

exit 1

;;

esac

shift

done

# svr_home must be set

if [ -z "$svr_home" ]

then

echo "Environment variable $svr_home_name must be set." >&2

exit 1

# check sid argument

if [ ! -n "$SID" ] ;

then

if test -n "$svr_sid"; then

echo "Using $svr_sid_name \"$svr_sid\"" >&2

SID=$svr_sid

else

echo "Neither of argument SID or environment variable $svr_sid_name is set." >&2

echo "$usage" >&2

exit 1

tip_file=$svr_home/config/$SID.tip

tip_template=$svr_home/config/$template

if [ ! -f "$tip_template" ];then

echo "Cannot find tip template file $tip_template." >&2

exit 1

# already exists?

is_tip_file=no

if test -f $tip_file ; then

echo "There's already ${tip_file}!! Nothing has changed!!" >&2

is_tip_file=yes

hostname=`hostname`

if [ "$test_listener_port" != "" ]; then

LISTENER_PORT=$test_listener_port

else

LISTENER_PORT=8629

if [ $is_tip_file = "no" ]; then

sed_pattern=""

sed_pattern=$sed_pattern" -e s/@SEM_KEY@/"$SEM_KEY"/g"

sed_pattern=$sed_pattern" -e s/@SID@/"$SID"/g"

sed_pattern=$sed_pattern" -e s/@HOME@/`echo $svr_home | sed 's|\/|\\\/|g'`/g"

if test -d $svr_home/src -a -z "$test_listener_port" ; then

sed_pattern=$sed_pattern" -e s/^LISTENER_PORT/#LISTENER_PORT/"

else

sed_pattern=$sed_pattern" -e s/@PORT@/$LISTENER_PORT/"

#generate tip

echo "# tip file generated from $tip_template (`date`)" > $tip_file

if [ -z "$ctrl_file_paths" ]; then

sed_pattern=$sed_pattern" -e s/^#CONTROL_FILES/CONTROL_FILES/"

sed $sed_pattern $tip_template >> $tip_file

if [ ! -z "$ctrl_file_paths" ]; then

echo CONTROL_FILES=$ctrl_file_paths >> $tip_file

echo "$tip_file generated"

# psm compile command configuration file generation

$svr_home/config/gen_psm_cmd.sh

# client configuration file generation

if [ ! -d $svr_home/client/config ]; then

echo "Cannot find directory $svr_home/client/config." >&2

exit 1

client_config_file=$svr_home/client/config/${default_prefix}dsn.tbr

if [ -f $client_config_file ]; then

echo "There's already ${client_config_file}!!" >&2

is_duplicated_sid=no

if ( grep "$SID=" $client_config_file >/dev/null 2>&1 ); then

is_duplicated_sid=yes

echo "Client config file already contains SID \"$SID\":" >&2

echo " please check if port number equals $LISTENER_PORT..." >&2

if [ $is_duplicated_sid = "yes" ]; then

cat $client_config_file | sed -e 's/^/> /' >&2

else

cat >>$client_config_file <<EOF

#-------------------------------------------------

# Appended by gen_tip.sh at `date`

$SID=(

(INSTANCE=(HOST=localhost)

EOF

if [ -f $svr_home/src/Jamrules -a -z "$test_listener_port" ]; then :;

else

echo " (PORT=$LISTENER_PORT)" >>$client_config_file;

cat >>$client_config_file <<EOF

(DB_NAME=$SID)

)

EOF

echo "Added $SID to $client_config_file." >&2

else

cat >>$client_config_file <<EOF

#-------------------------------------------------

# $client_config_file

# Network Configuration File.

# Generated by gen_tip.sh at `date`

$SID=(

(INSTANCE=(HOST=localhost)

EOF

if [ -f $svr_home/src/Jamrules -a -z "$test_listener_port" ]; then :;

else

echo " (PORT=$LISTENER_PORT)" >>$client_config_file;

cat >>$client_config_file <<EOF

(DB_NAME=$SID)

)

EOF

echo "$client_config_file generated." >&2

# gen_esql_cfg.sh execute

gen_esql_cfg_file=$svr_home/client/config/gen_esql_cfg.sh

if [ -f $gen_esql_cfg_file ]; then

echo "Running client/config/gen_esql_cfg.sh"

$gen_esql_cfg_file

팁 파일을 생성해 주는 스크립트 입니다.

그냥 실행만 해주면 됩니다.

[tibero@guppy:/tibero7/config]$

[tibero@guppy:/tibero7/config]$ ./gen_tip.sh

Using TB_SID "tibero"

/tibero7/config/tibero.tip generated

/tibero7/config/psm_commands generated

/tibero7/client/config/tbdsn.tbr generated.

Running client/config/gen_esql_cfg.sh

Done.

[tibero@guppy:/tibero7/config]$

[tibero@guppy:/tibero7/config]$ ls

cm.template gen_tip.sh gen_tip_for_tac.sh ilog.map.example ssvr.template tas.template tibero.tip

gen_psm_cmd.sh gen_tip_for_ssvr.sh gen_tip_for_zeta.sh psm_commands tac.template tibero.template tip.templat

[tibero@guppy:/tibero7/config]$ cd ../

[tibero@guppy:/tibero7]$ ls

bin client config lib license nls scripts

[tibero@guppy:/tibero7]$ cd bin

[tibero@guppy:/tibero7/bin]$ ls

alterdd.sh cm_res_exec.sh internal_svr_env.sh sm_sysmon_network_io.sh svr_rename.sh tbboot tbctl

asboot cmrctl psmjavac sm_sysmon_network_state.sh sysalloc_summary.sh tbcm tbdown

asdown crfconf sm_sysmon_disk_io.sh sm_sysmon_ps.sh tb_cert_manager tbcmbin tbinfo

base_env.sh dbctl_for_cm.sh sm_sysmon_disk_state.sh svr_env.sh tb_create_db.sh tbcmobs tbiv

티베로 그냥 기동을 해봤는데 콘트롤 파일이 없다고 실행이 안됩니다.

디비는 노마운트 모드로 올라 갑니다.

오픈이 안되는거죠

[tibero@guppy:/tibero7/bin]$ ./tbboot

Warning: The initialization parameter 'MEMORY_TARGET' value is greater than the physical system memory size. MEMORY_TARemory Size: 3350556672Excessive memory consumption may cause the system to slow down or malfunction. It is recommended ue less than the physical system memory size.

Change core dump dir to /tibero7/bin/prof.

Listener port = 8629

********************************************************

* Warning: Control file open failed

* /tibero7/database/tibero/c1.ctl

********************************************************

* Critical Warning : Raise svmode failed. The reason is

* TBR-24003 : Unable to read control file.

* Current server mode is NOMOUNT.

********************************************************

Tibero 7

Tibero instance started suspended at NOMOUNT mode.

[tibero@guppy:/tibero7/bin]$

[tibero@guppy:/tibero7/bin]$ ps -ef | grep tib

root 11298 11159 0 04:44 pts/0 00:00:00 su - tibero

tibero 11299 11298 0 04:44 pts/0 00:00:00 -bash

tibero 11438 1 5 04:46 pts/0 00:00:01 tbsvr -t NORMAL -SVR_SID tibero

tibero 11439 11438 0 04:46 pts/0 00:00:00 /tibero7/bin/tblistener -n 11 -t NORMAL -SVR_SID tibero

tibero 11440 11438 0 04:46 pts/0 00:00:00 tbsvr_MGWP -t NORMAL -SVR_SID tibero

tibero 11441 11438 0 04:46 pts/0 00:00:00 tbsvr_FGWP000 -t NORMAL -SVR_SID tibero

tibero 11442 11438 0 04:46 pts/0 00:00:00 tbsvr_FGWP001 -t NORMAL -SVR_SID tibero

tibero 11443 11438 0 04:46 pts/0 00:00:00 tbsvr_PEWP000 -t NORMAL -SVR_SID tibero

tibero 11444 11438 0 04:46 pts/0 00:00:00 tbsvr_PEWP001 -t NORMAL -SVR_SID tibero

tibero 11445 11438 0 04:46 pts/0 00:00:00 tbsvr_PEWP002 -t NORMAL -SVR_SID tibero

tibero 11446 11438 0 04:46 pts/0 00:00:00 tbsvr_PEWP003 -t NORMAL -SVR_SID tibero

tibero 11447 11438 0 04:46 pts/0 00:00:00 tbsvr_PEWP004 -t NORMAL -SVR_SID tibero

tibero 11448 11438 0 04:46 pts/0 00:00:00 tbsvr_PEWP005 -t NORMAL -SVR_SID tibero

tibero 11449 11438 0 04:46 pts/0 00:00:00 tbsvr_AGNT -t NORMAL -SVR_SID tibero

tibero 11450 11438 0 04:46 pts/0 00:00:00 tbsvr_DBWR -t NORMAL -SVR_SID tibero

tibero 11451 11438 0 04:46 pts/0 00:00:00 tbsvr_RCWP -t NORMAL -SVR_SID tibero

tibero 11635 11299 0 04:46 pts/0 00:00:00 ps -ef

tibero 11636 11299 0 04:46 pts/0 00:00:00 grep --color=auto tib

[tibero@guppy:/tibero7/bin]$

[tibero@guppy:/tibero7/bin]$ ls

alterdd.sh cm_res_exec.sh internal_svr_env.sh sm_sysmon_disk_state.sh svr_env.sh tb_create_db.sh t

asboot cmrctl prof sm_sysmon_network_io.sh svr_rename.sh tbboot t

asdown crfconf psmjavac sm_sysmon_network_state.sh sysalloc_summary.sh tbcm t

base_env.sh dbctl_for_cm.sh sm_sysmon_disk_io.sh sm_sysmon_ps.sh tb_cert_manager tbcmbin t

[tibero@guppy:/tibero7/bin]$

[tibero@guppy:/tibero7/bin]$ cd ../

[tibero@guppy:/tibero7]$ ls

bin client config database instance lib license nls scripts

[tibero@guppy:/tibero7]$ cd config

[tibero@guppy:/tibero7/config]$ ls

cm.template gen_tip.sh gen_tip_for_tac.sh ilog.map.example ssvr.template tas.template tibero.tip

gen_psm_cmd.sh gen_tip_for_ssvr.sh gen_tip_for_zeta.sh psm_commands tac.template tibero.template tip.templat

[tibero@guppy:/tibero7/config]$ cd ../

[tibero@guppy:/tibero7]$ cd -

/tibero7/config

[tibero@guppy:/tibero7/config]$ ls

cm.template gen_tip.sh gen_tip_for_tac.sh ilog.map.example ssvr.template tas.template tibero.tip

gen_psm_cmd.sh gen_tip_for_ssvr.sh gen_tip_for_zeta.sh psm_commands tac.template tibero.template tip.templat

[tibero@guppy:/tibero7/config]$ cat tibero.tip

# tip file generated from /tibero7/config/tip.template (2023. 11. 06. (월) 04:45:47 KST)

#-------------------------------------------------------------------------------

# RDBMS initialization parameter

#-------------------------------------------------------------------------------

DB_NAME=tibero

LISTENER_PORT=8629

CONTROL_FILES="/tibero7/database/tibero/c1.ctl"

#CERTIFICATE_FILE="/tibero7/config/tb_wallet/tibero.crt"

#PRIVKEY_FILE="/tibero7/config/tb_wallet/tibero.key"

#WALLET_FILE="/tibero7/config/tb_wallet/WALLET"

#ILOG_MAP="/tibero7/config/ilog.map"

MAX_SESSION_COUNT=20

TOTAL_SHM_SIZE=2G

MEMORY_TARGET=4G

[tibero@guppy:/tibero7/config]$

[tibero@guppy:/tibero7/scripts]$

[tibero@guppy:/tibero7/scripts]$ ./system_check.sh

CPU Info.

- Model : AMD GX-424CC SOC with Radeon(TM) R5E Graphics

- Clock :

- Sockets : 1

- Core : 4

- Thread : 4

- Active cores : 4

Memory Info.

- Physical Size : 3195.34 MB

- Swap Total : 3484 MB

- Shmem : 1168.17 MB

- HugePage Size : 2048 kB

- HugePage Total : 0 kB

Parameter Info.

IPC

- shm size : 17592186044400 MB

- sem count : 32000 1024000000 500 32000

File

- AIO max : 1048576

- file max : 319188

- inode max : 401084

Network

- Recv Mem max : 212992

- Send Mem max : 212992

- Port range : 32768 - 60999

Limit Info.

- open files : 1024

- max user proc : 12533

- stack size(KB) : 8192

- core file(block) : unlimited

- file size(block) : unlimited

- max memory size(KB) : unlimited

[tibero@guppy:/tibero7/scripts]$

[tibero@guppy:/tibero7/scripts]$ cd ../

[tibero@guppy:/tibero7]$ ls

bin client config database instance lib license nls scripts

노마운트 모드로 실행 해서 기본데이타베이스를 만들어야 되는데

아래와 같이 노마운트 모드로 기동합니다.

아래는 기존에 tbboot 으로 올렸다가

실해로 노마운트 모드로 되어서 BOOT FAILED 인상태

[tibero@guppy:/tibero7/database/tibero]$

[tibero@guppy:/tibero7/database/tibero]$ tbboot nomount

Warning: The initialization parameter 'MEMORY_TARGET' value is greater than the physical system memory size. MEMORY_TARGET: 4294967296 Physical System Memory Size: 3350556672Excessive memory consumption may cause the system to slow down or malfunction. It is recommended to set the MEMORY_TARGET to a value less than the physical system memory size.

***********************************************************

* BOOT FAILED.

* tbsvr process (11438) is alive.

* Check if there are any tbsvr instances running.

***********************************************************

[tibero@guppy:/tibero7/client]$ cd bin

[tibero@guppy:/tibero7/client/bin]$ ls

T-Up.zip exportv2 ifmxsqlconv sqlsy tbdb2ccv tbexport tbiobench tbpcbc

assql fan_cli import table_migrator.zip tbdb2sqlcv tbexportv2 tbjavaepa tbpcc

cepa_control gisLoader importv2 tbJavaGW.zip tbdc tbhdreditor tbldprx tbrmgr

db2_ddl_sqlconv gw4db2_v10 libtbOCI_info tbascmd tbdfdump tbicvt tbloader tbsfcdump

db2_psm_sqlconv gw4db2_v9 oracle_psm_sqlconv tbasdd tbdfmod tbicvt_db2 tblobdump tbsql

db2pli gw4orcl oracle_sqlparse tbbctviewer tbdv tbimport tblogdump tbsql2

db2sqlconv gw_install.sh runWizard.sh tbcfdump tbepa tbimportv2 tbpc tbwrap

export hldown shp2tibero tbdb2cblcv tberr tbinitdb tbpcb tibero2shp

티베로 쿼리를 이용하여 데이타베이스 생성을 합니다.

CREATE DATABASE 문을 이용하여 원하는 데이터베이스를 생성한다.

본 예제에서는 'tibero'로 생성한다.

[tibero@guppy:/tibero7/client/bin]$ ./tbsql sys/tibero

tbSQL 7

Connected to 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 50M,

group 2 'log002.log' size 50M,

group 3 'log003.log' size 50M

maxloggroups 255

maxlogmembers 8

noarchivelog

datafile 'system001.dtf' size 100M autoextend on next 10M maxsize unlimited

default temporary tablespace TEMP

tempfile 'temp001.dtf' size 100M autoextend on next 10M maxsize unlimited

extent management local autoallocate

undo tablespace UNDO

datafile 'undo001.dtf' size 200M autoextend on next 10M maxsize unlimited

extent management local autoallocate

SYSSUB

datafile 'syssub001.dtf' size 10M autoextend on next 10M maxsize unlimited

default tablespace USR

datafile 'usr001.dtf' size 100M autoextend on next 10M maxsize unlimited

extent management local autoallocate;

Database created.

SQL>

SQL> quit

Disconnected.

[tibero@guppy:/tibero7/client/bin]$

디비 생성이 되면 다음과 같이 티베로 구동하면

정상적으로 노말모드로 올라 갑니다.

[tibero@guppy:/tibero7/client/bin]$ tbboot

Change core dump dir to /tibero7/bin/prof.

Listener port = 8629

Tibero 7

Tibero instance started up (NORMAL mode).

[tibero@guppy:/tibero7/client/bin]$

[tibero@guppy:/tibero7/scripts]$

system.sh 셸을 실행한다.

이 셸을 실행하면 현재 디렉터리에 있는 SQL 파일이 수행된다.

SQL 파일을 수행하면 role, system user, view, package 등이 생성된다.

사용되는 sys 및 syscat 계정에 대한 기본 암호는 각각 tibero, syscat이다.

[tibero@guppy:/tibero7/scripts]$ ./system.sh

Enter SYS password:

Enter SYSCAT password:

Creating additional system index...

Dropping agent table...

Creating client policy table ...

Creating text packages table ...

Creating the role DBA...

Create default system users & roles?(Y/N):

Creating system users & roles...

Creating example users...

Creating virtual tables(1)...

Creating virtual tables(2)...

Granting public access to _VT_DUAL...

Creating the system generated sequences...

Creating internal dynamic performance views...

Creating outline table...

Creating system tables related to dbms_job...

Creating system tables related to dbms_lock...

Creating system tables related to dbms_parallel_execute...

Creating system tables related to scheduler...

Creating system tables related to server_alert...

Creating system tables related to tpm...

Creating system tables related to tsn and timestamp...

Creating system tables related to rsrc...

Creating system tables related to workspacemanager...

Creating system tables related to statistics...

Creating system tables related to mview...

Create system tables related to dbms_xmlschema...

Create system tables related to dbms_redact...

Create system tables related to dbms_label_security...

Creating system package specifications:

Running /tibero7/scripts/pkg/pkg_standard.sql...

Running /tibero7/scripts/pkg/pkg_dbms_output.sql...

Running /tibero7/scripts/pkg/pkg_standard.sql...

Running /tibero7/scripts/pkg/pkg_standard_extension.sql...

Running /tibero7/scripts/pkg/pkg_xmlinterface.sql...

Running /tibero7/scripts/pkg/pkg_udt_meta.sql...

Running /tibero7/scripts/pkg/pkg_seaf.sql...

Running /tibero7/scripts/pkg/anydata.sql...

Running /tibero7/scripts/pkg/pkg_dbms_standard.sql...

Running /tibero7/scripts/pkg/pkg_db2_standard.sql...

Running /tibero7/scripts/pkg/pkg_dbms_application_info.sql...

Running /tibero7/scripts/pkg/pkg_dbms_aq.sql...

Running /tibero7/scripts/pkg/pkg_dbms_aq_utl.sql...

Running /tibero7/scripts/pkg/pkg_dbms_aqadm.sql...

Running /tibero7/scripts/pkg/pkg_dbms_assert.sql...

Running /tibero7/scripts/pkg/pkg_dbms_crypto.sql...

Running /tibero7/scripts/pkg/pkg_dbms_db2_translator.sql...

Running /tibero7/scripts/pkg/pkg_dbms_db_version.sql...

Running /tibero7/scripts/pkg/pkg_dbms_ddl.sql...

Running /tibero7/scripts/pkg/pkg_dbms_debug.sql...

Running /tibero7/scripts/pkg/pkg_dbms_debug_jdwp.sql...

Running /tibero7/scripts/pkg/pkg_dbms_errlog.sql...

Running /tibero7/scripts/pkg/pkg_dbms_expression.sql...

Running /tibero7/scripts/pkg/pkg_dbms_fga.sql...

Running /tibero7/scripts/pkg/pkg_dbms_flashback.sql...

Running /tibero7/scripts/pkg/pkg_dbms_geom.sql...

Running /tibero7/scripts/pkg/pkg_dbms_java.sql...

Running /tibero7/scripts/pkg/pkg_dbms_job.sql...

Running /tibero7/scripts/pkg/pkg_dbms_lob.sql...

Running /tibero7/scripts/pkg/pkg_dbms_lock.sql...

Running /tibero7/scripts/pkg/pkg_dbms_metadata.sql...

Running /tibero7/scripts/pkg/pkg_dbms_mssql_translator.sql...

Running /tibero7/scripts/pkg/pkg_dbms_mview.sql...

Running /tibero7/scripts/pkg/pkg_dbms_mview_refresh_util.sql...

Running /tibero7/scripts/pkg/pkg_dbms_mview_util.sql...

Running /tibero7/scripts/pkg/pkg_dbms_obfuscation.sql...

Running /tibero7/scripts/pkg/pkg_dbms_output.sql...

Running /tibero7/scripts/pkg/pkg_dbms_pipe.sql...

Running /tibero7/scripts/pkg/pkg_dbms_random.sql...

Running /tibero7/scripts/pkg/pkg_dbms_redefinition.sql...

Running /tibero7/scripts/pkg/pkg_dbms_redefinition_stats.sql...

Running /tibero7/scripts/pkg/pkg_dbms_repair.sql...

Running /tibero7/scripts/pkg/pkg_dbms_result_cache.sql...

Running /tibero7/scripts/pkg/pkg_dbms_rls.sql...

Running /tibero7/scripts/pkg/pkg_dbms_rowid.sql...

Running /tibero7/scripts/pkg/pkg_dbms_rsrc.sql...

Running /tibero7/scripts/pkg/pkg_dbms_scheduler.sql...

Running /tibero7/scripts/pkg/pkg_dbms_session.sql...

Running /tibero7/scripts/pkg/pkg_dbms_space.sql...

Running /tibero7/scripts/pkg/pkg_dbms_space_admin.sql...

Running /tibero7/scripts/pkg/pkg_dbms_sph.sql...

Running /tibero7/scripts/pkg/pkg_dbms_sql.sql...

Running /tibero7/scripts/pkg/pkg_dbms_sql_analyze.sql...

Running /tibero7/scripts/pkg/pkg_dbms_sql_translator.sql...

Running /tibero7/scripts/pkg/pkg_dbms_sqltune.sql...

Running /tibero7/scripts/pkg/pkg_dbms_stats.sql...

Running /tibero7/scripts/pkg/pkg_dbms_stats_util.sql...

Running /tibero7/scripts/pkg/pkg_dbms_spm.sql...

Running /tibero7/scripts/pkg/pkg_dbms_system.sql...

Running /tibero7/scripts/pkg/pkg_dbms_transaction.sql...

Running /tibero7/scripts/pkg/pkg_dbms_types.sql...

Running /tibero7/scripts/pkg/pkg_dbms_utility.sql...

Running /tibero7/scripts/pkg/pkg_dbms_utl_tb.sql...

Running /tibero7/scripts/pkg/pkg_dbms_verify.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xmldom.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xmlgen.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xmlquery.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xplan.sql...

Running /tibero7/scripts/pkg/pkg_dg_cipher.sql...

Running /tibero7/scripts/pkg/pkg_htf.sql...

Running /tibero7/scripts/pkg/pkg_owa.sql...

Running /tibero7/scripts/pkg/pkg_htp.sql...

Running /tibero7/scripts/pkg/pkg_psm_sql_result_cache.sql...

Running /tibero7/scripts/pkg/pkg_sys_util.sql...

Running /tibero7/scripts/pkg/pkg_tb_utility.sql...

Running /tibero7/scripts/pkg/pkg_text.sql...

Running /tibero7/scripts/pkg/pkg_tudiconst.sql...

Running /tibero7/scripts/pkg/pkg_utl_encode.sql...

Running /tibero7/scripts/pkg/pkg_utl_file.sql...

Running /tibero7/scripts/pkg/pkg_utl_tcp.sql...

Running /tibero7/scripts/pkg/pkg_utl_http.sql...

Running /tibero7/scripts/pkg/pkg_utl_url.sql...

Running /tibero7/scripts/pkg/pkg_utl_i18n.sql...

Running /tibero7/scripts/pkg/pkg_utl_match.sql...

Running /tibero7/scripts/pkg/pkg_utl_raw.sql...

Running /tibero7/scripts/pkg/pkg_utl_smtp.sql...

Running /tibero7/scripts/pkg/pkg_utl_str.sql...

Running /tibero7/scripts/pkg/pkg_utl_compress.sql...

Running /tibero7/scripts/pkg/pkg_text_japanese_lexer.sql...

Running /tibero7/scripts/pkg/pkg_dbms_tpm.sql...

Running /tibero7/scripts/pkg/pkg_utl_recomp.sql...

Running /tibero7/scripts/pkg/pkg_dbms_monitor.sql...

Running /tibero7/scripts/pkg/pkg_dbms_server_alert.sql...

Running /tibero7/scripts/pkg/pkg_dbms_ctx_ddl.sql...

Running /tibero7/scripts/pkg/pkg_dbms_odci.sql...

Running /tibero7/scripts/pkg/pkg_utl_ref.sql...

Running /tibero7/scripts/pkg/pkg_dbms_alert.sql...

Running /tibero7/scripts/pkg/pkg_client_internal.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xslprocessor.sql...

Running /tibero7/scripts/pkg/uda_wm_concat.sql...

Running /tibero7/scripts/pkg/pkg_diutil.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xmlschema.sql...

Running /tibero7/scripts/pkg/pkg_dbms_sanity.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xmlsave.sql...

Running /tibero7/scripts/pkg/pkg_dbms_xmlparser.sql...

Running /tibero7/scripts/pkg/pkg_dbms_space_sgmt_drop.sql...

Running /tibero7/scripts/pkg/pkg_client_appctx.sql...

Running /tibero7/scripts/pkg/pkg_dbms_redact.sql...

Running /tibero7/scripts/pkg/pkg_ctx_output.sql...

Running /tibero7/scripts/pkg/pkg_dbms_backup_restore.sql...

Running /tibero7/scripts/pkg/pkg_lbac_rls.sql...

Running /tibero7/scripts/pkg/pkg_lbac_sa_labels.sql...

Running /tibero7/scripts/pkg/pkg_sa_components.sql...

Running /tibero7/scripts/pkg/pkg_sa_label_admin.sql...

Running /tibero7/scripts/pkg/pkg_sa_policy_admin.sql...

Running /tibero7/scripts/pkg/pkg_sa_session.sql...

Running /tibero7/scripts/pkg/pkg_sa_sysdba.sql...

Running /tibero7/scripts/pkg/pkg_sa_user_admin.sql...

Running /tibero7/scripts/pkg/pkg_sa_utl.sql...

Running /tibero7/scripts/pkg/pkg_dbms_inmemory.sql...

Running /tibero7/scripts/pkg/pkg_dbms_parallel_execute_internal.sql...

Running /tibero7/scripts/pkg/pkg_dbms_parallel_execute.sql...

Creating auxiliary tables used in static views...

Create system tables related to profile?(Y/N):

Creating system tables related to profile...

Creating internal system tables...

Check TPR status..

Stop TPR

Create TPR tables?(Y/N):

Dropping tables used in TPR...

Creating auxiliary tables used in TPR...

Creating static views...

Creating static view descriptions...

Creating objects for sph:

Running /tibero7/scripts/iparam_desc_gen.sql...

Creating dynamic performance views...

Creating dynamic performance view descriptions...

Creating additional static views using dpv...

Creating package bodies:

Running /tibero7/scripts/pkg/_pkg_db2_standard.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_aq.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_aq_utl.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_aqadm.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_assert.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_db2_translator.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_errlog.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_fga.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_geom.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_metadata.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_mssql_translator.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_mview.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_mview_refresh_util.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_mview_util.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_redefinition_stats.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_rsrc.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_scheduler.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_session.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_sph.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_sql_analyze.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_sql_translator.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_sqltune.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_stats.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_stats_util.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_spm.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_utility.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_utl_tb.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_verify.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_workspacemanager.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_xmldom.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_xmlgen.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_xplan.tbw...

Running /tibero7/scripts/pkg/_pkg_dg_cipher.tbw...

Running /tibero7/scripts/pkg/_pkg_htf.tbw...

Running /tibero7/scripts/pkg/_pkg_owa.tbw...

Running /tibero7/scripts/pkg/_pkg_htp.tbw...

Running /tibero7/scripts/pkg/_pkg_sys_util.tbw...

Running /tibero7/scripts/pkg/_pkg_text.tbw...

Running /tibero7/scripts/pkg/_pkg_utl_http.tbw...

Running /tibero7/scripts/pkg/_pkg_utl_url.tbw...

Running /tibero7/scripts/pkg/_pkg_utl_i18n.tbw...

Running /tibero7/scripts/pkg/_pkg_utl_smtp.tbw...

Running /tibero7/scripts/pkg/_pkg_text_japanese_lexer.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_tpm.tbw...

Running /tibero7/scripts/pkg/_pkg_utl_recomp.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_server_alert.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_xslprocessor.tbw...

Running /tibero7/scripts/pkg/_uda_wm_concat.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_xmlschema.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_xmlparser.tbw...

Running /tibero7/scripts/pkg/_pkg_client_appctx.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_redact.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_backup_restore.tbw...

Running /tibero7/scripts/pkg/_pkg_lbac_rls.tbw...

Running /tibero7/scripts/pkg/_pkg_lbac_sa_labels.tbw...

Running /tibero7/scripts/pkg/_pkg_sa_components.tbw...

Running /tibero7/scripts/pkg/_pkg_sa_label_admin.tbw...

Running /tibero7/scripts/pkg/_pkg_sa_policy_admin.tbw...

Running /tibero7/scripts/pkg/_pkg_sa_session.tbw...

Running /tibero7/scripts/pkg/_pkg_sa_sysdba.tbw...

Running /tibero7/scripts/pkg/_pkg_sa_user_admin.tbw...

Running /tibero7/scripts/pkg/_pkg_sa_utl.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_inmemory.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_parallel_execute_internal.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_parallel_execute.tbw...

Creating public synonyms for system packages...

Creating remaining public synonyms for system packages...

Registering dbms_stats job to Job Scheduler...

Creating audit event pacakge...

Running /tibero7/scripts/pkg/_pkg_dbms_audit_event.tbw...

Creating packages for TPR...

Running /tibero7/scripts/pkg/pkg_dbms_tpr.sql...

Running /tibero7/scripts/pkg/_pkg_dbms_tpr.tbw...

Running /tibero7/scripts/pkg/_pkg_dbms_apm.tbw...

Start TPR

Create tudi interface

Running /tibero7/scripts/odci.sql...

Creating spatial meta tables and views ...

Registering default spatial reference systems ...

Registering unit of measure entries...

Creating internal system jobs...

Creating Japanese Lexer epa source ...

Creating internal system notice queue ...

Creating sql translator profiles ...

Creating agent table...

Done.

For details, check /tibero7/instance/tibero/log/system_init.log.

Tibero의 설치가 정상적으로 완료되면 Tibero 프로세스가 실행된다.

이 프로세스는 다음의 명령어를 실행하면 확인할 수 있다.