Can't connect with python library

[explorercpp]

Hi,
I was using version 1.x.x and it was working fine, I upgraded to 2.2.0 and it started giving errors on connection. I tried which version worked last, and it was 2.1.1.
2.1.2, 2.2.0 are not working to connect for me.
the error is:
raise error.exc_type(error) from cause oracledb.exceptions.DatabaseError: DPY-4027: no configuration directory to search for tnsnames.ora

I checked that this file is present, the path to TNS_ADMIN is set and all should work fine.

I'm using python 3.9 and macbook pro with ARM processor.

[anthony-tuininga]

Can you provide more details? Such as the contents of the script that demonstrates the issue? Also include this code:

import os

config_dir = os.environ["TNS_ADMIN"]
file_name = os.path.join(config_dir, "tnsnames.ora")
for line in open(file_name):
    print(line)
    break

The full traceback would also be useful. Thanks!

[explorercpp]

`# tnsnames.ora Network Configuration File: /path_to_folder/network/admin/tnsnames.ora

Traceback (most recent call last):
File "/Users/xxxxxx/Documents/oracledb2.py", line 13, in
cp.parse_connect_string("my_network_service_name_from_tnsnames")
File "/Users/xxxxxx/Library/Python/3.9/lib/python/site-packages/oracledb/connect_params.py", line 710, in parse_connect_string
self._impl.parse_connect_string(connect_string)
File "src/oracledb/impl/base/connect_params.pyx", line 560, in oracledb.base_impl.ConnectParamsImpl.parse_connect_string
File "src/oracledb/impl/base/connect_params.pyx", line 558, in oracledb.base_impl.ConnectParamsImpl.parse_connect_string
File "src/oracledb/impl/base/connect_params.pyx", line 334, in oracledb.base_impl.ConnectParamsImpl._parse_connect_string
File "src/oracledb/impl/base/connect_params.pyx", line 1141, in oracledb.base_impl.TnsnamesFileReader.read_tnsnames
File "/Users/xxxxxx/Library/Python/3.9/lib/python/site-packages/oracledb/errors.py", line 182, in _raise_err
raise error.exc_type(error) from cause
oracledb.exceptions.DatabaseError: DPY-4027: no configuration directory to search for tnsnames.ora`

the program:
`
import os

import oracledb
os.environ['TNS_ADMIN'] = '/Users/xxxxxx/network/admin'
config_dir = os.environ["TNS_ADMIN"]
file_name = os.path.join(config_dir, "tnsnames.ora")
for line in open(file_name):
print(line)
break

cp = oracledb.ConnectParams()
cp.parse_connect_string("my_network_service_name_from_tnsnames")
`

[anthony-tuininga]

That code demonstrates the problem. You need to do one of the following things:

• set os.environ['TNS_ADMIN'] before the import of the oracledb module OR
• set oracledb.defaults.config_dir to the the value you wish OR
• pass the value in the parameter config_dir to the connect() call

The import of the oracledb module reads the environment variable and stores the value in oracledb.defaults.config_dir. It is not examined again after that. You can also set the value of oracledb.defaults.config_dir yourself at any point, or pass the value in directly to the connect() call

[explorercpp]

Ok, after I moved it above import oracledb, the connection worked using tnsnames.ora.
Question would be why with version 2.1.1 and earlier, if I had specified the connection string explicitly as an argument in connect() function
I have connection string (con_s) as: user/password@//FQDN:port/instance connection = oracledb.connect(con_s,disable_oob=True)
, and it was not even present in tnsnames.ora it was connecting successfully, and now it is failing without information that is specified in tnsmanes.ora?

[anthony-tuininga]

Can you provide more details about what you are saying fails? I tried this:

import oracledb

oracledb.defaults.config_dir = None
conn = oracledb.connect("python/dev@localhost:1521/DB23PDB1")
print("version:", conn.version)

And that works just fine for me!

[anthony-tuininga]

Looking at your example I see this:

user/password@//FQDN:port/instance

That is incorrect. It should be this:

user/password@FQDN:port/service_name

There was a bug fix in version 2.1.2 that caused invalid Easy Connect strings to be looked up in the tnsnames.ora file. That might be the source of your issues!