Hello,
I have an instruction manual which tells me to keep the time zone file of my Oracle Instant Client equal to the time zone file of the database used.
I found some commands on a googlesearch.
Database ist 11.2
Instant Client is 12.1
select * from v$timezone_file;
results FILENAME = "timezlrg_11.dat"; VERSION = 11
So assume that the time zone file used by the database is timezlrg_11.dat.
With the windows (2012 server) command-tool I navigated to the folder of the instant client and ran:
genezi -v
it reuslts:
Client Shared Library 32-bit - 12.1.0.1.0
Windows NT Version V6.2
CPU : 8 - type 586, 8 Physical Cores
Process Affinity : 0x0x00000000
Memory (Avail/Total): Ph:10233M/20479M, Ph+PgF:11778M/23295M, VA:1832M/2047M VM name : VMWare Version (6)
Operating in Instant Client mode.
Small timezone file = timezone_18.dat
Large timezone file = timezlrg_18.dat
This looks like the version of the instant client, using timezone_18.dat.
The command
echo $ORA_TZ_FILE
gives no result.
I then found the command
set ORA_TZFILE timezlrg.dat
on https://docs.oracle.com/cd/B13789_01/java.101/b10979/instclient.htm
Since this file does not exist I changed the command to:
set ORA_TZFILE timezlrg_11.dat
The command
echo $ORA_TZ_FILE
now results "timezlrg_11.dat".
When running the both commands posted above to get the file-version of database and instant client, exactly the same results as before are given. So changing ORA_TZFILE does not seem to made any changes.
I tried the set-command again with full path to the timezlrg_11.dat laying in "...\product\11.2.0\dbhome_1\oracore\zoneinfo".
But same results as before.
I also recognized, that ders cannot be found any timezlrg_18.dat on file system as the instant client seem to use it.
I think this somewhere internally stored in antother file and not explicitly as timezlrg_18.dat.
I no am going to install an older version of the instant client, thinking the 12_1 isn compatible downwards.
So I also want to "unset" the variable which I set with the set-command.
I can find many samples using
unset ORA_TZFILE
But the unset- command cannot be found from the windows command-shell. Its an unknowns cmdlet.
So there are now many questions in my head like:
- why does set ORA_TZFILE no have any effect?
- why I cant use unset-command as many samples use it?
- is instant_client_12_1 really not compatible downwards or is there an other way the equalize the file-version from 18 to 11?
Thanks in advance for any hints, advices helpful information.