Solved

Oracle Wallet Update Requires Reboot?

  • 15 March 2023
  • 3 replies
  • 586 views
GPIE
Rank
Userlevel 5
Badge +11
  • GPIE
  • Hero (Customer)
  • 113 replies

Hi all,

We connected IFS to Slack to send notifications rather than using IFS Notify and it has worked perfectly until yesterday, when Slack changed their root certificates causing a trust failure. We imported the new root certificates into the Oracle wallet but the issue remains (see below). We also imported the root certs into Windows trusted root store as recommended by Slack.

The question is: Does anything need to be restarted, i.e. Oracle service, Oracle server, Middleware server etc?

Many thanks.

 

[Error] Execution (1: 1): ORA-29273: HTTP request failed

ORA-29024: Certificate validation failure

ORA-06512: at "SYS.UTL_HTTP", line 380

ORA-06512: at "SYS.UTL_HTTP", line 1127

ORA-06512: at line 36
 

icon

Best answer by GPIE 16 March 2023, 12:08

View original

3 replies

Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @GPIE,

Not sure how this integration is setup, but could you try importing the certificate to the MWS Java truststore by following the steps mentioned in below documentation:

https://docs.ifs.com/techdocs/foundation1/020_installation/400_installation_options/003_security/020_configure_outbound_ssl/default.htm

Hope this helps!

Charith - https://charith.xyz
GPIE
Rank
Userlevel 5
Badge +11

Thanks Charith. The API call is being done by the database server so is independent of the middleware server.

As suspected, after adding the trusted root certificates to the wallet and restarting the server, Slack comms worked again (although I’m not sure if just a database restart would have worked just as well). The process looked something like this:

  1. Download DER root certificates and copy to E:\app\oracle\wallet\
  2. Start Menu > “Oracle - OraDB12Home1” > Wallet Manager
  3. Wallet > Open
  4. Do you want to continue > Yes
  5. Select Directory E:\app\oracle\wallet\
  6. Enter password
  7. Wallet > RMB on Trusted Certificates branch > Import Trusted Certificate
  8. Select a file that contains the certificate
  9. Browse to E:\app\oracle\wallet\
  10. Choose certificate(s) > OK
  11. Wallet > Save
  12. Restart Oracle or Database Server
R
Rank
Badge +4

In Linux DB Server what are the step to do this?

 

Reply


Terms & ConditionsCookie settings