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=ebs.calspence.lk:6250
    0 of 1 processes started.

ias-instance id=CRP3_ebs.ebs.calspence.lk
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    HTTP_Server/HTTP_Server/HTTP_Server/

Error
--> Process (index=1,uid=1355424968,pid=10518)
    failed to start a managed process after the maximum retry limit
    Log:
    /EBS/CRP3/inst/apps/CRP3_ebs/logs/ora/10.1.3/opmn/HTTP_Server~1.lo

Apache Log File

15/01/16 14:24:32 Start process
--------
/EBS/CRP3/inst/apps/CRP3_ebs/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/EBS/CRP3/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

[oracle@ebs scripts]$ ./adopmnctl.sh status apps/apps                           
You are running adopmnctl.sh version 120.6.12010000.5

Checking status of OPMN managed processes...

Processes in Instance: CRP3_ebs.ebs.calspence.lk
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:forms-c4ws    |    9886 | Alive
OC4JGroup:default_group          | OC4J:oafm          |    9747 | Alive
OC4JGroup:default_group          | OC4J:forms         |    9679 | Alive
OC4JGroup:default_group          | OC4J:oacore        |    9533 | Alive
HTTP_Server                      | HTTP_Server        |     N/A | Down

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)