Hi,
I'm having an issue with Continuous Query Notification on an Oracle 19 database with ODP.NET.
Sometimes the CQN connection is gone and via tracing I've seen that the DbNotificationPort is -1, when that happens. I've seen that the DbNotificationPortcan be set to a fixed value, but is there a way to do that without code change?
I've found this: https://docs.oracle.com/en/database/oracle/oracle-database/21/odpnt/InstallCoreConfiguration.html, but I don't seem to be able to set the DbNotificationPortwith that. I was able, as a test, to set the TOKEN_LOCATION via the sqlnet.ora file.
Kind regards,
Jochen