"DPI-1072: the Oracle Client library version is unsupported" with python3.7.2 and instantclient_19_3/instantclient_12_2 on win10

[Fengjiya]

1. Review the cx_Oracle Documentation. Review your output and logs. Google any errors

2. Describe the problem
   "DPI-1072: the Oracle Client library version is unsupported" with python3.7.2 and instantclient_19_3/instantclient_12_2 on win10

3. Include a runnable Python script that shows the problem. Include all SQL needed to create the database schema. Use Markdown syntax, see https://help.github.com/github/writing-on-github/basic-writing-and-formatting-syntax

I have tried both instantclient_12_2 and instantclient_19_3 with python 3.7.2，but both get The same error :PI-1072: the Oracle Client library version is unsupported.
I am sure The cx_oracle version is right with python 3.7.2.

5. What is your Oracle Database version?
   OS:win10
   python:python3.7.2 with 64
   Oracle instantclient：instantclient_19_3 and instantclient_12_2

[anthony-tuininga]

This error occurs if the version of the Oracle Client libraries that is being used is too old. That wouldn't be the case with instant client 12.2 and 19.3, so the likelihood is that there is another version of oci.dll on your system that is being found first. Check your PATH environment variable and check each directory in your PATH for oci.dll.

[Fengjiya]

This error occurs if the version of the Oracle Client libraries that is being used is too old. That wouldn't be the case with instant client 12.2 and 19.3, so the likelihood is that there is another version of oci.dll on your system that is being found first. Check your PATH environment variable and check each directory in your PATH for oci.dll.

This error occurs if the version of the Oracle Client libraries that is being used is too old. That wouldn't be the case with instant client 12.2 and 19.3, so the likelihood is that there is another version of oci.dll on your system that is being found first. Check your PATH environment variable and check each directory in your PATH for oci.dll.

Sounds good ,I will check this ,ths.

[anthony-tuininga]

Closing - no activity

[simpleowen]

@Fengjiya

try: cx_Oracle.init_oracle_client(lib_dir=r"C:\oracle\instantclient_12_2")

ref: https://cx-oracle.readthedocs.io/en/latest/user_guide/initialization.html#initialization

[alvinwanda]

Use this snippet to add it to path.

import os, cx_Oracle

os.environ["PATH"] = r"C:\Users\UGA31791\Documents\instantclient_21_3;" + os.environ["PATH"]

This sets it at the beginning of PATH, so it is called before any other conflicting libraries that are in PATH.

[haroldtr]

Use this snippet to add it to path.

import os, cx_Oracle

os.environ["PATH"] = r"C:\Users\UGA31791\Documents\instantclient_21_3;" + os.environ["PATH"]

This sets it at the beginning of PATH, so it is called before any other conflicting libraries that are in PATH.

The solution you provided is exactly what I needed and has proven to be fully functional. Thank you for your contribution and for sharing your knowledge with the community!