Hi experts,
I have a crucial problem and hope you might give me a hint to resolve the issue.
Here are the facts:
DB Version: Oracle v.12.1
Apex: v5.1 with Embedded Gateway
The issue: I have a db link to query data from a remote database in my application.
Since the deployment of the July PSU, I cannot access the remote database anymore:
ORA-12269: client uses weak encryption/crypto-checksumming version ==> when trying to access a page with a report based on a db link query.
I tried the following sqlnet settings on my db server to no avail:
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA256)
and
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA1,MD5,SHA256)
Interestingly, I am able to fire the query without issues from the Apex database itself.
The db link works just fine on that level.
Only the Apex application level, produces the ORA-12269.
Do you have any clue what this is about? How can I apply sqlnet encryption, while using a db link within Apex?
Any help is appreciated!
Thanks for taking the time to contemplate about the issue.