How to Change TimeZone on OCI Compute and DBCS systems


I was planning to change time zone on my OCI computer servers and the DBCS system. So thought lets share the steps to do the same.

Steps to Change Compute Instance Server TimeZone

1) Make sure all services are stopped.

2) Make sure you are logged in as root.

3) Run command to check the timezones available 

timedatectl list-timezones

Asia/Kolkata

Make a note of the required timezone needed.

4) Change timezone accordingly using below command

timedatectl set-timezone Asia/Kolkata


5) Reboot Server.


Steps to Change DBCS Server TimeZone

1) Login to DBCS server.

2) Stop the database and other services.

3) Run command to check the timezones available 

timedatectl list-timezones

Asia/Kolkata

Make a note of the required timezone needed.

4) Change timezone accordingly using below command

timedatectl set-timezone Asia/Kolkata

5) Switch to grid user.

Verify TZ entry in the file  is located in GRID_HOME/crs/install/s_crsconfig_$HOSTNAME_env.txt


s_crsconfig_funcloud_env.txt

Change the value of TZ to 

TZ=Asia/Kolkata

5) Set the database timezone on OCI

 srvctl setenv database -d orcl_phx2gp -T "TZ=Aisa/Kolkata"

orcl_phx2gp==> this is db unique name

Validate

srvctl getenv database -d orcl_phx2gp

6) Update value in below file

cat /etc/sysconfig/clock
ZONE="Asia/Kolkata"
UTC=true
ARC=false


7) Reboot the server

8) Start the database services on DBCS.

9) Validate the time on database.

SQL> alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

Session altered.

SQL> select sysdate from dual;

SYSDATE
-----------------------------
26-JAN-2023 18:39:47

SQL> !date
Thu Jan 26 18:39:50 IST 2023

10) Check Database scheduler timezone and change accordingly 

SELECT *
FROM   dba_scheduler_global_attribute
 WHERE  attribute_name = 'DEFAULT_TIMEZONE';   


ATTRIBUTE_NAME
------------------------------
VALUE
--------------------------------------------------------------------------------
DEFAULT_TIMEZONE
America/Los_Angeles

exec DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('default_timezone', 'Asia/Kolkata');




If you like please follow and comment