Issues setting up Oracle TLS

[hooverl7777-rgb]

I have TLS set up and work fine, except for when trying to connect with python-oracledb. I keep receiving DPY-3001: Native Network Encryption and Data Integrity is only supported in python-oracledb thick mode error. Yes, I have some encryption settings in the sqlnet.ora on the server because I'm using them for other NNE connections. But, it's only a problem if it is using the same listener as the one I am also using for NNE connects using a full client. If I set up a second listener, within the same listener.ora file, then it works without error. But, that would means it's using the same sqlnet.ora file as the other listener. I don't understand.

This works:
`LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = )(PORT = 1526))
)
)
This does not:LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
(ADDRESS = (PROTOCOL = TCPS)(HOST = )(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
`

[hooverl7777-rgb]

OK, more info that I just figured out. It works with a single listener, up until a minute or so after restarting the listener until the database(s) auto register with the listener. Prior to that, it works, once they auto register, it breaks. With two listeners, there is no auto registration on the TLS port, 1526 in this case.

[hooverl7777-rgb]

Decided to turn off dynamic registration as there is nothing we are currently using for. Issue solved!

[anthony-tuininga]

Glad you got it figured out! :-)