Thursday, December 26, 2013

Hourly/Daily Archive generation

The below query comes handy to understand the archivelog generation of an Oracle database on an hourly /daily basis, per thread – in case of RAC databases.Archivelog generation on a daily basis:

set pages 1000select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKS*BLOCK_SIZE)/1024/1024/1024) GB,count(*) Archives_Generated from v$archived_loggroup by trunc(COMPLETION_TIME,'DD'),thread# order by 1;

Archive log generation on an hourly basis:

set pages 1000select trunc(COMPLETION_TIME,'HH') Hour,thread# , round(sum(BLOCKS*BLOCK_SIZE)/1024/1024/1024) GB,count(*) Archives from v$archived_loggroup by trunc(COMPLETION_TIME,'HH'),thread#  order by 1 ;

Sample output:

HOUR                   THREAD#         MB   ARCHIVES
------------------- ---------- ---------- ----------
2013 08 20 12:00:00          1      31268        339
2013 08 20 13:00:00          1       4994         55
2013 08 20 14:00:00          1       4412         48
2013 08 20 15:00:00          1       4805         52
2013 08 20 16:00:00          1       3364         37
2013 08 20 17:00:00          1         22          1
2013 08 20 21:00:00          1          9          1

Also, the following script is useful to find the archivelog switches on an hourly basis that happened in the past one week, I got this from http://kubilaykara.blogspot.com/2008/02/redo-log-generation.html and is quite an useful one.

SELECT to_date(first_time) DAY,to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'99') "00",to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'99') "01",to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)),'99') "02",to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)),'99') "03",to_char(sum(decode(to_char(first_time,'HH24'),'04',1,0)),'99') "04",to_char(sum(decode(to_char(first_time,'HH24'),'05',1,0)),'99') "05",to_char(sum(decode(to_char(first_time,'HH24'),'06',1,0)),'99') "06",to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)),'99') "07",to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)),'99') "08",to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)),'99') "09",to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)),'99') "10",to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)),'99') "11",to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)),'99') "12",to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)),'99') "13",to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)),'99') "14",to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)),'99') "15",to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)),'99') "16",to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)),'99') "17",to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)),'99') "18",to_char(sum(decode(to_char(first_time,'HH24'),'19',1,0)),'99') "19",to_char(sum(decode(to_char(first_time,'HH24'),'20',1,0)),'99') "20",to_char(sum(decode(to_char(first_time,'HH24'),'21',1,0)),'99') "21",to_char(sum(decode(to_char(first_time,'HH24'),'22',1,0)),'99') "22",to_char(sum(decode(to_char(first_time,'HH24'),'23',1,0)),'99') "23"fromv$log_historywhere to_date(first_time) > sysdate - 8 -- or else change it you want for more days to viewGROUP byto_char(first_time,'YYYY-MON-DD'), to_date(first_time)order by to_date(first_time)
/

Sample output:

DAY 00 01 02 03 04 05 06 09 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23
--------- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- -
01-NOV-13 0 1 1 0 1 0 1 0 1 4 1 1 0 1 0 1 1 0 1 1 1 1 1 1
02-NOV-13 0 1 1 1 1 0 1 1 1 1 0 1 1 7 1 1 1 1 1 2 1 1 1 1
03-NOV-13 1 2 2 1 1 1 1 1 1 1 1 2 1 1 1 1 1 2 1 1 2 1 1 2
04-NOV-13 1 1 8 1 7 2 1 1 1 2 1 1 2 1 2 1 2 1 2 1 2 1 2 2
05-NOV-13 2 1 2 1 2 2 1 2 1 2 2 1 2 2 1 2 2 2 1 2 2 2 2 2
06-NOV-13 2 1 2 2 2 2 1 2 2 2 2 2 1 2 2 1 0 2 0 0 0 0 1 0
09-NOV-13 0 0 1 7 0 0 1 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0

Wednesday, October 30, 2013

Diskgroup is not compatible for database usage



At the time of database creation using dbca on X3 Exadata Box, found this compatibility mismatch issue.

Diskgroup "+DATA_DR" is not compatible for database usage. Database compatible attribute of diskgroup should be the same or lower than the database compatible initialization parameter value.Database compatible parameter is set to "11.2.0.0.0"and the diskgroup database compatibility attribute is set to "11.2.0.2".  


The error was easy to understand as compatible parameter set in the database initialization parameter was lower than the compatible rdbms set for the diskgroup in ASM. The db compatible parameter was set to 11.2.0.0.0 whereas for the diskgroup compatible rdbms was set to 11.2.0.2.0.

