OraFAQ Forum: SQL & PL/SQL » Sporadic Certification Validation Error While accessing the external portal

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sporadic Certification Validation Error While accessing the external portal [message #686099]

Fri, 10 June 2022 08:16

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?

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Sporadic Certification Validation Error While accessing the external portal [message #686100 is a reply to message #686099]

Fri, 10 June 2022 08:39

Solomon Yakobson
Messages: 3305
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.

Report message to a moderator

Re: Sporadic Certification Validation Error While accessing the external portal [message #686102 is a reply to message #686100]

Fri, 10 June 2022 08:44

jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai

Senior Member

No. This is not a RAC. It is a standalone DB.

Report message to a moderator

Re: Sporadic Certification Validation Error While accessing the external portal [message #686104 is a reply to message #686099]

Fri, 10 June 2022 12:10

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Sporadic Certification Validation Error While accessing the external portal [message #686239 is a reply to message #686104]

Sun, 10 July 2022 03:28

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.

Report message to a moderator

Previous Topic:	Teachers teaching the most students
Next Topic:	Integrity constraint violation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 28 23:46:11 CDT 2025