본문 바로가기
DB/Tibero

[Tibero] RawDevice + TAC 설치 하는법

동탄FreeDiver 2023. 2. 2. 12:43

Hostname 설정

NODE 1

-- root 수행

hostnamectl set-hostname tibero21
su

NODE 2

hostnamectl set-hostname tibero22
su

TIBERO Group, User 생성

NODE1, 2

-- root 수행

groupadd -g 1024 dba
useradd -g dba -u 1024 tibero
passwd tibero

방화벽 확인

NODE 1, 2

-- root 수행

systemctl status firewalld

방화벽이 켜져있다면 꺼주기

systemctl stop firewalld

공유 Disk 세팅 및  RAW 디바이스 생성

NODE1, 2

-- root 수행

ls -al /dev/sd*

fdisk /dev/sde
n
p
1
<Enter>
<Enter>
w



ls /dev/sd*


/dev/sde1이 생성되었다면 정상

pvcreate /dev/sde1 -ff

pvs

vgcreate shared_disk /dev/sde1

vgs

 

lvcreate -L 128M -n controlfile_01_128M shared_disk
lvcreate -L 128M -n controlfile_02_128M shared_disk
lvcreate -L 50M -n redo_001_50M shared_disk
lvcreate -L 50M -n redo_002_50M shared_disk
lvcreate -L 50M -n redo_011_50M shared_disk
lvcreate -L 50M -n redo_012_50M shared_disk
lvcreate -L 50M -n redo_021_50M shared_disk
lvcreate -L 50M -n redo_022_50M shared_disk
lvcreate -L 50M -n redo_101_50M shared_disk
lvcreate -L 50M -n redo_102_50M shared_disk
lvcreate -L 50M -n redo_111_50M shared_disk
lvcreate -L 50M -n redo_112_50M shared_disk
lvcreate -L 50M -n redo_121_50M shared_disk
lvcreate -L 50M -n redo_122_50M shared_disk
lvcreate -L 50M -n redo_122_50M shared_disk
lvcreate -L 200M -n system_200M shared_disk
lvcreate -L 100M -n undo_00_100M shared_disk
lvcreate -L 100M -n undo_01_100M shared_disk
lvcreate -L 100M -n temp_00_100M shared_disk
lvcreate -L 4G -n usr_01_4G shared_disk
lvcreate -L 100M -n tpr_100M shared_disk



lvs

 

잘못만들었을떄 삭제하는법

lvremove shared_disk/controlfile_01_128M
lvremove shared_disk/controlfile_02_128M
lvremove shared_disk/redo_001_50M
lvremove shared_disk/redo_002_50M
lvremove shared_disk/redo_011_50M
lvremove shared_disk/redo_012_50M
lvremove shared_disk/redo_021_50M
lvremove shared_disk/redo_022_50M
lvremove shared_disk/redo_101_50M
lvremove shared_disk/redo_102_50M
lvremove shared_disk/redo_111_50M
lvremove shared_disk/redo_112_50M
lvremove shared_disk/redo_121_50M
lvremove shared_disk/redo_122_50M
lvremove shared_disk/redo_122_50M
lvremove shared_disk/system_200M
lvremove shared_disk/undo_00_100M
lvremove shared_disk/undo_01_100M
lvremove shared_disk/temp_00_100M
lvremove shared_disk/usr_01_4G
lvremove shared_disk/tpr_100M

raw 디바이스 매핑(수동 방식이며, 해당 방식으로는 서버 부팅마다 매번 해줘야하는 번거로움이 있음)

raw /dev/raw/raw1 /dev/shared_disk/controlfile_01_128M
raw /dev/raw/raw2 /dev/shared_disk/controlfile_02_128M
raw /dev/raw/raw3 /dev/shared_disk/redo_001_50M
raw /dev/raw/raw4 /dev/shared_disk/redo_002_50M
raw /dev/raw/raw5 /dev/shared_disk/redo_011_50M
raw /dev/raw/raw6 /dev/shared_disk/redo_012_50M
raw /dev/raw/raw7 /dev/shared_disk/redo_021_50M
raw /dev/raw/raw8 /dev/shared_disk/redo_022_50M
raw /dev/raw/raw9 /dev/shared_disk/redo_101_50M
raw /dev/raw/raw10 /dev/shared_disk/redo_102_50M
raw /dev/raw/raw11 /dev/shared_disk/redo_111_50M
raw /dev/raw/raw12 /dev/shared_disk/redo_112_50M
raw /dev/raw/raw13 /dev/shared_disk/redo_121_50M
raw /dev/raw/raw14 /dev/shared_disk/redo_122_50M
raw /dev/raw/raw15 /dev/shared_disk/system_200M
raw /dev/raw/raw16 /dev/shared_disk/undo_00_100M
raw /dev/raw/raw17 /dev/shared_disk/undo_01_100M
raw /dev/raw/raw18 /dev/shared_disk/temp_00_100M
raw /dev/raw/raw19 /dev/shared_disk/usr_01_4G
raw /dev/raw/raw20 /dev/shared_disk/tpr_100M


