Friday, August 9, 2013

Distributed AD in Shared APPL_TOP

Today I've used disributed=y with adpatch option to allow workers to be started on remote machines, where they can utilize the resources on the remote machines when completing their assigned jobs.

Distributed AD offers improved scalability, performance, and resource utilization by allowing workers of the same AD session to be started on additional middle tier systems.

Prerequisites

1) Shared APPL_TOP
2) AD.H


Working

On one of your shared APPL_TOP nodes, start your AutoPatch or AD Administration session with the following command line options:

localworkers= workers=

For example to run an AutoPatch session with 32 workers on the local node and 32 workers on a remote node:

adpatch localworkers=32 workers=64

On one or more of the additional shared APPL_TOP nodes, start an AD Controller session with the following command line option:

adctrl distributed=y

After providing basic information, AD Controller will prompt for the worker number(s) to be started. For example, enter "33-64" to start workers 33 through 64. If AD Controller is started prior to AutoPatch or AD Administration starting the Jobs System, AD Controller will ask if you want to wait. Choosing yes will cause AD Controller to wait until the Jobs system is started, at which point it will start the appropriate worker processes. If an AutoPatch session has already been started, AD Controller will wait automatically.
Example of a two node session with 64 workers:

Node 1) adpatch localworkers=32 workers=64

Node 2) adctrl distributed=y and choose Enter the worker range 33-64


till FND_INSTALL_PROCESS tables get created, distributed adctrl sessions will wait for node1 adpatch. when fnd_install_processes table gets created, distributed workers will be forked and will start the tasks.

it's really cool way of reducing downtime - Part No. B31567-02 of R12 document set contains bit more information on this!!



So, Enjoy with more workers !!! ;)

Responsibilities are not showing up for users

Recently I've faced this issue that users were complaining that they were not seeing responsibility which was assigned to them.

When I tried to switch to the responsibility which were added recently, It wasn't not showing up. I tried to logoff and login again. Cleared IE Browser Cache. But No luck. After research, I found the solution which worked. Here is for you.

Solution:

Run program 'Workflow Directory Services User/Role Validation' with following parameters.


Note:

As per Oracle documentation, it is also good to run 'Synchronize WF LOCAL tables' after this program run. But it is optional.

Thursday, August 8, 2013

Configure DNS to use as a Load Balancer for an EBS Instance

Hi Guys,

Here I'm uploading a step by step approach document to Configure DNS to use as a Load Balancer for an EBS Instance.




Note: After putting IP Addresses and Hostnames in DNS, do not forget to comment entries from /etc/hosts file.

By Default, /etc/hosts file has precednce over DNS which is mentioned in /etc/nsswitch.conf. Edit this file to change priority.

Your suggestions and feedback are most welcome !!! Let me know if you want this document on your mail id. 

Thanks,
Manish Nashikkar

Wednesday, August 7, 2013

Script to find Apache, Java, JRE, Forms version for Oracle E-Business Suite R12

The below script collects Apache, Java, Client JRE, Forms, Perl, PL/SQL versions and Forms communication mode. (Only for R12 and do not run on 11i Instance)

Before running the script ensure that you have sourced the environment file APPS<SID>_host.env from $APPL_TOP after logging into the system as applmgr user, otherwise the script will not run successfully


