Tibero DB_NAME

SQL> select INSTANCE_NAME, DB_NAME, HOST_NAME from v$instance;

INSTANCE_NAME                           
----------------------------------------
DB_NAME                                 
----------------------------------------
HOST_NAME                                                      
---------------------------------------------------------------
DMRSDB
DMRSDB
p-mrss-tk1-stgdb01

현재 DB_NAME이 DMRSDB인 것을 확인할 수 있다.

 

Tibero DB_Name 을 변경해본다.

SQL> tbdown immediate

 

[DMRSDB:/tibarch]$ tbboot mount

Listener port = 8629

Tibero 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (MOUNT mode).
[DMRSDB:/tibarch]$
[DMRSDB:/tibarch]$tbsql sys/tibero

tbSQL 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.

Connected to Tibero.

DB_NAME은 mount 모드에서 변경해야 하므로 바꿔준다.

 

 

 

<$TB_SID.tip 파일명 변경>

[DMRSDB:/tibero/tibero6/config]$ls
DMRSDB.tip   gen_psm_cmd.sh  gen_tip_for_tac.sh  psm_commands  tip.template
cm.template  gen_tip.sh      ilog.map.example    tac.template  variant
[DMRSDB:/tibero/tibero6/config]$mv DMRSDB.tip DMRSDB01.tip 
[DMRSDB:/tibero/tibero6/config]$ls
DMRSDB01.tip  gen_psm_cmd.sh  gen_tip_for_tac.sh  psm_commands  tip.template
cm.template   gen_tip.sh      ilog.map.example    tac.template  variant

 

<$TB_SID.tip 파일 변경>

DB_NAME=DMRSDB --> DMRSDB01

 

<tbdsn.tbr 파일 변경>

DMRSDB=(
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=DMRSDB)
    )
)

를 아래와 같이 변경


DMRSDB01=(
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=DMRSDB01)
    )
)

<.bash_profile (환경변수 ) 변경>

 

### Tibero6###
export TB_HOME=/tibero/tibero6
export TB_SID=DMRSDB
#export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH
export TBINARY_PATH=/tibero/tbinary
export PATH=$TBINARY_PATH/monitor:$PATH

 

아래와같이 변경

 

### Tibero6###
export TB_HOME=/tibero/tibero6
export TB_SID=DMRSDB01
#export TB_PROF_DIR=$TB_HOME/bin/prof
export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$JAVA_HOME:$PATH
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH
export TBINARY_PATH=/tibero/tbinary
export PATH=$TBINARY_PATH/monitor:$PATH

 

 

<조회 결과 잘 바뀐 것을 확인할 수 있음>

[DMRSDB01:/tibero]$tbsql sys/tibero

tbSQL 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.

Connected to Tibero.

SQL>  select INSTANCE_NAME, DB_NAME, HOST_NAME from v$instance;

INSTANCE_NAME                           
----------------------------------------
DB_NAME                                 
----------------------------------------
HOST_NAME                                                      
---------------------------------------------------------------
DMRSDB01
DMRSDB01
p-mrss-tk1-stgdb01