Connection failing while connecting with create_pool_async but it works with connect function

[jeanmartins]

1. What versions are you using?

Give your Oracle Database version, e.g.:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Also run Python and show the output of:

plataform.plataform: Windows-10-10.0.22631-SP0
sys.maxsize > 2**32: True
plataform.python_version:3.10.5

And:

"oracledb.version: 3.4.2

-->

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

Error.

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

pool.acquire() is returning: DPY:4011: the database or network closed the connection, while using oracledb.create_pool_async with TCPS(1523). But, when I do a oracledb.connect or I use TCP(1521) in create_pool_async it works.

I'm using TCPS protocol and passing the same parameters to both functions, with the exception of min, max and increment of course.

4. Does your application call init_oracle_client()?

No, I'm using Thin Mode

[anthony-tuininga]

Please provide the packet output so the differences between the two can be observed. Set the environment variable PYO_DEBUG_PACKETS to any value before running your script. You can e-mail these to me since they will likely be quite large and may contain sensitive data.