Hi Hemant,
Thanks for supplying the correct article number. I'll look into it.
Even if my web 2.5 listener is up and running (see below), my users still
cannot logon to the Oracle Applications. The listener just hung.
# ps -ef | grep 8000
orahrms 4406 4404 0 07:25:03 ? 0:03 wdblsnr orion 8000
orahrms 4404 1 0 07:25:03 ? 0:00 /bin/csh -f
/dg2/oracle/nieora/8.0.6/bin/wdbstart orion 8000
orahrms 7279 7271 0 13:53:45 pts/1 0:00 grep 8000
The problem can be solved by bouncing the listener.
Qn : Has anyone using "Oracle HRMS V11.5.1" migrated from WebDB to Apache
listener before ? How's the performance ? Does the apache listener "hung" ?
Please advise. Thank you.
Regds,
Catherine
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Web DB 2.5 listener always hung for
Oracle HRMS applications V11.
Catherine,
You have the wrong note. Look up Note 119873.1 titled
"Apache Single
Listener Configuration for Applications 11.5.1"
I don't know how you are using the "at" command to startup
the servers.
I didn't suggest that the forms server and reports server
die. I was
talking of the WebDB listener specifically !
WebDB2.2 handles forms sign-ons while 2.5 handles online
help and personal
home page and self-service modules.
Note 113254.1 refers to the Forms Server/Reports Server/
WebDB 2.2 dying
because of the
wrong shell. You need to check the shell your WebDB 2.5
runs from. Note
144400.1 covers
WebDB 2.5 as well.
Do a "ps -ef" to see if the process is running. Remember
that WebDB 2.2
and 2.5 have
different startup scripts and process names.
I do remember seeing WebDB 2.5 "die by itself"
occassionally. We had a
cron job running
the webdb startup script periodically.
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
21/02/2002 12:14 PM
To: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group@ST Domain,
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:
Subject: RE: Web DB 2.5 listener always hung
for Oracle HRMS applications
V11.
Hi Hemant,
Please ignore my earlier email.
We use the at command to startup all our form server/report
server/webdb
listener etc so that even if we were to logout of the telnet
session where
the WebDB listener is started. The form server/report
server/listener will
not "hung"/"died" because the parent shell has died.
>>>>>>>> Why don't you migrate from WebDB to Apache ?
I've found the document in metalink "Note:154666.1 => Moving
virtual
directory mappings from WebDB to iAS". Thanks.
Qn : Has anyone using "Oracle HRMS V11.5.1" migrated from
WebDB to Apache
before ? How's the performance ? Does the apache listener
"hung" ? Please
advise. Thank you.
Regds,
Catherine
-----Original Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21,
2002 11:08 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Web DB 2.5 listener
always hung for
Oracle HRMS applications V11.
Catherine,
Why don't you migrate from WebDB to
Apache ?. There
is
excellent
documentation
on migrating from WebDB to Apache for
11i.
Your WebDB listener could be "hung" if
it is running
in the
wrong shell --
eg if you
logout of the telnet session where the
WebDB listener
was
started, you will
see
subsequents requests to the listener
failing. This is
because the parent
shell
has died.
If you are starting it from the Bourne
shell, try
switching
to Korn shell
before starting it
(or vice versa).
Check whether the startup script calls
"nohup wdblsnr
<hostname>
<portnumber> &".
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing
Ltd
"CHAN Chor Ling Catherine (CSC)"
<[EMAIL PROTECTED]>
21/02/2002 10:13 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of
list ORACLE-L
<[EMAIL PROTECTED]>
cc: (bcc: CHITALE Hemant
Krishnarao/IT/CHRT/ST
Group)
Subject: Web DB 2.5
listener always hung
for
Oracle HRMS applications
V11.
Hi Gurus,
We are running Oracle HRMS Applications
11I (V11.5.1)
in two
E450 sun
servers. OS is Solaris 2.6
1st server contains the database,
concurrent manager
and
report server.
2nd server contains the apache
listener, TCF SERVER,
Web DB
2.5 listener,
Web DB 2.2 Listener and Form server
listener.
Qn : The Web DB 2.5 listener always
hung. Is there a
way to
solve the
problem ? Is anyone having the same
configurations as
me
with no problem ?
Please help. Thanks
I've checked the network roundtrip
between the 2
servers
using
tnsping=>fast, no bottlenecks
I've checked the number of processes in
the database :
it's
only 26
concurrent users (26<processes in the
init.ora)=>ok
I've checked the 1st and 2nd server
resources using
vmstat
and iostat :
There are enough memory => no
bottlenecks
Oracle consultants claim that there is
bug in the Web
DB 2.5
listener
(Version is "adwdbctl.sh.UNIX 115.1
2000/05/01
17:35:52").
The only
solution
is to bounce the web listener when the
problem arises.
We even schedule a job to bounce the
listener at 7am
and 1pm
but that does
not solve the problem. Sometimes, I
still have to
bounce the
web listener
manually when user reports the problem.
Regds,
New Bee
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858)
538-5051 FAX:
(858)
538-5051
San Diego, California -- Public
Internet access
/
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing
list, send an
E-Mail
message
to: [EMAIL PROTECTED] (note EXACT
spelling of
'ListGuru')
and in
the message BODY, include a line
containing: UNSUB
ORACLE-L
(or the name of mailing list you want
to be removed
from).
You may
also send the HELP command for other
information (like
subscribing).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858)
538-5051 FAX:
(858)
538-5051
San Diego, California -- Public
Internet access
/
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing
list, send an
E-Mail
message
to: [EMAIL PROTECTED] (note EXACT
spelling of
'ListGuru')
and in
the message BODY, include a line
containing: UNSUB
ORACLE-L
(or the name of mailing list you want
to be removed
from).
You may
also send the HELP command for other
information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