# +===========================================================================+
# | FILENAME
# | Instancedetails_R12.sh
# |
# | DESCRIPTION
# |   This script can be used to collect Apache, Jserv, Forms, Jinitiator and  
# |   Perl version in E-Business suite R12
# |
# | PLATFORM
# | Unix Generic, Linux, HP-UX,IBM AIX, Sunsolaris 
# |
# | NOTES
# |   Before running the script ensure that you have sourced the environment 
# |   by running APPS<SID>_host.env file from $APPL_TOP.  
# |
# | HISTORY
# |   Version 1.0
# +===========================================================================+
#
(
echo "Script Started "
date
## The script shows output on screen and creates file named hostname_date.txt file in current ## directory
## Collect the Apache version
echo "*****Apache Version*****"
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
echo " "
## Collect perl version
echo "*****perl version******"
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built
echo " "
## Collect Java version
echo "******Java Version******"
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
echo " "
## Collect client JRE version
echo "*****Client JRE version*****"
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
echo " "
## Collect Forms version
echo "*****Forms Version*****"
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
echo " "
## Collect PL/SQL Version
echo "*****PL/SQL Version****"
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
echo " "
## Collect Forms communication mode
echo "****Forms Communication Mode****"
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"
echo " "
echo "Script Completed Successfully and it has generated the file  zz`hostname`_`date +%m%d%y.%H%M`.txt file in current directory"
echo "Script completed "
date
) 2>&1 | tee zz`hostname`_`date +%m%d%y.%H%M`.txt
###
### END OF SCRIPT
###



=================== Output =========================

[applmgr@ebs1 ~]$ . /u01/app/oracle/EBS/apps/apps_st/appl/APPSEBS_ebs1.env

[applmgr@ebs1 ~]$ sh InstanceDetails.sh
Script Started
Thu Jan 19 22:30:14 IST 2012
*****Apache Version*****
Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server
Server built:   Jul  7 2008 14:58:00

*****perl version******
This is perl, v5.8.3 built for i686-linux-thread-multi

******Java Version******
java version "1.6.0_10"
Java(TM) SE Runtime Environment (build 1.6.0_10-b33)
Java HotSpot(TM) Client VM (build 11.0-b15, mixed mode)

*****Client JRE version*****
sun_plugin_version=1.6.0_07

*****Forms Version*****
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

*****PL/SQL Version****
PL/SQL Version 10.1.0.5.0 (Production)

****Forms Communication Mode****
serverURL=/forms/lservlet
If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet

Script Completed Successfully and it has generated the file  zzebs1.oracle.com_011912.2230.txt file in current directory
Script completed
Thu Jan 19 22:30:15 IST 2012
 



Cheers !!!

Saturday, August 3, 2013

error while loading shared libraries



Error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory R12.1.1 Installation on Linux 5.X

Hello,

I was Installing Oracle E-Biz R12.1.1 on OEL 5.4 - 64 Bit for one of our customer. All OS pre-requisites has been configured as per the MOS tech note for Installation and all pre-req check from the rapidwiz Installer went fine.

At last steps of Installation during validating system configuration it failed on HTTP, loginpage, Help Directory and JSP.

When checked all services were up and running except web server.



checking status of OPMN managed processes...

Processes in Instance: VIS_oel.oel.WORLD.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   13776 | Alive
OC4JGroup:default_group          | OC4J:forms         |   13703 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   13617 | Alive
HTTP_Server                      | HTTP_Server        |   13560 | Down Http_server is shown as Down.


Error messages recorded in logfiles:

Installation logfile:
  

HTTP
-----

checking URL = http://oel.WORLD.com:8011

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.


Help Page
----------

checking URL = http://oel.WORLD.com:8011/OA_HTML/help

RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.


Virtual Directory
------------------

RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.


JSP
----

checking URL = http://oel.WORLD.com:8011/OA_HTML/jtfTestCookie.jsp

RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.


Login Page
-----------

RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.



Apache logfiles:



07/04/11-10:23:44 :: adapcctl.sh: starting OPMN managed OHS instance

opmnctl: starting opmn managed processes...
================================================================================
opmn id=OEL.WORLD.COM:6210
    0 of 1 processes started.

ias-instance id=VIS_oel.oel.WORLD.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    HTTP_Server/HTTP_Server/HTTP_Server/

Error
--> Process (index=1,uid=83499476,pid=12821)
    failed to start a managed process after the maximum retry limit
    Log:
    /u02/oracle/VIS/inst/apps/VIS_oel/logs/ora/10.1.3/opmn/HTTP_Server~1.log
 

/u02/oracle/VIS/inst/apps/VIS_oel/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u02/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


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


3) Startup all application services.

Now you should be able to access the application.

Happy reading... :) 


- Manish Nashikkar