Add support for IFILE in tnsnames.ora

[mac-vtl]

1. What versions are you using?

SQL> SELECT BANNER FROM v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

import oracledb
print("oracledb.__version__:", oracledb.__version__)

oracledb.__version__: 2.1.0

>>> import sys
>>> import platform
>>> print("platform.platform:", platform.platform())
platform.platform: Linux-5.10.0-22-amd64-x86_64-with-glibc2.31
>>> print("sys.maxsize > 2**32:", sys.maxsize > 2**32)
sys.maxsize > 2**32: True
>>> print("platform.python_version:", platform.python_version())
platform.python_version: 3.11.8

2. Is it an error or a hang or a crash?

a crash

3. What error(s) or behavior you are seeing?

DatabaseError: (oracledb.exceptions.DatabaseError) DPY-4000: unable to find "XXXX.WORLD" in /opt/oracle/instantclient_19_16/network/admin/tnsnames.ora

4. Does your application call init_oracle_client()?

No, running Thin mode

5. Include a runnable Python script that shows the problem.

import oracledb

with oracledb.connect(user="myuser", password="secretpassword", dsn="XXXX.WORLD") as connection:
    with connection.cursor() as cursor:
        sql = """select sysdate from dual"""
        for r in cursor.execute(sql):
            print(r)

• crashes if the tnsnames.ora file contains FILE=
• works if all definitions are included directly in tnsnames.ora file

[anthony-tuininga]

Can you provide an example? Or a reference to the Oracle documentation that shows how this is used? A quick search doesn't bring up anything relevant. Thanks!

[mac-vtl]

Like so:

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/IFILE.html#GUID-F8AC6FC6-F456-481F-8997-3B0E906BB745

[anthony-tuininga]

Thanks.

[mac-vtl]

thanks to you! Our DBA team is looking to extend the usage of IFILE to our deployed tnsnames.ora files. Do think that is something that can be added to the roadmap soon?

[oub-vtl]

Hi @anthony-tuininga,

Could we get an ETA for this item, please?

[anthony-tuininga]

I am looking into it and I hope to include it in version 2.2. I don't know the ETA for that exactly yet, but the patch will be available before the release if you are able to build binaries yourself?

[oub-vtl]

Sounds good, thank you!

[oub-vtl]

Is this still planned for oracledb 2.2.0?

[anthony-tuininga]

Yes, it is. I hope to have a patch available fairly soon. Stay tuned!

[anthony-tuininga]

A patch is now available. If you are able to build from source you can verify that it works for you, too.