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 (26processes 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).
RE: Web DB 2.5 listener always hung for Oracle HRMS applications
Hi Hemant, 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:10 AM To: CHAN Chor Ling Catherine (CSC) Cc: [EMAIL PROTECTED] 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 (26processes 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
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
RE: Web DB 2.5 listener always hung for Oracle HRMS applications
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/10: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 applicationsV11. 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
