Skip to Main Content

ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1367 ORA-29269: HTTP server

Mohammad ShaddadOct 27 2022 — edited Oct 27 2022

Hi All
Kindly, I consumed DB packages, procedures, views as web service using XDB, some times source applications complaint that they are receiving server not responding error, and when I test in few cases I am receiving the error:
29273-ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1367
ORA-29269: HTTP server error 500 - Internal Server Error

MY DB V: 11.2.0.4

I can see it's probably happen when not triggering any request for some time then start calling the web service

My questions:
how I can troubleshoot XDB issues?
how I can view count of handled requests and requests stopped with errors?
how I can review XDB setup or setting or parameter file to follow best bracts from performance and availability point of view to handle big volume of requests
Thanks ...

Comments
Post Details
Added on Oct 27 2022
1 comment
13 views