This procedure demonstrates the method to change the time zone setting of an Oracle RDBMS installed on a Linux server. NOTE: Oracle RDBMS by default take the time of the OS which they are installed on. Due to the number and variations LINUX distributions, this procedure may not work on all LINUX installs. This procedure was performed on Oracle Enterprise Linux 7.2 (OEL 7.2).
- Logon to your Linux server as root.
[larry@linux2 ~]$ sudo su
[sudo] password for larry:
[root@linux2 larry]#
- Change user to Oracle software owner and logon to SQLPLUS.
[root@linux2 etc]# su – oracle
Last login: Wed Nov 30 16:36:03 UTC 2016 on pts/1
[oracle@linux2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 30 16:38:13 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
- Show the current date and time zone for the Oracle database with command: select systimestamp from dual;
SQL> select systimestamp from dual;
SYSTIMESTAMP
—————————————————————————
30-NOV-16 04.40.33.575810 PM +00:00
SQL>
- Exit out of SQLPLUS and change user to root.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@linux2 ~]$ su –
Password:
Last login: Wed Nov 30 16:38:00 UTC 2016 on pts/1
[root@linux2 ~]#
- Change to directory /etc
[root@linux2 ~]# cd /etc
[root@linux2 etc]#
- Display the currently set system time with command date.
[root@linux2 etc]# date
Wed Nov 30 12:39:08 UTC 2016
[root@linux2 etc]#
- List the current setting to link /etc/localtime and remove link /etc/localtime, using the “rm –f” command.
[root@linux2 etc]# ls -l localtime
lrwxrwxrwx. 1 root root 23 Nov 30 14:22 localtime -> /usr/share/zoneinfo/UTC
[root@linux2 etc]# rm -rf localtime
[root@linux2 etc]#
- Create new link to directory /usr/share/zoneinfo/<your time zone> with you correct timezone. In this example we are changing to EST.
ln -s /usr/share/zoneinfo/EST localtime
[root@linux2 etc]# ls -l localtime
lrwxrwxrwx. 1 root root 23 Nov 30 09:23 localtime -> /usr/share/zoneinfo/EST
[root@linux2 etc]#
- Execute linux date command to see new timezone.
[root@linux2 etc]# date
Wed Nov 30 11:43:59 EST 2016
[root@linux2 etc]#
- Logon as the oracle software owner and logon to SQLPLUS.
[root@linux2 etc]# su – oracle
Last login: Wed Nov 30 11:41:44 EST 2016 on pts/1
[oracle@linux2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 30 11:45:13 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
- To verify the new timezone update has been completed, execute the SQL statement: select systimestamp from dual;
SQL> select systimestamp from dual;
SYSTIMESTAMP
—————————————————————————
30-NOV-16 11.46.25.722487 AM -05:00
SQL>
- This completes update of timezone for Oracle RDBMS on a Linux platform.
Larry Catt
OCP