We are using Oracle Forms, Reports, Access Manager and Internet Directory (OID) with version 12.2.1.4. Single Sign-On (SSO) with proxy user worked well for quite a long time. Since several days we cannot execute reports called from Forms (run_report_object) anymore.
Analyzing the URL which is executed by Forms the URL parameter dbproxyconn=<key> is missing. The RADs in OID are existing and are correct.
After activating tracing for the reports server we found the following line in rwserver-diagnostic.log:
<<<
checkForDbProxyConnection Using key :xxx_sso_fsal
[2025-05-27T09:23:20.292+02:00] [reports] [NOTIFICATION:16] [] [oracle.reports.server] [tid: 45] [ecid: ffa6dd4a-882c-4077-9205-cc7d52ea1b28-00000002,0] Server is not secure , so can not use db proxy feature xxx_sso_fsal
>>>
We assume that a generated demo certificate by Oracle is expired because the installation is about 5 years old.
But in the IDM domain there are several wallets and keystores and we don't know which one is relevant.
We updated one of the keystores (demo identity) using Enterprise Manager but without success. We even don't know where this keystore is stored (database repository ?).
Are there any hints what the term “Server is not secure” really means and which wallet/keystore has to be updated?
Regards Juergen