R12 Apache Issue: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

Problem

Web server were not up while start the Application server

Installation Log File

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

opmnctl: opmn is already running.

opmnctl: starting opmn managed processes...

================================================================================

opmn id=erpuatappl.com.in:6215

    0 of 1 processes started.

ias-instance id=UAT_erpuatappl.erpuatappl.com.in

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

--------------------------------------------------------------------------------

ias-component/process-type/process-set:

    HTTP_Server/HTTP_Server/HTTP_Server/

Error

--> Process (index=1,uid=606170722,pid=28344)

    failed to start a managed process after the maximum retry limit

    Log:

    /UATappl/inst/apps/UAT_erpuatappl/logs/ora/10.1.3/opmn/HTTP_Server~1.log

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /UATappl/inst/apps/UAT_erpuatappl/logs/appl/admin/log/adapcctl.txt for more information ...  

Apache Log File

09/30/20-13:46:10 Start process

--------

/UATappl/inst/apps/UAT_erpuatappl/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd

/UATappl/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

Status of the Services

[applmgr@erpuatappl scripts]$ ./adopmnctl.sh status apps/apps

09/30/20-13:46:16 :: adopmnctl.sh version 120.6.12010000.5

09/30/20-13:46:16 :: adopmnctl.sh: Checking the status of Oracle Process Manager (OPMN)

Processes in Instance: UAT_erpuatappl.erpuatappl.com.in

---------------------------------+--------------------+---------+---------

ias-component                    | process-type       |     pid | status  

---------------------------------+--------------------+---------+---------

OC4JGroup:default_group          | OC4J:oafm          |    4503 | Alive   

OC4JGroup:default_group          | OC4J:forms         |    4434 | Alive   

OC4JGroup:default_group          | OC4J:oacore        |    4287 | Alive   

HTTP_Server                      | HTTP_Server        |     N/A | Down    

09/30/20-13:46:17 :: adopmnctl.sh: exiting with status 0

Cause

http web server unable to start due to missing library.

Solution

1. Shutdown all application services.
2. Create link for library file as below

$ ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

OR

OS Library Patch for Oracle HTTP Server (on Oracle Linux 5 and RHEL 5 only)
Download and apply the patch 6078836 from My Oracle Support to fix an issue with the Oracle HTTP Server (missing libdb.so.2) bundled with the E-Business Suite technology stack.

Link to Berkeley DB library for HTTP server (on Oracle Linux 7 and RHEL 7 only)

$ cd /usr/lib

$ ln -s libdb-4.7.so libdb-4.3.so

Reference : Attempting to Start Apache (adapcctl.sh) Throws an 'Error While Loading Shared Libraries: libdb.so.2' on Linux (Doc ID 879522.1)