OraFAQ Forum: Server Administration » ORA-01805 Timezone files error

Home » RDBMS Server » Server Administration » ORA-01805 Timezone files error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01805 Timezone files error [message #684685]

Mon, 26 July 2021 04:00

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:

Code: [Select all] [Show/ hide]

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?

Report message to a moderator

ORA-01805 Timezone files error [message #684686 is a reply to message #684685]

Mon, 26 July 2021 04:01

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:

Code: [Select all] [Show/ hide]

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!

Report message to a moderator

Re: ORA-01805 Timezone files error [message #684687 is a reply to message #684686]

Mon, 26 July 2021 10:18

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.

Report message to a moderator

Re: ORA-01805 Timezone files error [message #684688 is a reply to message #684687]

Mon, 26 July 2021 10:28

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

Report message to a moderator

Re: ORA-01805 Timezone files error [message #684689 is a reply to message #684688]

Mon, 26 July 2021 11:46

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.

Report message to a moderator

Re: ORA-01805 Timezone files error [message #685708 is a reply to message #684689]

Thu, 10 March 2022 04:28

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 03 19:13:10 CDT 2025