raw -qa

RAW 디바이스 권한 변경

chown -R tibero:dba /dev/raw/raw* 

ls -al /dev/raw

 

CM Disk 권한 변경

fdisk -l | grep Disk | sort -k2

chown tibero:dba /dev/sd[b-d]


ls -al /dev/sd[b-d]

커널 파라미터 설정

NODE 1, 2

-- root 수행

free -h

vi /etc/sysctl.conf




kernel.sem = 10000  32000  10000  10000
kernel.shmall = 524288
kernel.shmmax = 2147483648
kernel.shmmni = 4096
fs.file-max = 6815744
fs.aio-max-nr = 4194304
net.ipv4.ip_local_port_range = 1024 65000



net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 4194304
net.ipv4.tcp_rmem = 10240 87380 6291456
net.ipv4.tcp_wmem = 10240 87380 4194304

kernel.shmmax, kernel.shmall  뺴고 전부 동일하게하면 된다.

 

설정 예시 값

# 4GB memory #
#kernel.shmmax = 2147483648
# 6GB memory #
#kernel.shmmax = 3221225472
# 8GB memory #
#kernel.shmmax = 4294967296
# 12GB memory #
#kernel.shmmax = 6442450944
# 16GB memory #
kernel.shmmax = 8589934592

 

kernel.shmall =  kernel.shmmax/4096 이다.

User shell limit 설정

NODE 1, 2

-- root 수행

vi /etc/security/limits.conf

tibero soft nofile 655350
tibero hard nofile 655350
tibero soft nproc 257554
tibero hard nproc 257554

#TBCM
root soft nofile 655350
root hard nofile 655350
root soft nproc 257554
root hard nproc 257554

bash_profile 설정

NODE 1

-- root 수행

vi /root/.bash_profile


### Tibero RDBMS 6 ENV ###
ulimit -Sc 0
ulimit -Hc 0
ulimit -Sn 655350
ulimit -Hn 655350
ulimit -Su 257554
ulimit -Hu 257554

unset USERNAME
export TB_HOME=/tibero_engine/tibero6
export CM_HOME=/tibero_engine/tibero6
export TB_SID=tibero21
export CM_SID=tcm1
export LD_LIBRARY_PATH=/usr/openv/lib/:$TB_HOME/lib:$TB_HOME/client/lib:$TB_HOME/../lib_dummy
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin:/tibero_engine/iodbc/tblib
#export ISQL_WALLET_PATH=/tibero_dump/$TB_SID/wallet/wallet.dat
#export EXPIMP_WALLET=/tibero_dump/$TB_SID/wallet/expimp_wallet.dat
export PS1='[$TB_SID]\u@\h:$PWD>  '

export TBGW_HOME=/tibero_engine/tibero_gw
export ORACLE_HOME=/tibero_engine/oracle_gw/product/11.2.0/tg_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:/tibero_engine/iodbc/tblib
export ORACLE_SID=DBA01
export PATH=$PATH:$ORACLE_HOME/bin

#### Tibero function ####
function tbhome { 
cd $TB_HOME 
}
function tblog { 
cd /tibero_dump/$TB_SID/log
}
function tbcfg {
cd $TB_HOME/config
}
function tbcfgv {
vi $TB_HOME/config/$TB_SID.tip
}
function tbi { 
cd /tibero_engine/tbinary/
}
function tm {
cd /tibero_engine/tbinary/monitor;sh monitor;cd ~ 
}
function tbcli {
cd $TB_HOME/client/config 
}
function tbcliv {
vi $TB_HOME/client/config/tbdsn.tbr 
}
function cmlog { 
cd /tibero_dump/$CM_SID/log
}
cp /root/.bash_profile ~tibero/.bash_profile

CM Tip파일 수정 및 cm기동

NODE 1

-- tibero로 수행

CM_NAME=tcm1
CM_UI_PORT=28629
CM_RESOURCE_FILE="/tibero_engine/cm_cfg/tcm1_res.crf"

