Skip to Main Content
Forums

APEX

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!

ORA-29273: HTTP request failed apex.oracle.com

KhawerrFeb 17 2020 — edited Feb 17 2020

Hi,

I am getting this attached error on using Web service from apex.oracle.com but when i am trying to hit the same web service through Post man it is giving me success in response.

What is the issue.Can anyone help. Check attachment for error.

This is the URL which i am using for in Legacy Web Service https://b5.wms.ocs.oraclecloud.com/radius/wms/api/init_stage_interface/

Regards,

Khawer2020-02-17.png

Comments

Joseph Upshaw

The most likely cause is that you are pointed to a mail server that isn't on the same host as your database, i.e. something other than localhost. Because of this, an ACL will be required to allow APEX_MAIL to reach the host that you are specifying in your instance configuration mail settings.
Look in your installation guide for the section entitled Enabling Network Services in Oracle Database 11g or Later for instructions to do this.
-Joe

M.bro

@joe-upshaw
Thanks for your reply. I have given the ACL access like 5.6.3 Granting Connect privileges in oracle Database 12c but I still I am facing the same issue.

ORA-24250 No supported authentication schema found.

Billy Verreynne
Answer

Run APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG.
If this fails, there are, according to Oracle Support Note How to configure the EMAIL Delivery From Apex On-Premises Instance and Troubleshoot the Issues (Doc ID 2794898.1), issues with the SMTP instance parameters, missing Network ACL, missing SSL certificate in Oracle Wallet, or a problem on the email server side.
Does your SMTP server use TLS or not? Does your SMTP server require user credentials? Do the ACLs allow access to the SMTP server via IP, hostname, or wildcard, on the correct ports? Etc.
Each and every aspect of talking to a SMTP server needs to be checked and verified as correct.
For example, configuring APEX to use user credentials when the SMTP server does not expect credentials, can trigger the error you're seeing. Or an ACL that allows localhost access only when the SMTP server is on a remote address. Or using TLS without a properly configured wallet. And so on.

Marked as Answer by M.bro · Dec 8 2021
M.bro

[Billy Verreynne](/ords/forums/user/Billy Verreynne)
thanks for your quick response.
I tried the above steps. I can able to run in sys user  "APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG." package I will not get any error messages. I can send an email from the below url
https://oracle-base.com/articles/misc/email-from-oracle-plsql
but I tried the interactive report email option it shows still the same error ORA-24250 No supported authentication scheme was found and I used apex_mail. send email package same error.

BEGIN
  send_mail(p_to        => 'me@mycompany.com',
            p_from      => 'admin@mycompany.com',
            p_subject   => 'Test Message',
            p_message   => 'This is a test message.',
            p_smtp_host => 'smtp.mycompany.com');
END;
/

The above simple procedure, I followed above URL steps, I created and send an email it's working fine but apex_mail.send email not working and interactive report mail options as well not working.

Billy Verreynne

If it works as SYS, but not as another schema, then it is a privilege issue - likely an ACL problem.

Joseph Upshaw

Post the contents of:
DBA_NETWORK_ACLS
DBA_NETWORK_ACL_PRIVS
The name of your mail server.
I am still pretty sure that it is an issue with the ACL configuration.

1 - 6

Post Details

Added on Feb 17 2020
#apex, #apex-discussions, #api, #sql, #xml
1 comment
519 views