Error "libdb.so.2: cannot open shared object file: No such file or directory "

libdb.so.2: cannot open shared object file: No such file or directory

 Applicable to :-

Oracle E-Business Suite Technology Stack - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Linux x86
Linux x86-64

So , while doing a fresh clone in a new hardware, we faced the error message “libdb.so.2: cannot open shared object file: No such file or directory”  during startup of apache service in EBS. This error is also common in any other oracle application(such as discoverer, demantra) where oracle http service is being used.

 

Reason: This error is observed on linux server 5 and above where Soft link libdb.so.2 is missing.

SOLUTION:-

It might happen that file libgdbm.so.2.0.0 may not exist in server, for that you need to copy it from another server where this file exists or you can download it from below link

libgdbm.so.2.0.0

Now, execute the following steps:

1. Shut down all services on the Application tier

2. Copy libgdbm.so.2.0.0 inside /usr/lib

3. As the unix root user, create a soft link as follows:

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

4. Start application tier services again and this time will start without error.

Error while opening EBS url after cloning - " You are trying to access a page that is no longer active."

 

Recently for one of my customer, I was doing a new R12.1.3 clone into a new server which was outside of their production domain. So after the cloning when tried to open the EBS url from browser it showed error saying  “You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to proceed.”

So after doing a bit of google, I found a document from oracle support suggesting a possibility that if the server hostname container underscore (_) such behaviour is observed. But in our case hostname contained no underscore so this was not the case.

So I did the following to resolve the issue

Login to database as apps user

sqlplus apps/xxxx SQL> select session_cookie_domain from icx_parameters;   SESSION_COOKIE_DOMAIN ------------------------------ .olddomain.co.in

 

The session_cookie_domain column is still looking for olddomain.co.in

 

So I nulled the value

 

SQL> update icx_parameters set session_cookie_domain=null; 1 row updated.   SQL> commit; Commit complete.   SQL> select session_cookie_domain from icx_parameters; SESSION_COOKIE_DOMAIN ------------------------------

 

After this I bounced the apache services.

 

[applmgr@ebsr122 ~]$ cd $ADMIN_SCRIPTS_HOME   [applmgr@ebsr122 scripts]$ adapcctl.sh stop   [applmgr@ebsr122 scripts]$ adapcctl.sh start

 

Then I checked the url again , and it logged in without any error.

How to Download EBS R12.2.0 software

 

Many people find it problematic to download EBS software, So I will show here how to download it easily.

Login to http://edelivery.oracle.com/ using your credentials.

To download oracle ebs , write down with “Oracle Advanced Supply Chain Planning” . Don’t write Oracle E business suite as this will only download the EBS software not all the components of it. Select any version to download, for example I choose 12.2.11. This will download the base 12.2 version along with 12.2.11 files.

On top right corner click on view items and continue,

On next screen, deselect the components you don't want to download, for example I dont want to donwload EBS Languages & mobile application archive, so I did not select it.

On next screen, if you don’t want to install VISION instance, you can deselect the files written with “VISION” .

Once selection is done, click on Download and files will start downloading.