DBCA (choose General Purpose) doesn’t provide any screen wherein we can change the parameter value. But as we want to create the database using dbca, we need to change the parameter value in the template stored in ORACLE_HOME/assistants/dbca/templates

[oracle@xxxxx ~]$ cd {ORACLE_HOME}/assistants/dbca/templates
[oracle@xxxxx templates]$ vi General_Purpose.dbc 

         <initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
         <initParam name="compatible" value="11.2.0.2.0"/>

         <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>

Edit above compatible parameter to 11.2.0.2.0 and save the file and start creating database using dbca, you won't be faced this issue again.

Thank you,
Manish Nashikkar


You (oracle) are not allowed to use this program (crontab)

Problem:
$ crontab -e
You (oracle) are not allowed to use this program (crontab)
See crontab(1) for more information
Solution:
cd /usr/lib/cron or /etc directory
## or find where cron.allow and cron.deny are:
## find / -name "cron.allow"
## find / -name "cron.deny"
Either remove your user in
cron.deny
and add your username in
cron.allow
If files do not exist, we can create them.

Thursday, October 24, 2013

Some issues faced during upgrade to R12 (12.1.3) from 12.1.x and their Solutions



2  Run       AutoPatch R120     mth_pre_upgrade.sql         FAILED

"adwork002.log" 234201L, 8356714C

