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: 13
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: 13
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: 1376
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: 13
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 messageGo to next message
EdStevens
Messages: 1376
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.
Re: ORA-01805 Timezone files error [message #685708 is a reply to message #684689] Thu, 10 March 2022 04:28 Go to previous message
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
Senior Member
EdStevens wrote on Mon, 26 July 2021 19:46

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.
I've had issues when I had single node database instance A & B with timezone file v32.
Upgraded A to v34. Tried to migrate data with EXPDP-IMPDP to node B and got an error due to timezone file differences.

Sure, it's good to have timezone files up to date and aligned with each other, but if some are production instances then it creates a necessity to coordinate downtime et.c

So I think that's a consideration to make too, right ?

Andrey
Previous Topic: Deviations in the databases
Next Topic: Large SHARED_POOL_RESERVED_SIZE, inflated V$SQL
Goto Forum:
  


Current Time: Thu Mar 28 06:25:44 CDT 2024