4.6.2 Install Oracle Instant Client

Install Oracle Instant Client for Windows client.

The OML4Py client requires Oracle Instant Client to connect to an Oracle database.

To install Oracle Instant Client, do the following:

1. Download the Oracle Instant Client for your system. Go to the Oracle Instant Client Downloads page.
2. Download an Oracle 23.9 (Basic Light) or Oracle 21.19 (Basic Light) zip file, matching your application architecture.
3. Unzip the package into a single directory that is accessible to your application, for example C:\oracle\instantclient_23_9.
4. Set the environment variable PATH.

   You must add the path to instantclient_23_9 to the beginning PATH environment variable.

   set PATH=C:\oracle\instantclient_23_9;%PATH%

   This PATH setting will only remain for the current session. To make it permanent, you must add the instant client path to the Windows environment variables.

   To set the environment variable permanently on Windows 11, follow these steps:

   1. To configure the Python environment variables permanently: Follow the navigation path. Choose from :

      • Navigation path:Start → Settings → System → About → (scroll down) → Advanced system settings → Advanced tab → Environment Variables
      • Alternate shortcut:Press Win + r type sysdm.cpl, and press Enter to open System Properties → Advanced → Environment Variables directly
   2. Under the User variables, click New. Add the Variable name: PATH and Variable value: C:\oracle\instantclient_23_9;%PATH%.
   3. Click OK to close all dialogs.
   4. Reopen your terminal for the changes to take effect.