Home » SQL & PL/SQL » SQL & PL/SQL » Sporadic Certification Validation Error While accessing the external portal (Oracle Database 12c Release 12.1.0.2 - 64bit Production, AIX 7.2)
Sporadic Certification Validation Error While accessing the external portal [message #686099] Fri, 10 June 2022 08:16 Go to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
We are running jobs by accessing an external portal through the Oracle DB. We have a wallet created using "orapki" utility. And the certificates shared by the app team have been added to the wallet.

We see that the jobs are getting executed connecting the remote portal. However, the behavior is not stable. At random, there is a certification validation error seen. We could not treat this is a certificate error because, the issue is encountered at random and other subsequent executions are fine.

How could we trace this issue and fix this permanently? What could be reason for this intermittent certificate error?

ORA-29273: HTTP request failed
ORA-29024:Certificate Validation Failure
ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1
Regards,
Anton
Re: Sporadic Certification Validation Error While accessing the external portal [message #686100 is a reply to message #686099] Fri, 10 June 2022 08:39 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
Any chance it is RAC? If so, is wallet shared by all RAC nodes or each node has own wallet?

SY.
Re: Sporadic Certification Validation Error While accessing the external portal [message #686102 is a reply to message #686100] Fri, 10 June 2022 08:44 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
No. This is not a RAC. It is a standalone DB.
Re: Sporadic Certification Validation Error While accessing the external portal [message #686104 is a reply to message #686099] Fri, 10 June 2022 12:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can have a look at following MOS notes:
  • Troubleshooting ORA-29024:Certificate Validation Failure (Doc ID 756978.1)
  • HTTPS Access Using UTL_HTTP Fails with ORA-29024: Certificate validation failure After Upgrade To Oracle 12.1.0.2 (Doc ID 2006286.1)
  • Encountering ORA-29024: Certificate validation failure on Oracle Database EE 12.1.0.2 for google certs (Doc ID 2538980.1)
This later one refers to an error at the same line of the package than you (1491), the solution is to apply merge patch 24666032.

Re: Sporadic Certification Validation Error While accessing the external portal [message #686239 is a reply to message #686104] Sun, 10 July 2022 03:28 Go to previous message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Thanks Everyone on the response. I had to have discussion regarding patching. In parallel the application vendor figured out that the application was not capable of handling multiple job requests in parallel. An application specific configuration addressed the issue. Hence we managed to have the issue rectified without the need for DB patching.

We are good to close this thread.
Previous Topic: Teachers teaching the most students
Next Topic: Integrity constraint violation
Goto Forum:
  


Current Time: Thu Mar 28 07:28:29 CDT 2024