Bequeath connections are failing with ORA-12545

[theo-fokkinga]

1. What versions are you using?

Database version: Oracle 19.17.0.0.0

platform.platform: Linux-5.4.17-2136.313.6.el7uek.x86_64-x86_64-with-glibc2.17
sys.maxsize > 2**32: True
platform.python_version: 3.9.16

oracledb.version: 1.2.1

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

3. What error(s) or behavior you are seeing?
   When calling the connect function for a bequeath connection, like:

connection = oracledb.connect(mode=oracledb.AUTH_MODE_SYSDBA)

The following error occurs:

Traceback (most recent call last):
  File "example_failing_bequeath_connection.py", line 11, in <module>
    connection = oracledb.connect(mode=sysdba_mode)
  File "/home/john/python3_oracledb_121/lib/python3.9/site-packages/oracledb/connection.py", line 1013, in connect
    return conn_class(dsn=dsn, pool=pool, params=params, **kwargs)
  File "/home/john/python3_oracledb_121/lib/python3.9/site-packages/oracledb/connection.py", line 138, in __init__
    impl.connect(params_impl, pool_impl)
  File "src/oracledb/impl/thick/connection.pyx", line 387, in oracledb.thick_impl.ThickConnImpl.connect
  File "src/oracledb/impl/thick/utils.pyx", line 410, in oracledb.thick_impl._raise_from_odpi
  File "src/oracledb/impl/thick/utils.pyx", line 400, in oracledb.thick_impl._raise_from_info
oracledb.exceptions.DatabaseError: ORA-12545: Connect failed because target host or object does not exist

4. Does your application call init_oracle_client()?
   Yes, running in thick mode.

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

import os
import oracledb

os.environ["ORACLE_HOME"] = "/u01/app/oracle/product/19.0.0.0/db_1"
os.environ["ORACLE_SID"] = "ORCL"
oracledb.init_oracle_client()
connection = oracledb.connect(mode=oracledb.AUTH_MODE_SYSDBA)

connection.close()

When running in debug mode I found that the connection is being made using the connect_string:

'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=None)(PORT=1521)))(CONNECT_DATA=)(SECURITY=(SSL_SERVER_DN_MATCH=ON)))'

This explains the ORA-12545 error message.

It looks like a regression bug in src/oracledb/impl/base/connect_params.pyx, in the get_connect_string function (commit 847004a) introduced in version 1.2.0.
In version 1.0.1 a fix was included to 'restore support for bequeath connection` (commit 5852bae), but the change in 1.2.0 altered the same line. In version 1.1.1 the error does not occur.

Just for testing purposes, I changed the code as follows and then bequeath connections are working fine:

--- a/src/oracledb/impl/base/connect_params.pyx
+++ b/src/oracledb/impl/base/connect_params.pyx
@@ -538,7 +538,7 @@ cdef class ConnectParamsImpl:
         will be a connect string built up from the components supplied when the
         object was built.
         """
-        if self._has_components:
+        if self._has_components and self._default_address.host is not None:
             return self.description_list.build_connect_string()

[anthony-tuininga]

Thanks for the report. I'll get that corrected!

[anthony-tuininga]

I have pushed a patch that should correct this issue and added a relevant test case. If you are able to build from source you can verify that it corrects your issue as well.

[theo-fokkinga]

I can confirm that the issue is fixed with this patch included. Thanks!

[anthony-tuininga]

This patch is included in version 1.2.2 which was just released.