Monday, 29 December 2025

 

Resolving ORA-29273 and ORA-28759 Errors in Oracle E-Business Suite

 

Introduction:

Oracle E-Business Suite (EBS) environments frequently integrate with external systems using the UTL_HTTP package for HTTP and HTTPS communication.

A common issue encountered by DBAs during such integrations is:

 

ORA-29273: HTTP request failed

ORA-28759: failure to open file (UTL_HTTP)

 

Problem Description

These errors indicate that Oracle is unable to process an HTTP request due to a failure in accessing the required SSL wallet.

 

Root Cause

- Incorrect wallet directory configuration

- Missing or corrupted wallet files

- Improper file or directory permissions

- Wallet not configured at the database level

- Missing trusted SSL certificates

- Missing Network ACL privileges

 

Resolution Steps

1. Verify wallet configuration using SHOW PARAMETER wallet.

2. Validate wallet files at OS level.

3. Correct wallet file permissions.

4. Validate installed certificates.

5. Verify network ACL configuration.

6. Test UTL_HTTP connectivity.

 

Conclusion

The ORA-29273 and ORA-28759 errors in Oracle EBS are most commonly caused by wallet configuration or permission issues.

 

- No comments:
Subscribe to: Posts (Atom)

  EBS ADOP Woes: Tackling ORA-20001 in Cleanup Phase   This blog aims to support DBAs who encounter issues during the EBS application R12.2 ...

  • (no title)
      EBS ADOP Woes: Tackling ORA-20001 in Cleanup Phase   This blog aims to support DBAs who encounter issues during the EBS application R12.2 ...
  • (no title)
        Ebs database Custom table columns missing while running a full mode cleanup The purpose of this blog is to assist DBAs encountering ebs ...
  • (no title)
      Oracle Base vs Oracle Home: Understanding the Core Difference When working with Oracle databases, two directory concepts often confuse be...