{"id":2728,"date":"2019-03-13T12:26:16","date_gmt":"2019-03-13T09:26:16","guid":{"rendered":"https:\/\/sysdba.org\/?p=2728"},"modified":"2019-03-13T12:26:16","modified_gmt":"2019-03-13T09:26:16","slug":"tibero-active-cluster-installation","status":"publish","type":"post","link":"https:\/\/sysdba.org\/en\/tibero-active-cluster-installation\/","title":{"rendered":"Tibero Active Cluster Installation"},"content":{"rendered":"

Finally another RDBMS solution is supporting active active cluster like Oracle’s RAC . Actually active cluster supported by Tibero since 2008.
\nToday we will see how to install Tibero Active Cluster (TAC) database on 2 Linux 64 bit Virtual Machines using VirtualBox
\nBefore TAC installation we should be completed Tibero Active Storage (TAS) (like Orale’s ASM) steps for shared storage area.
\nFor installation files and documentation you can visit technet.tmaxsoft.com<\/p>\n

Virtual box Environment<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n
<\/td>\nNode1<\/strong><\/td>\nNode2<\/strong><\/td>\n<\/tr>\n
VM name<\/td>\nnode1<\/td>\nnode2<\/td>\n<\/tr>\n
hostname<\/td>\nnode1<\/td>\nnode2<\/td>\n<\/tr>\n
OS<\/td>\nSL7.1<\/td>\nSL7.1<\/td>\n<\/tr>\n
Memory<\/td>\n3GB<\/td>\n3GB<\/td>\n<\/tr>\n
Public<\/td>\n192.168.2.21<\/td>\n192.168.2.22<\/td>\n<\/tr>\n
Inter connect<\/td>\n\u00a0192.168.56.21<\/td>\n\u00a0192.168.56.22<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0 \u00a0<\/strong>
\n\u00a0Tibero Active Storage Steps<\/strong><\/span><\/p>\n

[crayon]VBoxManage showvminfo NODE1
\n[\/crayon]<\/p>\n

Step_1 creating users\/groups (on both nodes)<\/strong>
\n[crayon]\/usr\/sbin\/groupadd -g 501 dba
\n\/usr\/sbin\/useradd -u 502 -g dba tibero
\n[\/crayon]<\/p>\n

Step_2 Creating directories (on both nodes)<\/strong>
\n[crayon]mkdir -p \/Tibero\/tas
\nmkdir -p \/Tibero\/tac
\nchown -R tibero:dba \/Tibero
\n[\/crayon]<\/p>\n

Step_3 installing required packages (on both nodes)<\/strong>
\n[crayon]yum install -y gcc-*
\nyum install -y gcc-c++-*
\nyum install -y libgcc-*
\nyum install -y libstdc++-*
\nyum install -y libstdc++-devel-*
\nyum install -y compat-libstdc++-*
\nyum install -y libaio-*
\nyum install -y libaio-devel-*
\n[\/crayon]<\/p>\n

Step_4 configuring operating systems (on both nodes)<\/strong>
\n[crayon]cp \/etc\/security\/limits.conf \/etc\/security\/limits.conf_bck
\necho -e ‘tibero hard nofile 65536\\ntibero soft nofile 4096\\ntibero soft nproc 4096\\ntibero hard nproc 16384’ >> \/etc\/security\/limits.conf
\n[\/crayon]<\/p>\n

[crayon]echo session required pam_limits.so >> \/etc\/pam.d\/login
\ncp \/etc\/sysctl.conf \/etc\/sysctl.conf_bck
\n[\/crayon]<\/p>\n

[crayon]cp \/etc\/sysctl.conf \/etc\/sysctl.conf_bck
\necho -e ‘kernel.shmmni = 4096\\nkernel.sem = 10000 32000 10000 10000\\nfs.file-max = 6553600\\nnet.ipv4.ip_local_port_range = 1024 65000\\nnet.core.rmem_default = 262144\\nnet.core.rmem_max = 4194304\\nnet.core.wmem_default = 262144\\nnet.core.wmem_max = 1048576’ >> \/etc\/sysctl.conf
\n[\/crayon]<\/p>\n

Virtual Box Steps<\/strong>
\nStep_5 creating Shared Disks disks (on host operating system)<\/strong>
\nDefault disk for control files (high redundancy) 512M*3
\n[crayon]VBoxManage createhd –filename \/Data\/VM\/Shared_Disks\/TAS01.vdi –size 512 –format VDI –variant Fixed
\nVBoxManage createhd –filename \/Data\/VM\/Shared_Disks\/TAS02.vdi –size 512 –format VDI –variant Fixed
\nVBoxManage createhd –filename \/Data\/VM\/Shared_Disks\/TAS03.vdi –size 512 –format VDI –variant Fixed
\n[\/crayon]<\/p>\n

DATA1 disk group
\n[crayon]VBoxManage createhd –filename \/Data\/VM\/Shared_Disks\/TAS04.vdi –size 2048 –format VDI –variant Fixed
\nVBoxManage createhd –filename \/Data\/VM\/Shared_Disks\/TAS05.vdi –size 2048 –format VDI –variant Fixed
\n[\/crayon]<\/p>\n

RA1 disk group
\n[crayon]VBoxManage createhd –filename \/Data\/VM\/Shared_Disks\/TAS06.vdi –size 2048 –format VDI –variant Fixed
\nVBoxManage createhd –filename \/Data\/VM\/Shared_Disks\/TAS07.vdi –size 2048 –format VDI –variant Fixed
\n[\/crayon]<\/p>\n

[crayon]VBoxManage modifyhd \/Data\/VM\/Shared_Disks\/TAS01.vdi –type shareable
\nVBoxManage modifyhd \/Data\/VM\/Shared_Disks\/TAS02.vdi –type shareable
\nVBoxManage modifyhd \/Data\/VM\/Shared_Disks\/TAS03.vdi –type shareable
\nVBoxManage modifyhd \/Data\/VM\/Shared_Disks\/TAS04.vdi –type shareable
\nVBoxManage modifyhd \/Data\/VM\/Shared_Disks\/TAS05.vdi –type shareable
\nVBoxManage modifyhd \/Data\/VM\/Shared_Disks\/TAS06.vdi –type shareable
\nVBoxManage modifyhd \/Data\/VM\/Shared_Disks\/TAS07.vdi –type shareable
\n[\/crayon]<\/p>\n

Adding disks to nodes
\nnode1
\n[crayon]VBoxManage storageattach node1 –storagectl “SATA” –port 3 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS01.vdi –mtype shareable
\nVBoxManage storageattach node1 –storagectl “SATA” –port 4 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS02.vdi –mtype shareable
\nVBoxManage storageattach node1 –storagectl “SATA” –port 5 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS03.vdi –mtype shareable
\nVBoxManage storageattach node1 –storagectl “SATA” –port 6 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS04.vdi –mtype shareable
\nVBoxManage storageattach node1 –storagectl “SATA” –port 7 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS05.vdi –mtype shareable
\nVBoxManage storageattach node1 –storagectl “SATA” –port 8 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS06.vdi –mtype shareable
\nVBoxManage storageattach node1 –storagectl “SATA” –port 9 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS07.vdi –mtype shareable
\n[\/crayon]<\/p>\n

node2
\n[crayon]VBoxManage storageattach node2 –storagectl “SATA” –port 3 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS01.vdi –mtype shareable
\nVBoxManage storageattach node2 –storagectl “SATA” –port 4 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS02.vdi –mtype shareable
\nVBoxManage storageattach node2 –storagectl “SATA” –port 5 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS03.vdi –mtype shareable
\nVBoxManage storageattach node2 –storagectl “SATA” –port 6 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS04.vdi –mtype shareable
\nVBoxManage storageattach node2 –storagectl “SATA” –port 7 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS05.vdi –mtype shareable
\nVBoxManage storageattach node2 –storagectl “SATA” –port 8 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS06.vdi –mtype shareable
\nVBoxManage storageattach node2 –storagectl “SATA” –port 9 –device 0 –type hdd –medium \/Data\/VM\/Shared_Disks\/TAS07.vdi –mtype shareable
\n[\/crayon]<\/p>\n

Step_6 configuring disks (on one node)<\/strong>
\n[crayon]fdisk \/dev\/sdx
\n[\/crayon]
\non both nodes ( sometimes reboot is necessary (other than node1 (fdisk executed on node1))<\/p>\n

[crayon]sudo chown tibero:dba \/dev\/sdb1
\nsudo chown tibero:dba \/dev\/sdc1
\nsudo chown tibero:dba \/dev\/sdd1
\nsudo chown tibero:dba \/dev\/sde1
\nsudo chown tibero:dba \/dev\/sdf1
\nsudo chown tibero:dba \/dev\/sdg1
\nsudo chown tibero:dba \/dev\/sdh1
\n[\/crayon]<\/p>\n

[crayon]sudo chmod 660 \/dev\/sdb1
\nsudo chmod 660 \/dev\/sdc1
\nsudo chmod 660 \/dev\/sdd1
\nsudo chmod 660 \/dev\/sde1
\nsudo chmod 660 \/dev\/sdf1
\nsudo chmod 660 \/dev\/sdg1
\nsudo chmod 660 \/dev\/sdh1
\n[\/crayon]<\/p>\n

Step_7 Extracting binaries (on both nodes)<\/strong>
\n[crayon]tar -xvf \/Data\/SetUp\/tibero6-bin-FS02-linux64-114545-opt-20151210192436-tested.tar.gz -C \/Tibero\/tas\/
\n[\/crayon]<\/p>\n

Step_8 Configuring .bash_profile<\/strong>
\nEnd of the page there is a .bash_profile for both instances
\nStep_9 parameter files<\/strong><\/p>\n

node _ 1
\nvi \/Tibero\/tas\/tibero6\/config\/tas1.tip<\/p>\n

[crayon]DB_NAME=tas
\nLISTENER_PORT=9620
\nMAX_SESSION_COUNT=200
\nTOTAL_SHM_SIZE=512M
\nMEMORY_TARGET=1G
\nINSTANCE_TYPE=TAS
\nTAS_DISKSTRING=”\/dev\/sdb*,\/dev\/sdc*,\/dev\/sdd*,\/dev\/sde*,\/dev\/sdf*,\/dev\/sdh*,\/dev\/sdg*”<\/p>\n

CLUSTER_DATABASE=Y
\nLOCAL_CLUSTER_ADDR=192.168.56.21
\nLOCAL_CLUSTER_PORT=20000
\nCM_CLUSTER_MODE=ACTIVE_SHARED
\nCM_PORT=20005
\nTHREAD=0
\n[\/crayon]<\/p>\n

node _ 2
\nvi \/Tibero\/tas\/tibero6\/config\/tas2.tip<\/p>\n

[crayon]DB_NAME=tas
\nLISTENER_PORT=9620
\nMAX_SESSION_COUNT=200
\nTOTAL_SHM_SIZE=512M
\nMEMORY_TARGET=1G
\nINSTANCE_TYPE=TAS
\nTAS_DISKSTRING=”\/dev\/sdb*,\/dev\/sdc*,\/dev\/sdd*,\/dev\/sde*,\/dev\/sdf*,\/dev\/sdh*,\/dev\/sdg*”
\nCLUSTER_DATABASE=Y
\nLOCAL_CLUSTER_ADDR=192.168.56.22
\nLOCAL_CLUSTER_PORT=20000
\nCM_CLUSTER_MODE=ACTIVE_SHARED
\nCM_PORT=20005
\nTHREAD=1
\n[\/crayon]<\/p>\n

Step_10 tbdsn.tbr (tnsnames ora)<\/strong>
\nnode _ 1
\nvim \/Tibero\/tas\/tibero6\/client\/config\/tbdsn.tbr<\/p>\n

[crayon]tas1=(
\n(INSTANCE=(HOST=localhost)
\n(PORT=9620)
\n(DB_NAME=tas1)
\n)
\n)
\n[\/crayon]<\/p>\n

node _ 2
\nvim \/Tibero\/tas\/tibero6\/client\/config\/tbdsn.tbr<\/p>\n

[crayon]tas2=(
\n(INSTANCE=(HOST=localhost)
\n(PORT=9620)
\n(DB_NAME=tas2)
\n)
\n)
\n[\/crayon]<\/p>\n

Step_11 license files (on both nodes)<\/strong>
\nMailed from technet.tmaxsoft.com
\n[crayon]cp license.xml cp \/Tibero\/tas\/tibero6\/license\/license.xml
\n[\/crayon]<\/p>\n

Before running TAS instances as a cluster,
\nrun a TAS instance in the NOMOUNT mode and then
\ncreate the default disk space.
\nAfter creating the default disk space, run TBCM for clustering TAS instances.<\/p>\n

Step_12 creating default disk space<\/strong>
\nTB_SID=tas1
\n[crayon]tbboot -t nomount
\n[\/crayon]<\/p>\n

Default Disk Space (on one node)
\n[crayon]CREATE DISKSPACE ds0 HIGH REDUNDANCY
\nFAILGROUP fg1 DISK
\n‘\/dev\/sdb1’ NAME sdb1
\nFAILGROUP fg2 DISK
\n‘\/dev\/sdc1’ NAME sdc1
\nFAILGROUP fg3 DISK
\n‘\/dev\/sdd1’ NAME sdd1
\nATTRIBUTE ‘AU_SIZE’=’1M’;
\n[\/crayon]<\/p>\n

Step_13 firewall and selinux should be disabled (on both nodes)<\/strong>
\n[crayon]systemctl disable firewalld
\nsystemctl stop firewalld
\nsystemctl status firewalld
\n[\/crayon]<\/p>\n

Step_14 starting up tas instance<\/strong>
\nnode _ 1
\nTB_SID=tas1
\n[crayon]tbcm -c
\n# cmfile in the default disk space. —> SUCCESS<\/p>\n

TB_SID=tas1
\ntbcm -b
\n[\/crayon]<\/p>\n

Check the status of cluster
\n[crayon][tibero@node1 ~]$ tbcm -s
\n======================= LOCAL STATUS ===========================
\nNODE NAME : [101] cm@192.168.56.21:20005
\nCLUSTER MODE : ACTIVE_SHARED (GUARD ON, FENCE OFF)
\nSTATUS : NODE ACTIVE
\nINCARNATION_NO : 1 (ACK 1, COMMIT 1)
\nHEARTBEAT PERIOD : 30 ticks (1 tick = 1000000 micro-sec)
\nSVC PROBE PERIOD : 10 ticks (expires 0 ticks later)
\nSVC DOWN CMD : “\/Tibero\/tas\/tibero6\/scripts\/cm_down_cmd.sh”
\nCONTROL FILE No.0 (A): +0 (512 byte\/block)[VALID]
\nCONTROL FILE No.1 (A): +1 (512 byte\/block)[VALID]
\nCONTROL FILE No.2 (A): +2 (512 byte\/block)[VALID]
\nCONTROL FILE EXPIRE: 30 ticks later
\nLOG LEVEL : 2
\n======================= CLUSTER STATUS =========================
\nINCARNATION_NO : 1 (COMMIT 1)
\nFILE HEADER SIZE : 1024 bytes ( 512 byte-block )
\n# of NODES : 1 nodes (LAST_ID = 101)
\nMASTER NODE : [101] cm@192.168.56.21:20005
\nMEMBERSHIP : AUTO (SPLIT)
\nNODE LIST… (R:role, Scd:scheduled, F\/O: index of VIP failover node)
\nH\/B F\/O VIP
\nIdx R Scd Node Status offset Idx Alias ID Name
\n— – — ————— —— — —— — —————
\n#0 M ON NODE ACTIVE 1024 N\/A N\/A 101 cm@192.168.56.21:20005
\n===================== OTHER NODE STATUS ========================
\n[\/crayon]<\/p>\n

[crayon]tbboot
\ntbsql sys\/tibero
\nALTER DISKSPACE ds0 ADD THREAD 1;
\n[\/crayon]<\/p>\n

node _ 2
\n[crayon]TB_SID=tas2
\ntbcm -b
\ntbboot
\n[\/crayon]<\/p>\n

checking node 2
\n[crayon][tibero@node2 log]$ tbcm -s
\n======================= LOCAL STATUS ===========================
\nNODE NAME : [102] cm@192.168.56.22:20005
\nCLUSTER MODE : ACTIVE_SHARED (GUARD ON, FENCE OFF)
\nSTATUS : SERVICE ACTIVE
\nINCARNATION_NO : 4 (ACK 4, COMMIT 4)
\nHEARTBEAT PERIOD : 30 ticks (1 tick = 1000000 micro-sec)
\nSVC PROBE PERIOD : 10 ticks (expires 10 ticks later)
\nSVC DOWN CMD : “\/Tibero\/tas\/tibero6\/scripts\/cm_down_cmd.sh”
\nCONTROL FILE No.0 (A): +0 (512 byte\/block)[VALID]
\nCONTROL FILE No.1 (A): +1 (512 byte\/block)[VALID]
\nCONTROL FILE No.2 (A): +2 (512 byte\/block)[VALID]
\nCONTROL FILE EXPIRE: 29 ticks later
\nLOG LEVEL : 2
\n======================= CLUSTER STATUS =========================
\nINCARNATION_NO : 4 (COMMIT 4)
\nFILE HEADER SIZE : 1024 bytes ( 512 byte-block )
\n# of NODES : 2 nodes (LAST_ID = 102)
\nMASTER NODE : [101] cm@192.168.56.21:20005
\nMEMBERSHIP : AUTO (SPLIT)
\nNODE LIST… (R:role, Scd:scheduled, F\/O: index of VIP failover node)
\nH\/B F\/O VIP
\nIdx R Scd Node Status offset Idx Alias ID Name
\n— – — ————— —— — —— — —————
\n#0 M ON SERVICE ACTIVE 1024 N\/A N\/A 101 cm@192.168.56.21:20005
\n#1 S ON SERVICE ACTIVE 1536 N\/A N\/A 102 cm@192.168.56.22:20005
\n===================== OTHER NODE STATUS ========================
\nSEQ (NAME) : #0 ([101] cm@192.168.56.21:20005)
\nSTATUS (CONN.) : SERVICE ACTIVE (CONNECTED)
\nNET ADDR (PORT) : 192.168.56.21 (20005)
\n[\/crayon]<\/p>\n

Step_15 creating data disk groups (on one node)<\/strong>
\n[crayon]CREATE DISKSPACE DATA1 NORMAL REDUNDANCY
\nFAILGROUP fg1 DISK
\n‘\/dev\/sde1’ NAME sde1
\nFAILGROUP fg2 DISK
\n‘\/dev\/sdf1’ NAME sdf1
\nATTRIBUTE ‘AU_SIZE’=’1M’;
\n[\/crayon]<\/p>\n

[crayon]CREATE DISKSPACE RA1 NORMAL REDUNDANCY
\nFAILGROUP fg1 DISK
\n‘\/dev\/sdg1’ NAME sdg1
\nFAILGROUP fg2 DISK
\n‘\/dev\/sdh1’ NAME sdh1
\nATTRIBUTE ‘AU_SIZE’=’1M’;
\n[\/crayon]<\/p>\n

log files
\n[crayon]\/Tibero\/tas\/tibero6\/instance\/as0\/log\/cm\/cmd.log
\n\/Tibero\/tas\/tibero6\/instance\/as0\/log\/cm\/trace_list.log
\n[\/crayon]<\/p>\n

TAS Monitoring
\n[crayon]select * from V$TAS_ALIAS;
\nselect * from V$TAS_DISKSPACE;
\nselect * from V$TAS_DISK_STAT;
\nselect * from V$TAS_DISKSPACE_STAT;
\nselect * from V$TAS_FILE;
\nselect * from V$TAS_DISK;
\n[\/crayon]<\/p>\n

 <\/p>\n

Tibero Active Cluster Steps<\/strong><\/span>
\nStep_16 extracting binaries (on all nodes)<\/strong>
\n[crayon]tar -xvf \/Data\/SetUp\/tibero6-bin-FS02-linux64-114545-opt-20151210192436-tested.tar.gz -C \/Tibero\/tac\/
\nchmod -Rf g+rwx \/Tibero\/tac
\nsh \/Tibero\/tac\/tibero6\/config\/gen_tip.sh
\n[\/crayon]<\/p>\n

Step_17 tac parameter file<\/strong>
\nnode_1
\nvim \/Tibero\/tac\/tibero6\/config\/tac1.tip<\/p>\n

[crayon]DB_NAME=tbrdb
\nLISTENER_PORT=8620
\nCONTROL_FILES=”+DATA1\/c1.ctl”
\nUSE_TAS=Y
\nTAS_PORT=9620
\nDB_CREATE_FILE_DEST=”+DATA1″
\nLOG_ARCHIVE_DEST=”+RA1″
\nMAX_SESSION_COUNT=20
\nTOTAL_SHM_SIZE=512M
\nMEMORY_TARGET=1G
\nCLUSTER_DATABASE=Y
\nLOCAL_CLUSTER_ADDR=192.168.56.21
\nLOCAL_CLUSTER_PORT=8625
\nTHREAD=0
\nUNDO_TABLESPACE=UNDO0
\nCM_CLUSTER_MODE=ACTIVE_SHARED
\nCM_FILE_NAME=”+DS0\/tbcm”
\nCM_PORT=8630
\nCM_HEARTBEAT_EXPIRE=15
\nCM_WATCHDOG_EXPIRE=10
\nCM_NET_EXPIRE_MARGIN=5
\n[\/crayon]<\/p>\n

node_2
\nvim \/Tibero\/tac\/tibero6\/config\/tac2.tip<\/p>\n

[crayon]DB_NAME=tbrdb
\nLISTENER_PORT=8620
\nCONTROL_FILES=”+DATA1\/c1.ctl”
\nUSE_TAS=Y
\nTAS_PORT=9620
\nDB_CREATE_FILE_DEST=”+DATA1″
\nLOG_ARCHIVE_DEST=”+RA1″
\nMAX_SESSION_COUNT=20
\nTOTAL_SHM_SIZE=512M
\nMEMORY_TARGET=1G
\nCLUSTER_DATABASE=Y
\nLOCAL_CLUSTER_ADDR=192.168.56.22
\nLOCAL_CLUSTER_PORT=8625
\nTHREAD=1
\nUNDO_TABLESPACE=UNDO1
\nCM_CLUSTER_MODE=ACTIVE_SHARED
\nCM_FILE_NAME=”+DS0\/tbcm”
\nCM_PORT=8630
\nCM_HEARTBEAT_EXPIRE=15
\nCM_WATCHDOG_EXPIRE=10
\nCM_NET_EXPIRE_MARGIN=5
\n[\/crayon]<\/p>\n

Step_18 tbdsn.tbr (tnsname.ora)<\/strong>
\nNode _ 1
\nvim \/Tibero\/tibero6\/client\/config\/tbdsn.tbr<\/p>\n

[crayon]tac1=(
\n(INSTANCE=(HOST=localhost)
\n(PORT=8620)
\n(DB_NAME=tbrdb)
\n)
\n)
\n[\/crayon]<\/p>\n

node _ 2
\n[crayon]tac2=(
\n(INSTANCE=(HOST=localhost)
\n(PORT=8620)
\n(DB_NAME=tbrdb)
\n)
\n)
\n[\/crayon]<\/p>\n

Step_19 license file (on all nodes)<\/strong>
\n[crayon]cp \/Tibero\/tas\/tibero6\/license\/license.xml \/Tibero\/tac\/tibero6\/license\/
\n[\/crayon]<\/p>\n

Step_20 starting up tac instance<\/strong>
\non node _ 1<\/p>\n

[crayon]tbcm \u2013c —-> success
\ntbcm \u2013b LOCK
\ntbboot -t nomount \u2013c
\ntbsql sys\/tibero
\n[\/crayon]<\/p>\n

Step_21 creating database<\/strong>
\n[crayon]create database
\ncharacter set WE8ISO8859P9
\nlogfile group 1 size 20m,
\ngroup 2 size 20m,
\ngroup 3 size 20m
\narchivelog
\ndatafile ‘system001.dtf’ size 100m
\nautoextend on next 10m
\ndefault temporary tablespace temp
\ntempfile ‘temp001.dtf’ size 100m
\nautoextend on next 10m
\nundo tablespace undo0
\ndatafile ‘undo001.dtf’ size 200m
\nautoextend on next 10m
\ndefault tablespace usr
\ndatafile ‘usr001.dtf’ size 100m
\nautoextend on next 10m
\n[\/crayon]<\/p>\n

[crayon]tbboot
\n[\/crayon]<\/p>\n

Step_22 creating undo01 and redologs (on node one)<\/strong>
\n[crayon]tbsql sys\/tibero
\nCREATE UNDO TABLESPACE UNDO1
\nDATAFILE ‘undo011.dtf’ SIZE 200M
\nAUTOEXTEND ON NEXT 50M ;
\nALTER DATABASE ADD LOGFILE THREAD 1 GROUP 4 size 20M;
\nALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 size 20M;
\nALTER DATABASE ADD LOGFILE THREAD 1 GROUP 6 size 20M;
\nALTER DATABASE ENABLE PUBLIC THREAD 1;
\n[\/crayon]<\/p>\n

Step_23 executing system.sh (on node one)<\/strong>
\n[crayon]$TB_HOME\/scripts\/system.sh
\nsys –> tibero
\nsyscat –> syscat
\n[\/crayon]<\/p>\n

Step_24 checking what’s happened<\/strong>
\n[crayon]cat \/Tibero\/tibero6\/instance\/tac1\/log\/system_init.log
\n[\/crayon]<\/p>\n

[crayon]col member for a30
\nSelect * from v$logfile;
\nGROUP# STATUS TYPE MEMBER
\n———- ——- —— ——————————
\n1 ONLINE +DATA1\/log001.log
\n2 ONLINE +DATA1\/log002.log
\n3 ONLINE +DATA1\/log003.log
\n4 ONLINE +DATA1\/log004.log
\n5 ONLINE +DATA1\/log005.log
\n6 ONLINE +DATA1\/log006.log<\/p>\n

6 rows selected.
\n[\/crayon]<\/p>\n

[crayon]col db_name for a10
\nselect instance_name, db_name,version, status from v$instance;
\nINSTANCE_NAME DB_NAME VERSION STATUS
\n————————————–
\ntac1 tbrdb 6 NORMAL
\n[\/crayon]<\/p>\n

[crayon]col owner for a10
\nselect owner from dba_objects where object_name =’DATABASE_PROPERTIES’;
\nOWNER
\n———-
\nPUBLIC
\nSYSCAT
\n2 rows selected.
\n[\/crayon]<\/p>\n

[crayon]set lin 200
\ncol name for a30
\ncol value for a15
\ncol comment_str for a40
\nselect * from database_properties;
\nNAME VALUE COMMENT_STR
\n——————————————————
\nDFLT_PERM_TS USR Name of default permanent tablespace
\nDFLT_TEMP_TS TEMP Name of default temporary tablespace
\nDFLT_UNDO_TS UNDO0 Name of default undo tablespace
\nNLS_CHARACTERSET WE8ISO8859P9
\nNLS_NCHAR_CHARACTERSET UTF16
\nDB_NAME tbrdb database name
\n[\/crayon]<\/p>\n

Step_24 starting node2<\/strong>
\nnode _ 1
\n[crayon]tbdown
\ntbcm -d<\/p>\n

tbcm -b
\ntbboot
\n[\/crayon]<\/p>\n

node _ 2
\n[crayon]tbcm \u2013b
\ntbboot
\n[\/crayon]<\/p>\n

[crayon][tibero@node2 ~]$ tbcm -s
\n======================= LOCAL STATUS ===========================
\nNODE NAME : [102] cm@192.168.56.22:8630
\nCLUSTER MODE : ACTIVE_SHARED (GUARD ON, FENCE OFF)
\nSTATUS : SERVICE ACTIVE
\nINCARNATION_NO : 4 (ACK 4, COMMIT 4)
\nHEARTBEAT PERIOD : 15 ticks (1 tick = 1000000 micro-sec)
\nSVC PROBE PERIOD : 10 ticks (expires 10 ticks later)
\nSVC DOWN CMD : “\/Tibero\/tac\/tibero6\/scripts\/cm_down_cmd.sh”
\nCONTROL FILE (A) : +DS0\/tbcm (512 byte\/block)
\nCONTROL FILE EXPIRE: 14 ticks later
\nLOG LEVEL : 2
\n======================= CLUSTER STATUS =========================
\nINCARNATION_NO : 4 (COMMIT 4)
\nFILE HEADER SIZE : 1024 bytes ( 512 byte-block )
\n# of NODES : 2 nodes (LAST_ID = 102)
\nMASTER NODE : [101] cm@192.168.56.21:8630
\nMEMBERSHIP : AUTO (SPLIT)
\nNODE LIST… (R:role, Scd:scheduled, F\/O: index of VIP failover node)
\nH\/B F\/O VIP
\nIdx R Scd Node Status offset Idx Alias ID Name
\n— – — ————— —— — —— — —————
\n#0 M ON SERVICE ACTIVE 1024 N\/A N\/A 101 cm@192.168.56.21:8630
\n#1 S ON SERVICE ACTIVE 1536 N\/A N\/A 102 cm@192.168.56.22:8630
\n===================== OTHER NODE STATUS ========================
\nSEQ (NAME) : #0 ([101] cm@192.168.56.21:8630)
\nSTATUS (CONN.) : SERVICE ACTIVE (CONNECTED)
\nNET ADDR (PORT) : 192.168.56.21 (8630)
\n[\/crayon]
\nFailover Tests<\/p>\n

\/Tibero\/tibero6\/client\/config\/tbdsn.tbr<\/p>\n

[crayon]tac =(
\n(INSTANCE=(HOST=192.168.10.23)
\n(PORT=8620)
\n(DB_NAME=tbrdb)
\n)<\/p>\n

(INSTANCE=(HOST=192.168.10.24)
\n(PORT=8620)
\n(DB_NAME=tbrdb)
\n)
\n(LOAD_BALANCE=Y)
\n(USE_FAILOVER=Y)
\n)
\n[\/crayon]<\/p>\n

Profiles
\n####################################################
\n####################################################
\n[crayon]
\n# .bash_profile
\n# Get the aliases and functions<\/p>\n

if [ -f ~\/.bashrc ]; then
\n. ~\/.bashrc
\nfi<\/p>\n

# User specific environment and startup programs<\/p>\n

PATH=$PATH:$HOME\/bin:\/sbin<\/p>\n

export PATH
\n####################################################
\n####################################################<\/p>\n

echo “Enter your Choice”
\necho “1) Tibero TAC – node1”
\necho “2) Tibero TAC – tas1”
\nread ans<\/p>\n

if [ $ans -eq ‘1’ ]; then
\n######## TIBERO ENV ########
\nexport TB_HOME=\/Tibero\/tac\/tibero6
\nexport TB_SID=node1
\nexport TB_PROF_DIR=$TB_HOME\/bin\/prof
\nexport PATH=.:$TB_HOME\/bin:$TB_HOME\/client\/bin:~\/tbinary\/monitor:$PATH
\nexport LD_LIBRARY_PATH=$TB_HOME\/lib:$TB_HOME\/client\/lib:$LD_LIBRARY_PATH
\nexport SHLIB_PATH=$LD_LIBRARY_PATH:$SHLIB_PATH
\nexport LIBPATH=$LD_LIBRARY_PATH:$LIBPATH
\n######## TIBERO alias ########
\nalias tbhome=’cd $TB_HOME’
\nalias tbbin=’cd $TB_HOME\/bin’
\nalias tblog=’cd $TB_HOME\/instance\/$TB_SID\/log’
\nalias tbcfg=’cd $TB_HOME\/config’
\nalias tbcfgv=’vi $TB_HOME\/config\/$TB_SID.tip’
\nalias tbcli=’cd ${TB_HOME}\/client\/config’
\nalias tbcliv=’vi ${TB_HOME}\/client\/config\/tbdsn.tbr’
\n#alias tbcliv=’vi ${TB_HOME}\/client\/config\/tbnet_alias.tbr’alias tbi=’cd ~\/tbinary’
\n#alias clean=’tbdown clean’
\n#alias dba=’tbsql sys\/tibero’
\nalias tm=’cd ~\/tbinary\/monitor;monitor;cd -‘
\n#alias tbdata=’cd $TB_HOME\/tbdata’
\n####################################################
\n####################################################
\nelif [ $ans -eq ‘2’ ]; then<\/p>\n

######## TIBERO ENV ########
\nexport TB_HOME=\/Tibero\/tas\/tibero6
\nexport TB_SID=tas1
\nexport TB_PROF_DIR=$TB_HOME\/bin\/prof
\nexport PATH=.:$TB_HOME\/bin:$TB_HOME\/client\/bin:~\/tbinary\/monitor:$PATH
\nexport LD_LIBRARY_PATH=$TB_HOME\/lib:$TB_HOME\/client\/lib:$LD_LIBRARY_PATH
\nexport SHLIB_PATH=$LD_LIBRARY_PATH:$SHLIB_PATH
\nexport LIBPATH=$LD_LIBRARY_PATH:$LIBPATH
\n######## TIBERO alias ########
\nalias tbhome=’cd $TB_HOME’
\nalias tbbin=’cd $TB_HOME\/bin’
\nalias tblog=’cd $TB_HOME\/instance\/$TB_SID\/log’
\nalias tbcfg=’cd $TB_HOME\/config’
\nalias tbcfgv=’vi $TB_HOME\/config\/$TB_SID.tip’
\nalias tbcli=’cd ${TB_HOME}\/client\/config’
\nalias tbcliv=’vi ${TB_HOME}\/client\/config\/tbdsn.tbr’
\n#alias tbcliv=’vi ${TB_HOME}\/client\/config\/tbnet_alias.tbr’alias tbi=’cd ~\/tbinary’
\n#alias clean=’tbdown clean’
\n#alias dba=’tbsql sys\/tibero’
\nalias tm=’cd ~\/tbinary\/monitor;monitor;cd -‘
\n#alias tbdata=’cd $TB_HOME\/tbdata’
\nelse
\necho “Tibero Environment Not Set ! ! !”
\nfi
\n####################################################
\n####################################################
\n[\/crayon]<\/p>\n

Log
\n[crayon]alias tracelog=”tail -f ${TB_HOME}\/instance\/tas1\/log\/tracelog\/trace.log”
\nalias dbmslog=”tail -f ${TB_HOME}\/instance\/tas1\/log\/dbmslog\/dbms.log”
\nalias listenerlog=”tail -f ${TB_HOME}\/instance\/tas1\/log\/lsnr\/trace_list.log”
\nalias tracelistlog=”tail -f ${TB_HOME}\/instance\/tas1\/log\/cm\/trace_list.log”
\nalias th=’cd $TB_HOME’<\/p>\n

[crayon]alias tbbin=”cd ${TB_HOME}\/bin”
\nalias tblog=”cd ${TB_HOME}\/instance\/$TB_SID\/log”
\nalias tbcfg=”cd ${TB_HOME}\/config”
\nalias tbcfgv=”vi ${TB_HOME}\/config\/$TB_SID.tip”
\nalias tbcli=”cd ${TB_HOME}\/client\/config”
\nalias tbcliv=”vi ${TB_HOME}\/client\/config\/tbdsn.tbr”
\n#alias tbcliv=’vi ${TB_HOME}\/client\/config\/tbnet_alias.tbr’ #alias tbdata=’cd $TB_HOME\/tbdata’
\nalias tbi=’cd ~\/tbinary’
\nalias clean=’tbdown clean’
\nalias dba=’tbsql sys\/tibero’
\nalias tbps=”ps -ef |grep tbs”<\/p>\n

##########################
\nalias c=’clear’
\nalias ls=’ls -h –color’
\nalias lx=’ls -lXB’ # Sort by extension.
\nalias lk=’ls -lSr’ # Sort by size, biggest last.
\nalias lt=’ls -ltr’ # Sort by date, most recent last.
\nalias lc=’ls -ltcr’ # Sort by\/show change time,most recent last.
\nalias lu=’ls -ltur’ # Sort by\/show access time,most recent last.<\/p>\n

# The ubiquitous ‘ll’: directories first, with alphanumeric sorting:
\nalias ll=”ls -lv –group-directories-first”
\nalias lm=’ll |more’ # Pipe through ‘more’
\nalias lr=’ll -R’ # Recursive ls.
\nalias la=’ll -A’ # Show hidden files.
\nalias tree=’tree -Csuh’ # Nice alternative to ‘recursive ls’ …
\n[\/crayon]<\/p>\n","protected":false},"excerpt":{"rendered":"

Finally another RDBMS solution is supporting active active cluster like Oracle’s RAC. <\/p>\n","protected":false},"author":1,"featured_media":2731,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[352,338],"tags":[345],"class_list":["post-2728","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-high-availability","category-oracle-tr","tag-oracle"],"_links":{"self":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/comments?post=2728"}],"version-history":[{"count":0,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2728\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/media?parent=2728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/categories?post=2728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/tags?post=2728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}