Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh

Error: adgentns.pl exiting with status 2

[CVM Error Report]

The following report lists errors encountered during CVM Phase

/UATappl/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl  2

No of scripts failed in CVM phase: 1

AutoConfig is exiting with status 1 

Solution:

Open a new terminal and source the APPS-Tier Environment.

$sqlplus apps/apps_pwd

SQL> exec fnd_conc_clone.setup_clean

SQL>commit;

Open a new terminal and source the DB-Tier Environment.

Execute Autoconfig on the DB Tier.

Switch back to the APPS environment or start a new terminal and source the APPS-Tier environment.

Execute Autoconfig at the Apps Tier.

Check the Autoconfig log for any errors and ensure that the services start correctly.

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)