Home > OS >  Where is the Oracle Instant Client timezone file located?
Where is the Oracle Instant Client timezone file located?

Time:10-01

I've installed Oracle instant client Version 19.8.0.0.0 on my macOS (Big Sur version 11.5.1) using instructions from the enter image description here

CodePudding user response:

The default timezone files are bundled into the Instant Client libraries.

To change the timezone file used by your version of Instant Client:

  • create a directory hierarchy instantclient_19_8/oracore/zoneinfo e.g. like mkdir -p instantclient_19_8/oracore/zoneinfo

  • put the new timezone file in that directory

  • set an environment variable ORA_TZFILE to the name of the file, e.g. timezone_n.dat. Don't include the path.

  • You can check which file is being used by running genezi -v

This is discussed in the Oracle Client installation manual Environment Variables for Oracle Instant Client.

In a future major release of Instant Client you will be able to put the timezone file in any directory, and include that path in the environment variable value (Oracle enhancement 31333105).

  • Related