Home » RDBMS Server » Server Administration » ORA-01805 Timezone files error
ORA-01805 Timezone files error [message #684685] Mon, 26 July 2021 04:00 Go to next message
db_senior
Messages: 10
Registered: July 2021
Junior Member
Hi,
The Oracle version of both client and server is 19c. but the timezone file seems to be different.

DB SERVER:
SQL> select * from v$timezone_file;

FILENAME                VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_32.dat              32          0

[oracle@db-prd1 ~]$ genezi -v
Client Shared Library 64-bit - 19.3.0.0.0

System name:    Linux
Release:        3.10.0-1160.24.1.el7.x86_64
Version:        #1 SMP Thu Mar 25 21:21:56 UTC 2021
Machine:        x86_64

TIMEZONE INFORMATION
--------------------
Operating in ORACLE_HOME environment.

Small timezone file = /oracle/193/product/db_home/oracore/zoneinfo/timezone_32.dat
Large timezone file = /oracle/193/product/db_home/oracore/zoneinfo/timezlrg_32.dat

On CLIENT the VERSION is 34


How to fix this issue? What are the steps to upgrade the Oracle DB server to version 34?
ORA-01805 Timezone files error [message #684686 is a reply to message #684685] Mon, 26 July 2021 04:01 Go to previous messageGo to next message
db_senior
Messages: 10
Registered: July 2021
Junior Member
Hi,
The Oracle version of both client and server is 19c. but the timezone file seems to be different.

DB SERVER:
SQL> select * from v$timezone_file;

FILENAME                VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_32.dat              32          0

[oracle@db-prd1 ~]$ genezi -v
Client Shared Library 64-bit - 19.3.0.0.0

System name:    Linux
Release:        3.10.0-1160.24.1.el7.x86_64
Version:        #1 SMP Thu Mar 25 21:21:56 UTC 2021
Machine:        x86_64

TIMEZONE INFORMATION
--------------------
Operating in ORACLE_HOME environment.

Small timezone file = /oracle/193/product/db_home/oracore/zoneinfo/timezone_32.dat
Large timezone file = /oracle/193/product/db_home/oracore/zoneinfo/timezlrg_32.dat

On CLIENT the VERSION is 34


How to fix this issue? What are the steps to upgrade the Oracle DB server to version 34?

Thanks!
Re: ORA-01805 Timezone files error [message #684687 is a reply to message #684686] Mon, 26 July 2021 10:18 Go to previous messageGo to next message
EdStevens
Messages: 1339
Registered: September 2013
Senior Member
There's nothing to fix. Timezone file versions are incremented as new timezone files are released. They are not meant to track map directly to db version numbers. Their numbering is completely unrelated to db server version numbers. In general you should always have the 'latest' timezone file, and that will _always_ be a higher number than the db version.

Quote:
What are the steps to upgrade the Oracle DB server to version 34?
There are none. There is no db server version 34.

Re: ORA-01805 Timezone files error [message #684688 is a reply to message #684687] Mon, 26 July 2021 10:28 Go to previous messageGo to next message
db_senior
Messages: 10
Registered: July 2021
Junior Member
EdStevens wrote on Mon, 26 July 2021 10:18
There's nothing to fix. Timezone file versions are incremented as new timezone files are released. They are not meant to track map directly to db version numbers. Their numbering is completely unrelated to db server version numbers. In general you should always have the 'latest' timezone file, and that will _always_ be a higher number than the db version.

Quote:
What are the steps to upgrade the Oracle DB server to version 34?
There are none. There is no db server version 34.

Seems there is a patch for tz34: Patch 29997937: RDBMS - DSTV34 UPDATE - TZDATA2019B
Re: ORA-01805 Timezone files error [message #684689 is a reply to message #684688] Mon, 26 July 2021 11:46 Go to previous message
EdStevens
Messages: 1339
Registered: September 2013
Senior Member
Sure, there are patches to upgrade the tz file. But you were asking about upgrading "the Oracle DB server"

Ok, after re-reading, and re-re-re-reading your original post, I see that it could be interpreted as asking to upgrade the TZ file that is on the db server, whereas I thought you were asking about upgrading the db server (as in the database) itself.

With that observation, I'd say two things:
1) It never hurts to upgrade the TZ file.
2) I don't believe there is any issue with client and server having different TZ file versions. There is certainly no problem with the client itself being a different version from the database. Oracle supports client and database versions being up to two major release versions apart, so I can't imagine there being an issue with the TZ file.
Previous Topic: Too many parse error with error-12850
Next Topic: Unified Auditing Trail to find grants of privileges on an object
Goto Forum:
  


Current Time: Mon Sep 20 04:18:25 CDT 2021