Monday, February 21, 2011

Error While Loading Shared Libraries: libdb.so.2

I was installing EBS 12.1.1 Vision for testing purposes. Unix team member installed the additional packages using Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]. After downloading and extracting all packages I started the installer. Everything went well till this screen:

That doesn't look good... After stopping and starting EBS by using adstpall.sh and adstrtall.sh step adapcctl.sh showed an error:
Error
--> Process (index=1,uid=1191665904,pid=28020)
    failed to start a managed process after the maximum retry limit
    Log:
    /opt/oracle/VIS/inst/apps/VIS_vm-946-157/logs/ora/10.1.3/opmn/HTTP_Server~1.log

 

And at  HTTP_Server~1.log:
/opt/oracle/VIS/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

On metalink there is a note (879522.1) to create a symbolic link to libgdbm.so.2.0.0: ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

But after double checking note 761566.1, at the Other Requirements section, there is small note:
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.
Note that this patch (which includes a required operating system library) must be applied before installing Oracle E-Business Suite.

EBS went smooth after installing this small patch. 

Friday, February 4, 2011

Oracle Applications Manager Log

In PeopleSoft I know where I can find the log files and where I can find what information. In Oracle EBS it's not always clear for me where I can find what. Today the Applications Manager Log. It's not easy to find, it's in the Site Map of OAM, there is no direct navigation from the menu. You must first select a Responsibility from OAM, for example the Dashboard.

The information logged here is useful when you are trouble shooting connection issues. See the previous post and also Johan Louwers has an example of it. There are three log levels: USER, DEV and SUPPORT. I use DEV to troubleshoot. USER has very limited information. SUPPORT is useful to support for diagnosing problems.

It's described in the System Administrator's Guide - Maintenance, but it looks like the info is not accurate anymore. From the guide:
For a persistent setting, the log level
initialization parameter must be changed in zone.properties. The
parameter is: oracle.apps.oam.logger.level

There is no zone.properties file any more in release 12. But $ORACLE_HOME/sysman/webapps/emd/WEB-INF/web.xml contains the parameter oracle.apps.oam.logger.level,  when changing it and bouncing the app. doesn't change the value, it's still USER at the Application Managers Log... Maybe I create a SR for this but for me it's not very useful to have it always on DEV, I prefer switching it to DEV when I need it.

The log files are stored at $LOG_HOME/appl/rgf/oam/

Tuesday, January 18, 2011

Metalink credentials

After installating a VM template with EBS 12.1.3 and trying to installing some patches using the Patch Wizard I got an validation error: "Unable to connect to Metalink. Please enter a valid Metalink userid and password. Please also check if the Web Proxy Setup information is correct." at the Setup Metalink Credentials page. See screenshot below.
In the Applications Manager Log this message occured:
[AJPRequestHandler-HTTPThreadGroup-22][21:43:8:818, 1/17/11] URLFETCHUTIL: Opened Connection to: http://updates.oracle.com/ARULink/XMLAPI/query_patches?bug=-1&platform=2000&userid=john.do@oracle.com&email=john.do@oracle.com&language=0

and
[21:44:25:97, 1/17/11] oracle.apps.fnd.oam.sdk.util.url.URLFetchException: Connection timed out (errno:238); Root exception is:
 java.net.ConnectException: Connection timed out (errno:238)
Let's try this url in the browser: http://updates.oracle.com gave a time out, but https://updates.oracle.com gave response! So it looks like the link is incorrect / changed. At metalink I found metalink note 1267153.1, but that was for OEM and not OAM. But there is also metalink note: New ARU Access Protocol Requires Patches for Patch Wizard in Oracle E-Business Suite and Patch Manager in Oracle Application Change Management Pack for Oracle E-Business Suite [ID 1267768.1]
A cryptical description, but after applying Patch:10364346 described in the note the Metalink connection from Patch Wizard worked:


This is tested on EBS 12.1.1. on HP Itanium and EBS 12.1.3. on VM Oracle Linux 32 bit.