#AS_DISKSTRING="/dev/vd*"
LOG_DEFAULT_DEST="/tibero_dump/tcm1/log"
CM_LOG_DEST="/tibero_dump/tcm1/log"
BOOT_WITH_AUTO_DOWN_CLEAN=Y
NLS_DATE_FORMAT="YYYY/MM/DD HH24:MI:SS"
EVENT_TRACE_TOTAL_SIZE_LIMIT=1G
TRACE_LOG_TOTAL_SIZE_LIMIT=1G
SLOG_TOTAL_SIZE_LIMIT=1G
_OPT_BIND_PEEKING=N
_ADAPTIVE_CURSOR_SHARING=N
_PEP_STABILITY_LEVEL=1
_ENABLE_TRANS_AGGR_TO_ANAL=N
TRACE_LOG_DISPLAY_YEAR=Y
_SLOG_DISPLAY_YEAR=Y
#_PSM_BCODE_SGMT_MAX_SIZE_RATIO=2

CM_HEARTBEAT_EXPIRE=80
CM_WATCHDOG_EXPIRE=70
CM_FENCE=Y
CM_ENABLE_FAST_NET_ERROR_DETECTION=Y
_CM_CHECK_RUNLEVEL=Y

-- root 수행

tbcm 기동

tbcm -b

-- tibero 수행

네트워크 등록
cmrctl add network --nettype public --ifname enp0s8 --name pub1
cmrctl add network --nettype private --ipaddr 192.168.56.102 --portno 28729 --name inter1

클러스터 등록
cmrctl add cluster --incnet inter1 --pubnet pub1 --cfile "/dev/sdb,/dev/sdc,/dev/sdd" --name cls1
cmrctl start cluster --name cls1

cmrctl show

bash_profile 설정

NODE 2

-- root 수행

vi /root/.bash_profile


### Tibero RDBMS 6 ENV ###
ulimit -Sc 0
ulimit -Hc 0
ulimit -Sn 655350
ulimit -Hn 655350
ulimit -Su 257554
ulimit -Hu 257554

unset USERNAME
export TB_HOME=/tibero_engine/tibero6
export CM_HOME=/tibero_engine/tibero6
export TB_SID=tibero22
export CM_SID=tcm2
export LD_LIBRARY_PATH=/usr/openv/lib/:$TB_HOME/lib:$TB_HOME/client/lib:$TB_HOME/../lib_dummy
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin:/tibero_engine/iodbc/tblib
#export ISQL_WALLET_PATH=/tibero_dump/$TB_SID/wallet/wallet.dat
#export EXPIMP_WALLET=/tibero_dump/$TB_SID/wallet/expimp_wallet.dat
export PS1='[$TB_SID]\u@\h:$PWD>  '

export TBGW_HOME=/tibero_engine/tibero_gw
export ORACLE_HOME=/tibero_engine/oracle_gw/product/11.2.0/tg_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:/tibero_engine/iodbc/tblib
export ORACLE_SID=DBA01
export PATH=$PATH:$ORACLE_HOME/bin

#### Tibero function ####
function tbhome { 
cd $TB_HOME 
}
function tblog { 
cd /tibero_dump/$TB_SID/log
}
function tbcfg {
cd $TB_HOME/config
}
function tbcfgv {
vi $TB_HOME/config/$TB_SID.tip
}
function tbi { 
cd /tibero_engine/tbinary/
}
function tm {
cd /tibero_engine/tbinary/monitor;sh monitor;cd ~ 
}
function tbcli {
cd $TB_HOME/client/config 
}
function tbcliv {
vi $TB_HOME/client/config/tbdsn.tbr 
}
function cmlog { 
cd /tibero_dump/$CM_SID/log
}
cp /root/.bash_profile ~tibero/.bash_profile

CM Tip파일 수정 및 cm기동

NODE 2

-- tibero로 수행

vi $TB_HOME/config/$CM_SID.tip


** tcm2.tip
CM_NAME=tcm2
CM_UI_PORT=28629
CM_RESOURCE_FILE="/tibero_engine/cm_cfg/tcm2_res.crf"

