Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#performance, #performance-availability, #xml, #xml-db
1 comment
680 views