Document Type | Technical Information

Category | Administration

Applicable Product Version | Tibero 7.2.2

Document Number | TADTI157

Overview

This document contains the basic startup and shutdown procedures for users who are new to Tibero after installation.

It can be configured as Single / TAC / TSC, and the startup/shutdown procedures differ depending on the configuration method, so please check the startup method that matches your configuration.

Note

For various startup/shutdown options and explanations, please refer to the manual.

Go to Tibero Manual and Guide Document

Method

Single

This is a DB configured with a single instance.

Startup

Order		Script
1	Tibero	$ tbboot

Example

tb7@edu1[tb7]:/home/tb7> tbboot
Change core dump dir to /home/tb7/tibero7/bin/prof.
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

Shutdown

Order		Script
1	Tibero	$ tbdown immediate

Example

tb7@edu1[tb7]:/home/tb7> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

TAC

This is a DB configured with multiple instances in a single database. It is divided into cases where TAS (Tibero Active Storage) is used and not used.

without TAS

Startup

Order		User	Script
1	Cluster Manager	root	$ tbcm –b
2	Tibero	Tibero installation user	$ tbboot

Example

# Node1

root@edu1:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm0_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm0:11039).

root@edu1:/root> su - tibero
tibero@edu1[tac1]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

# Node2

root@edu2:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm1_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm1:11039).

root@edu2:/root> su - tibero
tibero@edu2[tac2]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

Shutdown

Order		User	Script
1	Cluster Manager	Tibero installation user	$ tbdown immediate
2	Tibero	Tibero installation user	$ tbcm -d

Example

# Node1

tibero@edu1[tac1]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

tibero@edu1[tac1]:/home/tibero> tbcm -d
CM DOWN SUCCESS!

# Node2

tibero@edu2[tac2]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

tibero@edu2[tac2]:/home/tibero> tbcm -d
CM DOWN SUCCESS!

using TAS

Startup

Order		Case	User	Script
1	CM	Common	root	$ tbcm –b
2	TAS	Using cmrctl	Tibero installation user	$ cmrctl start as --name <AS1_Name>
		Using Tibero command
		Remote other nodes		$ export TB_SID=<AS1_Name> $ tbboot
				$ cmrctl start as --name <AS2_Name> --remote <CM2_SID>@<Cluster_Name>
3	TAC	Using cmrctl	root	$ cmrctl start db --name <DB1_Name>
		Using Tibero command	Tibero installation user	$ export TB_SID=<DB1_Name> $ tbboot
		Remote other nodes		$ cmrctl start db --name <DB2_Name> --remote <CM2_SID>@<Cluster_Name>

Example

# Node1

# Common
root@edu1:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm0_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm0:11039).

root@edu1:/root> su - tibero

# Case 1 Using cmrctl command

tibero@edu1[tac1]:/home/tibero> cmrctl start as --name tas1
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)

tibero@edu1[tac1]:/home/tibero> cmrctl start db --name tac1
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)

# Case 2 
tibero@edu1[tac1]:/home/tibero> export TB_SID=tas1
tibero@edu1[tas1]:/home/tibero> tbboot
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

tibero@edu1[tas1]:/home/tibero> export TB_SID=tac1
tibero@edu1[tac1]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

# Case 3 Remote boot other nodes

tibero@edu1[tac1]:/home/tibero> cmrctl start as --name tas2 --remote cm2@cluster1
BOOT SUCCESS! (MODE : NORMAL)

tibero@edu1[tac1]:/home/tibero> cmrctl start db --name tac2 --remote cm2@cluster1
BOOT SUCCESS! (MODE : NORMAL)

# Node2

# Common
root@edu2:/root> tbcm -b
CM Guard daemon started up.
import resources from '/home/tb7/tibero7/config/cm1_res.crf'...

TBCM 7.1.1 (Build 285045)

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Tibero cluster manager started up.
Local node name is (cm1:11039).

root@edu2:/root> su - tibero


# Case 1 Using cmrctl command

tibero@edu2[tas2]:/home/tibero> cmrctl start as --name tas2
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

tibero@edu2[tas2]:/home/tibero> cmrctl start db --name tac2
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).
BOOT SUCCESS! (MODE : NORMAL)

# Case 2

tibero@edu2[tac2]:/home/tibero> export TB_SID=tas2
tibero@edu2[tas2]:/home/tibero> tbboot
Listener port = 18629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

tibero@edu2[tas2]:/home/tibero> export TB_SID=tac2
tibero@edu2[tac2]:/home/tibero> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

Shutdown

Order		Case	User	Script
1	TAC	Using cmrctl	Tibero installation user	$ cmrctl stop db --name <DB1_Name>
		Using Tibero command		$ export TB_SID=<DB1_Name> $ tbdown immediate
		Remote other nodes		$ cmrctl stop db --name <DB2_Name> --remote <CM2_SID>@<Cluster_Name>
2	TAS	Using cmrctl	Tibero installation user	$ cmrctl stop as --name <AS1_Name>
		Using Tibero command		$ export TB_SID=<AS1_Name> $ tbdown immediate
		Remote other nodes		$ cmrctl stop as --name <AS2_Name> --remote <CM2_SID>@<Cluster_Name>
3	CM	Common	root	$ tbcm –d

Example

# Node1

# Case 1 Using cmrctl command

tibero@edu1[tac1]:/home/tibero> cmrctl stop db --name tac1
MSG SENDING SUCCESS! 
tibero@edu1[tac1]:/home/tibero> cmrctl stop as --name tas1
MSG SENDING SUCCESS!