#AS_DISKSTRING="/dev/vd*"
LOG_DEFAULT_DEST="/tibero_dump/tcm2/log"
CM_LOG_DEST="/tibero_dump/tcm2/log"
BOOT_WITH_AUTO_DOWN_CLEAN=Y
NLS_DATE_FORMAT="YYYY/MM/DD HH24:MI:SS"
EVENT_TRACE_TOTAL_SIZE_LIMIT=1G
TRACE_LOG_TOTAL_SIZE_LIMIT=1G
SLOG_TOTAL_SIZE_LIMIT=1G
_OPT_BIND_PEEKING=N
_ADAPTIVE_CURSOR_SHARING=N
_PEP_STABILITY_LEVEL=1
_ENABLE_TRANS_AGGR_TO_ANAL=N
TRACE_LOG_DISPLAY_YEAR=Y
_SLOG_DISPLAY_YEAR=Y
#_PSM_BCODE_SGMT_MAX_SIZE_RATIO=2

CM_HEARTBEAT_EXPIRE=80
CM_WATCHDOG_EXPIRE=70
CM_FENCE=Y
CM_ENABLE_FAST_NET_ERROR_DETECTION=Y
_CM_CHECK_RUNLEVEL=Y

-- root 수행
** tbcm 기동

tbcm -b

-- tibero 수행

** 네트워크 등록

** 네트워크 등록
cmrctl add network --nettype private --ipaddr 192.168.56.116 --portno 28729 --name inter2
cmrctl add network --nettype public --ifname enp0s8 --name pub2

** 클러스터 등록
cmrctl add cluster --incnet inter2 --pubnet pub2 --cfile "/dev/sdb,/dev/sdc,/dev/sdd" --name cls1
cmrctl start cluster --name cls1

cmrctl show

tac1.tip 생성 및 설정

NODE 1

--tibero 수행

cd $TB_HOME/config

 sh gen_tip.sh
vi $TB_SID.tip

DB_NAME=TIBERO2
LISTENER_PORT=1521
CONTROL_FILES="/dev/raw/raw1","/dev/raw/raw2"

MAX_SESSION_COUNT=20
TOTAL_SHM_SIZE=2G
MEMORY_TARGET=4G

#USE_ACTIVE_STORAGE=Y
#_DBWR_USE_AIO=N
#AS_PORT=1529
#AS_ADDR=127.0.0.1

CLUSTER_DATABASE=Y
THREAD=0
UNDO_TABLESPACE=UNDO0

LOCAL_CLUSTER_ADDR=192.168.56.102
LOCAL_CLUSTER_PORT=21621
CM_PORT=28629

DB_CREATE_FILE_DEST="/tibero_data01/TIBERO2/data"
LOG_DEFAULT_DEST="/tibero_dump/tibero21/log"
BOOT_WITH_AUTO_DOWN_CLEAN=Y
NLS_DATE_FORMAT="YYYY/MM/DD HH24:MI:SS"
LOG_ARCHIVE_DEST="/tibero_arch/TIBERO2/arch"
EVENT_TRACE_TOTAL_SIZE_LIMIT=1G
TRACE_LOG_TOTAL_SIZE_LIMIT=1G
SLOG_TOTAL_SIZE_LIMIT=1G
UNDO_RETENTION=10800
_OPT_BIND_PEEKING=N
_ADAPTIVE_CURSOR_SHARING=N
_PEP_STABILITY_LEVEL=1
_ENABLE_TRANS_AGGR_TO_ANAL=N
TRACE_LOG_DISPLAY_YEAR=Y
_SLOG_DISPLAY_YEAR=Y
_PSM_BCODE_SGMT_MAX_SIZE_RATIO=2
USE_TS_QUOTA=NO
_USE_DF_HINT=NO
JOB_SCHEDULING_MAX_TIMEOUT=2
_OPT_ENABLE_PROXY_INDEX_JOIN=Y
_DB_BLOCK_CHECK_FAIL_DUMP=N
_DELAYING_CKPT_DUMP_INTERVAL= 0
USGMT_AUTO_SHRINK_INTERVAL=60
_LOG_CHECKPOINT_ON_LOG_SWITCH=Y

# for APM. gathering every 10min, until 30days
#ACTIVE_SESSION_HISTORY=Y
TPR_SNAPSHOT_SAMPLING_INTERVAL=10
TPR_SNAPSHOT_RETENTION=30
GATHER_SQL_PLAN_STAT=Y
GATHER_SQL_EXEC_TIME=Y

# Audit
AUDIT_TRAIL=DB
AUDIT_SYS_OPERATIONS=Y

# 20210305
USE_RECYCLEBIN=Y

# binary patch history
USE_BINARY_UPDATE=Y

#DBLINK_TIMEOUT
DBLINK_CONN_TIMEOUT=120

