Hi, I'm upgrading my CI environment from Instant Client 21.11 to 23.3 and Oracle database version from `gvenzl/oracle-xe:latest` to `gvenzl/oracle-free` docker image, that should be `Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0`.
It gets `ORA-01804: failure to initialize timezone information` as follows. I'm assuming this is due to the timezone version differences.
Please advise.
- Steps to reproduce
```
$ sqlplus system/admin@localhost:1521/freepdb1
SQL*Plus: Release 23.0.0.0.0 - Production on Mon Sep 25 12:14:49 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
SQL> create user foo identified by bar;
User created.
SQL> drop user foo;
drop user foo
*
ERROR at line 1:
ORA-01804: failure to initialize timezone information
Help: https://docs.oracle.com/error-help/db/ora-01804/
SQL>
```
- Oracle instant client 23.3 has the timezone version 42 like `timezone_42.dat` and `timezlrg_42.dat`
```
$ genezi -v
Client Shared Library 64-bit - 23.3.0.23.09
System name: Linux
Release: 5.14.0-284.30.1.el9_2.x86_64
Version: #1 SMP PREEMPT_DYNAMIC Fri Aug 25 09:13:12 EDT 2023
Machine: x86_64
TIMEZONE INFORMATION
--------------------
Operating in Instant Client mode.
Small timezone file = /opt/oracle/instantclient_23_3/oracore/zoneinfo/timezone_42.dat
Large timezone file = /opt/oracle/instantclient_23_3/oracore/zoneinfo/timezlrg_42.dat
LICENSE AGREEMENT
-----------------
Your use of this copy of Oracle Instant Client software product is subject
to, and may not exceed the conditions of use for which you are authorized
under one of the following:
(i) the license or cloud services terms that you accepted when you
obtained the right to use Oracle Instant Client software; or
(ii) the license terms that you agreed to when you placed your order with
Oracle for an Oracle product containing Oracle Instant Client software; or
(iii) the Oracle Instant Client software license terms, if any, included
with the hardware that you acquired from Oracle; or
(iv) the Oracle Technology Network License Agreement (which you
acknowledge you have read and agree to) available at
http://www.oracle.com/technetwork/licenses/distribution-license-152002.html; or, if (i), (ii), (iii), and or (iv) are not applicable, then,
(v) the Oracle Free Use Terms and Conditions available at License.txt.
Oracle's obligations with respect to your use of the Oracle Instant Client,
including, without limitation, obligations to indemnify you, if any, shall
only be as set forth in the specific license under which you are
authorized and choose to use Oracle Instant Client.
$
```
- Oracle database has the timezone version 40 like `timezlrg_40.dat`
```
$ sqlplus system/admin@localhost:1521/FREEPDB1
SQL*Plus: Release 23.0.0.0.0 - Production on Thu Sep 21 10:13:38 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Last Successful login time: Sun May 14 2023 04:50:45 +09:00
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> SELECT * FROM v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_40.dat 40 0
SQL>
```