# Case 2
tibero@edu1[tac1]:/home/tibero> export TB_SID=tac1
tibero@edu1[tac1]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

tibero@edu1[tac1]:/home/tibero> export TB_SID=tas1
tibero@edu1[tas1]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

# Case 3 Remote down other nodes
tibero@edu1[tac1]:/home/tibero> cmrctl stop db --name tac2 --remote cm2@cluster1
MSG SENDING SUCCESS! 
tibero@edu1[tac1]:/home/tibero> cmrctl stop as --name tas2 --remote cm2@cluster1
MSG SENDING SUCCESS!

# Common
tibero@edu1[tas1]:/home/tibero> exit
logout
root@edu1:/root> tbcm -d
CM DOWN SUCCESS!

# Node2

# Case 1 Using cmrctl command
tibero@edu2[tac2]:/home/tibero> cmrctl stop db --name tac2
MSG SENDING SUCCESS! 
tibero@edu2[tac2]:/home/tibero> cmrctl stop as --name tas2
MSG SENDING SUCCESS!

# Case 2
tibero@edu2[tac2]:/home/tibero> export TB_SID=tac2
tibero@edu2[tac2]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

tibero@edu2[tac2]:/home/tibero> export TB_SID=tas2
tibero@edu2[tas2]:/home/tibero> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).              

# Common
tibero@edu2[tas2]:/home/tibero> exit
logout
root@edu2:/root> tbcm -d
CM DOWN SUCCESS!

SSVR+TAS+TAC

This is the startup/shutdown sequence when configured with SSVR.

Startup

Order		Case	User	Script
1	SSVR	Common	root	$ tbboot mount ( * 1..n )
2	CM	Common	root	$ tbcm –b
3	TAS	Using cmrctl	Tibero installation user	$ cmrctl start as --name <AS1_Name>
		Using Tibero command		$ export TB_SID=<AS1_Name> $ tbboot
		Remote other nodes		$ cmrctl start as --name <AS2_Name> --remote <CM2_SID>@<Cluster2_Name>
4	TAC	Using cmrctl	Tibero installation user	$ cmrctl start db --name <DB1_Name>
		Using Tibero command		$ export TB_SID=<DB1_Name> $ tbboot
		Using Tibero command		$ cmrctl start db --name <DB2_Name> --remote <CM2_SID>@<Cluster_Name>

Example

ssvr@SSVR1:/home/ssvr> tbboot mount
Listener port = 9100

Tibero 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (MOUNT mode).

# Perform Startup for SSVR1..n as needed.
# 4.2.2 Using TAS 1) Perform Startup procedure

2. Shutdown

Order		Case	User	Script
1	TAC	Using cmrctl	Tibero installation user	$ cmrctl stop db --name <DB1_Name>
		Using Tibero command		$ export TB_SID=<DB1_Name> $ tbdown immediate
		Using Tibero command		$ cmrctl stop db --name <DB2_Name> --remote <CM2_SID>@<Cluster_Name>
2	TAS	Using cmrctl	Tibero installation user	$ cmrctl stop as --name <AS1_Name>
		Using Tibero command		$ export TB_SID=<AS1_Name> $ tbdown immediate
		Remote other nodes		$ cmrctl stop as --name <AS2_Name> --remote <CM2_SID>@<Cluster_Name>
3	CM	Common	root	$ tbcm –d
4	SSVR	Common	root	$ tbdown immediate

Example

# 4.2.2 Using TAS 2) Perform Shutdown procedure

ssvr@SSVR1:/home/ssvr> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

# Perform Shutdown for SSVR1..n as needed.

TSC

This is the startup and shutdown sequence when configured as Tibero Standby Cluster. Since the standby server operates in recovery mode, it must be started before the active server in actual operation.

Startup

Order		Script
1	Standby	$ tbboot recovery SQL> alter database open read only continue recovery;
2	Active	$ tbboot

Example

# TSC(Standby)

tsc@edu3[tsc:Standby]:/home/tsc> tbboot recovery
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (RECOVERY mode). 

tsc@edu3[tsc:Standby]:/home/tsc> tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> alter database open read only continue recovery;

Database altered.

# TSC(Active)

tsc@edu2[tsc:Active]:/home/tsc> tbboot
Listener port = 8629

Tibero 7  

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NORMAL mode).

Shutdown

Order		Script
1	Standby	$ tbdown immediate
2	Active	$ tbdown immediate

Example

# TSC(Standby)

tsc@edu2[tsc:Standby]:/home/tsc> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).   
 

# TSC(Active)

tsc@edu3[tsc:Active]:/home/tsc> tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

Note

Startup Error

In certain versions of Tibero6 and Tibero7, if there is a record of abnormal shutdown, the following message may appear.

You can start up by following the procedure below.

tibero@edu1[tac1]:/home/tibero> tbboot
***********************************************************
*                     BOOT FAILED.
* Garbage files have not been deleted.
* Please run "tbdown clean" and try again.
***********************************************************

tibero@edu1[tac1]:/home/tibero> tbdown clean

tibero@edu1[tac1]:/home/tibero> tbboot
Listener port = 8629

Tibero 6  

TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).

Related to

Search

Welcome to Tibero GTS!

Tibero Operation Guide (Beginner, Startup-Shutdown Procedures)

Overview

Method

Single

TAC

without TAS

using TAS

SSVR+TAS+TAC

TSC

업무 외 시간 안내

Search

Welcome to Tibero GTS!

Overview

Method

Single

TAC

without TAS

using TAS

SSVR+TAS+TAC

TSC