#PARSER_DEPTH
_PARSE_ALLOWED_MEMORY_DEPTH=100000

# 20220112 
_USE_O_DIRECT=Y

# for TAC_Parameter_ADD_20200227
_SGMT_SEARCH_METHOD=3
TEMP_GRANULE_SIZE=1000
_DBWR_USE_AIO=N

tbdsn.tbr 수정 

NODE 1

--tibero 수행

tibero21=(
    (INSTANCE=(HOST=localhost)
              (PORT=1521)
              (DB_NAME=TIBERO2)
    )
)

tibero21_SP=(
    (INSTANCE=(HOST=localhost)
              (PORT=1522)
              (DB_NAME=TIBERO2)
    )
)

TIBERO2=(
    (INSTANCE=(HOST=192.168.56.103)
              (PORT=1521)
              (DB_NAME=TIBERO2)
    )
    (INSTANCE=(HOST=192.168.56.115)
              (PORT=1521)
              (DB_NAME=TIBERO2)
    )
)

tac2.tip 생성 및 설정

NODE 2

--tibero 수행

cd $TB_HOME/config

sh gen_tip.sh
vi $TB_SID.tip


DB_NAME=TIBERO2
LISTENER_PORT=1521
CONTROL_FILES="/tibero_redo01/TIBERO2/control/c1.ctl","/tibero_data01/TIBERO2/control/c2.ctl"

MAX_SESSION_COUNT=20
OS전체 물리메모리 = 1G(OS) + hugepage(total_size) + pga(memory_target-total_shm) + MAX_SESSION*8M
TAS사용시, TAS 사용 메모리도 total_shm 및 pga영역에 포함해서 계산해야 함

TOTAL_SHM_SIZE=2G
MEMORY_TARGET=4G

#USE_ACTIVE_STORAGE=Y
#_DBWR_USE_AIO=N
#AS_PORT=1529
#AS_ADDR=127.0.0.1

CLUSTER_DATABASE=Y
THREAD=1
UNDO_TABLESPACE=UNDO1

LOCAL_CLUSTER_ADDR=192.168.56.116
LOCAL_CLUSTER_PORT=21621
CM_PORT=28629

DB_CREATE_FILE_DEST="/tibero_data01/TIBERO2/data"
LOG_DEFAULT_DEST="/tibero_dump/tibero22/log"
BOOT_WITH_AUTO_DOWN_CLEAN=Y
NLS_DATE_FORMAT="YYYY/MM/DD HH24:MI:SS"
LOG_ARCHIVE_DEST="/tibero_arch/TIBERO2/arch"
EVENT_TRACE_TOTAL_SIZE_LIMIT=1G
TRACE_LOG_TOTAL_SIZE_LIMIT=1G
SLOG_TOTAL_SIZE_LIMIT=1G
UNDO_RETENTION=10800
_OPT_BIND_PEEKING=N
_ADAPTIVE_CURSOR_SHARING=N
_PEP_STABILITY_LEVEL=1
_ENABLE_TRANS_AGGR_TO_ANAL=N
TRACE_LOG_DISPLAY_YEAR=Y
_SLOG_DISPLAY_YEAR=Y
_PSM_BCODE_SGMT_MAX_SIZE_RATIO=2
USE_TS_QUOTA=NO
_USE_DF_HINT=NO
JOB_SCHEDULING_MAX_TIMEOUT=2
_OPT_ENABLE_PROXY_INDEX_JOIN=Y
_DB_BLOCK_CHECK_FAIL_DUMP=N
_DELAYING_CKPT_DUMP_INTERVAL= 0
USGMT_AUTO_SHRINK_INTERVAL=60
_LOG_CHECKPOINT_ON_LOG_SWITCH=Y

# for APM. gathering every 10min, until 30days
#ACTIVE_SESSION_HISTORY=Y
TPR_SNAPSHOT_SAMPLING_INTERVAL=10
TPR_SNAPSHOT_RETENTION=30
GATHER_SQL_PLAN_STAT=Y
GATHER_SQL_EXEC_TIME=Y

# Audit
AUDIT_TRAIL=DB
AUDIT_SYS_OPERATIONS=Y

# 20210305
USE_RECYCLEBIN=Y

# binary patch history
USE_BINARY_UPDATE=Y

#DBLINK_TIMEOUT
DBLINK_CONN_TIMEOUT=120

#PARSER_DEPTH
_PARSE_ALLOWED_MEMORY_DEPTH=100000

