<div>
It seems there is a patch for tz34: 
Patch 29997937: RDBMS - DSTV34 UPDATE - TZDATA2019B
</div>

<div>
It seems that the timezone can also be updated with the DBMS_DST package. <a href="https://oracle-base.com/articles/misc/update-database-time-zone-file" rel="ugc"></a> <a href="https://oracle-base.com/articles/misc/update-database-time-zone-file" rel="ugc">https://oracle-base.com/articles/misc/update-database-time-zone-file</a> What do you think about it?
</div>

<div>
I saw that link as well. &nbsp;I wouldn't be surprised if the path I mentioned above pretty much does the same steps. 
 
From the link you posted, you still need to shutdown and 'startup upgrade' so not sure you are buying anything. 
 
I would just apply to patch and let it do what it does.
</div>

<div>
Patch 29997937 is done just on binary
</div>

engineer

dbadm

<div>
<div class="content wysiwyg-content fr-view">
Hi, The Oracle version of both client and server is 19c. but the timezone file seems to be different. DB SERVER: <pre><code class="code-10 nolinks" id="code-10-29220947-1">SQL&gt; select * from v$timezone_file;


FILENAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VERSION &nbsp; &nbsp; CON_ID
-------------------- ---------- ----------
timezlrg_32.dat &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0


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


System name: &nbsp; &nbsp;Linux
Release: &nbsp; &nbsp; &nbsp; &nbsp;3.10.0-1160.24.1.el7.x86_64
Version: &nbsp; &nbsp; &nbsp; &nbsp;#1 SMP Thu Mar 25 21:21:56 UTC 2021
Machine: &nbsp; &nbsp; &nbsp; &nbsp;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
</code></pre> 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! 
</div>
</div>


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!

ORA-01805 Timezone files on client and server do not match

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.