sqlplus -s MTH/***** @/u01/app/oracle/EBS/apps/apps_st/appl/mth/12.0.0/patch/115/sql/mth_pre_upgrade.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Apr 09 2012 00:28:06
"adwork002.log" 234201L, 8356714C               


Cause:  You're trying to create the same table (MTH_RESOURCES_D_TEMP) over and over again in your loop.
It will succeed the first time (provided the table does not yet exist), but will fail after that.

Solution:

SQL> conn mth/mth
Connected.
SQL> rename MTH_RESOURCES_D_TEMP to MTH_RESOURCES_D_TEMP_OLD;

Table renamed.

SQL> exit


Restart respective 2nd worker.

=========================================================================

ATTENTION: All workers either have failed or are waiting:

           FAILED: file POXOTCPO.sql on worker  1.
           FAILED: file arhzbobj.sql on worker  2.

        Control
Worker  Code      Context            Filename                    Status
------  --------  -----------------  --------------------------  --------------
     1  Run       AutoPatch R120     POXOTCPO.sql                FAILED
     2  Run       AutoPatch R120     arhzbobj.sql                FAILED


sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/po/12.0.0/patch/115/sql/POXOTCPO.sql
Connected.

Type body created.

O/S Message: Invalid argument


sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/ar/12.0.0/patch/115/sql/arhzbobj.sql
Connected.
drop type hz_person_cust_v2_bo_tbl
*


SQL> select OWNER,OBJECT_NAME,STATUS,OBJECT_TYPE from dba_objects where object_name like '%PO%_TYPE' and status='INVALID';

OWNER                          OBJECT_NAME                                                  STATUS  OBJECT_TYPE
------------------------------ ------------------------------------------------------------ ------- -------------------
APPS                           PO_EVENT_PARAMS_TYPE                                         INVALID TYPE BODY
APPS                           PO_VALIDATION_RESULTS_TYPE                                   INVALID TYPE BODY
APPS                           PO_AP_DIST_REC_TYPE                                          INVALID TYPE BODY
APPS                           PO_AP_LINE_LOC_REC_TYPE                                      INVALID TYPE BODY
APPS                           PO_DISTRIBUTIONS_REC_TYPE                                    INVALID TYPE BODY


===============================================================================================


ATTENTION: All workers either have failed or are waiting:

           FAILED: file xlajelns.pkh on worker  1.
           FAILED: file csdvints.pls on worker  6.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

[applmgr@ebs2 log]$ vi adwork001.log

sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/admin/EBS/out/p001invok.sql
Connected.
O/S Message: Invalid argument

[applmgr@ebs2 log]$ vi adwork006.log

sqlplus -s APPS/***** @/u01/app/oracle/EBS/apps/apps_st/appl/csd/12.0.0/patch/115/sql/csdvints.pls
Connected.
O/S Message: Invalid argument


Running Script Apreconb.pls Fails With Error 'O/S Message: Invalid argument' On OCFS2 File System (Doc ID 1264418.1)


I had entry of /dev/sdb1 like,

/dev/sdb1 /u01 ocfs2 rw,_netdev,datavolume,nointr  

My /etc/fstab entry look like after modification,

[root@ebs1 ~]# cat /etc/fstab
LABEL=/                 /                       ext3    defaults        1 1
LABEL=/boot             /boot                   ext3    defaults        1 2
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
LABEL=SWAP-sda2         swap                    swap    defaults        0 0
/dev/sdb1               /u01                    ocfs2   rw,_netdev,nointr     0 0
172.18.0.195:/software  /software               nfs     defaults        0 0



restarted patch, after which patch application was successful.
=====================================================================================

At the time of Upgrade from R12.1.1 to R12.1.3, while applying main patch 9239090


[applmgr@db1 log]$ tail u9239090.log

Relinking executables...


[applmgr@db1 log]$ tail -f adrelink.log

make: *** [/u01/app/oracle/EBS/apps/apps_st/appl/fem/12.0.0/bin/FEMCCE] Error
1
Done with link of fem executable 'FEMCCE' on Sun Apr 15 05:26:30 IST 2012

Relink of module "FEMCCE" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure.  Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /u01/app/oracle/EBS/apps/apps_st/appl/fem/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Done with link of product 'fem' on Sun Apr 15 05:26:30 IST 2012

.
.
.
.
.
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adshell.pl to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adshell.pl
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/aducsifm.pm to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/aducsifm.pm
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/aducssp.pl to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/aducssp.pl
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adutils.pl to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adutils.pl
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adpchnew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adpatchnew
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adadminnew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adadminnew
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adwrknew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adworker
copying /u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bin/adctrlnew to
/u01/app/oracle/EBS/apps/apps_st/appl/ad/12.0.0/bintmp/adctrlnew

Swapping bintmp and binstage.
Stage preparation complete.

adrelink is exiting with status 1

End of adrelink session
Date/time is  Sun Apr 15 05:27:47 IST 2012
**********************************************************

Solution:

1.  To fix this problem, users are required to replace the following line under the Linux section of the $AD_TOP/bin/adrelinknew.sh:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

with

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'

2. After making this change, users are then required to run the adadmin utility and relink application executables.

Output after relinking FEM_TOP with adadmin utility
**********************************************************

Done with link of fem executable 'FEMCCE' on Sun Apr 15 06:42:27 IST 2012

Done relinking module FEMCCE in product fem
Done with link of product 'fem' on Sun Apr 15 06:42:27 IST 2012


adrelink is exiting with status 0

End of adrelink session
Date/time is  Sun Apr 15 06:42:27 IST 2012
**********************************************************

Continue patch where it stuck on "An error occurred while relinking application programs.

Continue as if it were successful [No] : Yes

Continue with patch application...



Thank you,
Manish Nashikkar

Friday, October 18, 2013

How to apply a patch in between a patch( Interim patch) in apps 11i/R12 or How to restart a failed adpatch in 11i/R12

adpatch reads the .drv(driver) file in the patch and does the actions accordingly.It creates two Internal tables in APPLSYS account called AD_DEFERRED_JOBS and FND_INSTALL_PROCESSES for controlling adworkers, the workers statuses are controlled in these tables.

Also the Actions of the adpatch are stored in .rf9 file format in $APPL_TOP/admin/$TWO_TASK/restart directory..

when ever an adpatch is restarted from a failed session,it looks in to this folder to do
the restart work from where it has failed!.

Coming to the Actual procedure how to apply an interim ad patch do the following procedures.

1. Login adctrl and choose the option (tell the manager that a worker failed its job) — to stop
the existing patching…

2.login to APPLSYS and create backup of the two tables AD_DEFERRED_JOBS & FND_INSTALL_PROCESSES

3. take a backup of the restart folder(or directory) under $APPL_TOP/admin/$TWO_TASK/

4.Apply the Interim(Intermediate ) patch successfully ,when asked for to continue
with failed session in adpatch say No and to the next question choose Yes
(so that you will erase the failed session and start a fresh patching).

5.After finishing the Intermediate patch , restore the tables AD_DEFERRED_JOBS and
FND_INSTALL_PROCESS and the restart directory under $APPL_TOP/admin/$TWO_TASK.

6.login to adctrl and instruct the manager to restart the jobs.

7.Return to the original patch directory and invoke adpatch and now it will
ask “whether to continue with failed session”.

You have to give “Yes” and proceed with the original or existing patching…


Thanks,
Manish

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