# 20220112 
_USE_O_DIRECT=Y

# for TAC_Parameter_ADD_20200227
_SGMT_SEARCH_METHOD=3
TEMP_GRANULE_SIZE=1000
_DBWR_USE_AIO=N

tbdsn.tbr 수정 

NODE 2

--tibero 수행

vi $TB_HOME/client/config/tbdsn.tbr

tibero22=(
    (INSTANCE=(HOST=localhost)
              (PORT=1521)
              (DB_NAME=TIBERO2)
    )
)

tibero22_SP=(
    (INSTANCE=(HOST=localhost)
              (PORT=1522)
              (DB_NAME=TIBERO2)
    )
)

TIBERO2=(
    (INSTANCE=(HOST=192.168.56.115)
              (PORT=1521)
              (DB_NAME=TIBERO2)
    )
    (INSTANCE=(HOST=192.168.56.103)
              (PORT=1521)
              (DB_NAME=TIBERO2)
    )
)

서비스 등록 및 서비스에 DB 등록

NODE 1

--tibero 수행

cmrctl add service --name TIBERO2 --cname cls1 --type db --mode AC

cmrctl add db --name tibero21 --svcname TIBERO2 --dbhome $TB_HOME --envfile ~tibero/.bash_profile

NODE 2

--tibero 수행

cmrctl add db --name tibero22 --svcname TIBERO2 --dbhome $TB_HOME --envfile ~tibero/.bash_profile

DB생성 및 쓰레드 추가

NODE 1

--tibero 수행

tbboot nomount

tbsql sys/tibero

CREATE DATABASE "TIBERO2"
USER SYS IDENTIFIED BY TIBERO
MAXDATAFILES 4096
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF16
LOGFILE GROUP 0 ('/dev/raw/raw3','/dev/raw/raw4') SIZE 50M,
GROUP 1 ('/dev/raw/raw5','/dev/raw/raw6') SIZE 50M,
GROUP 2 ('/dev/raw/raw7','/dev/raw/raw8') SIZE 50M
MAXLOGFILES 100
MAXLOGMEMBERS 8
NOARCHIVELOG
DATAFILE '/dev/raw/raw15' SIZE 200M
DEFAULT TABLESPACE USR
DATAFILE '/dev/raw/raw19' SIZE 4G
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/dev/raw/raw18' SIZE 100M
UNDO TABLESPACE UNDO0
DATAFILE '/dev/raw/raw16' SIZE 100M
;

quit

DB 기동 
tbboot

tbsql sys/tibero

** node2 UNDO, REDO 추가 및 THREAD 1 활성화
create undo tablespace undo1 datafile '/dev/raw/raw17' SIZE 100M;

alter database add logfile thread 1 group 10 ('/dev/raw/raw9','/dev/raw/raw10') size 50M;
alter database add logfile thread 1 group 11 ('/dev/raw/raw11','/dev/raw/raw12') size 50M;
alter database add logfile thread 1 group 12 ('/dev/raw/raw13','/dev/raw/raw14') size 50M;

alter database enable public thread 1;

TPR 테이블스페이스 경로 수정 및 System.sh 쉘 수행

vi $TB_HOME/scripts/tpr_create_obj.sh

tpr_create_ts_sql="create tablespace syssub datafile '/dev/raw/raw20' size 100M;"

** 시스템 쉘 수행

$TB_HOME/scripts/system.sh -p1 tibero -p2 syscat -a1 y -a2 y -a3 y -a4 y

DB기동 및 VIP 추가

NODE 2

--tibero 수행

** DB 기동
tbboot

** VIP 설정
cmrctl add vip --name vip1 --node tcm1 --svcname TIBERO2 --ipaddr 192.168.56.103
cmrctl add vip --name vip2 --node tcm2 --svcname TIBERO2 --ipaddr 192.168.56.115

** auto start 설정
cmrctl act service --name TIBERO2

확인

NODE 1

cmrctl show

NODE 2

cmrctl show

저작자표시

'DB > Tibero' 카테고리의 다른 글

[Tibero] Driver(ODBC, OLE DB, JDBC, ESQL)연결 가이드  (0) 2023.02.20
[Tibero] PHP, ODBC 연동 가이드  (0) 2023.02.16
[Tibero] tbexport & tbimport  (1) 2023.02.01
[Tibero] tbExport/tbImport  (0) 2023.02.01
[Tibero] 사용자 관리와 데이터베이스 보안  (0) 2023.01.10

'DB/Tibero' Related Articles

티스토리툴바