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).
