Skip to main content

Search

Welcome to Tibero GTS!

Issue of DB Not Reflecting OS Timezone Change

Document Type | Troubleshooting 

Category | Administration

Applicable Product Versions | 5SP1FS01, 5SP1FS02, 5SP1FS03, 5SP1FS04, 5SP1FS06, 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS

Document Number | TADTS046

 

Issue

This explains the phenomenon where the OS timezone and DB timezone differ, and although the OS timezone is changed, it is not reflected in the DB. 
Note
The OS timezone and DB time are based on Linux.
 

Cause

Tibero reads the OS timezone at the time of installation. Therefore, even if the OS timezone is changed after installation, it will not be reflected in the DB. 

 

Solutions

You need to recreate the control file so that the changed timezone is read. 

 

1. Create a backup of the control file

tbSQL 7

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

Connected to Tibero.

SQL> alter database backup controlfile to trace as 'ctl_bak.sql' reuse noresetlogs;

Database altered.

 

2. Boot in nomount mode and recreate the control file

[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbboot nomount
Change core dump dir to /sdiske/ps1/tuning/tibero7/bin/prof.
Listener port = 1188

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (NOMOUNT mode).
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> @ctl_bak.sql

Control File created.

SQL> quit
Disconnected.

 

3. Boot in mount mode and perform media recovery

[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbdown immediate

Tibero instance terminated (IMMEDIATE mode).

[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbboot mount
Change core dump dir to /sdiske/ps1/tuning/tibero7/bin/prof.
Listener port = 1188

Tibero 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Tibero instance started up (MOUNT mode).
[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> alter database recover automatic;

Database altered.

SQL> quit
Disconnected.

 

4. Boot in normal mode and recreate the temp file

[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbboot
Change core dump dir to /sdiske/ps1/tuning/tibero7/bin/prof.
Listener port = 1188

Tibero 7

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

[ps1@psdblcbp:/sdiske/ps1/tuning]$ tbsql sys/tibero

tbSQL 7

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

Connected to Tibero.

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/sdiske/ps1/tuning/tbdata/temp001.dtf' SIZE 7332M REUSE AUTOEXTEND ON NEXT 16M MAXSIZE 32G;

Tablespace 'TEMP' altered.

 

 
 

Related to