Re: Web Apllication Server 3.0 causing Database server to hang

From: Mike Albright <albrigm_at_psd.k12.co.us>
Date: 1998/01/06
Message-ID: <34B2BAA9.CB5E7341@psd.k12.co.us>#1/1

We experienced similar problems with our NT WAS/Oracle Database server and finally narrowed the problem down to the way we performed our upgrade. None of the Oracle documentation mentions this but we had to:

Completely shut down the previous version (manually shut down service from command prompt)
Completely uninstall the previous WAS (checking the registry to ensure completeness)
Completely delete the files for the previous WAS
Then perform the upgrade for the new version

Another thing Oracle forgets to mention is that on NT any edits made to the Listener can only be done after the Listener has been stopped. Once changes are made, restart the Listener. As it turns out that's where our problems began.

Hope it helps!

Mike Albright, Oracle Guy                        albrigm(at)psd.k12.co.us

Information Systems
Poudre School District, Fort Collins, CO

chris neale wrote:

> we have had the same problem too with both the was and the database running
> on windows nt machines
>
> "Carel-Jan Engel wrote in message <66k8le$iaf$1_at_thor.wirehub.nl>...
> >We are working on a strange problem regarding Oracle Web Aplication
> >Server 3.0.1.8.0.0 on Windows NT and SGI/Irix. The database is Oracle
> >7.1.3, running on an IBM SP/2 node (AIX), accessed via SQL*Net.
> >
> >Running WAS on Windows NT gives good performance (less than a second),
> >but crashes pretty often.
> >
> >Running WAS on the SGI machine (no other applications installed there)
> >gives bad performance (avg. 10 sec.). Sometimes however, a process on
> >the SP/2 node (most likely some shadow process of the SQL*Net
> >listener) consumes all available memory so causing the machine
> >to swap permanently.
> >
> >Until now we could not find anything that could cause this strange
> >behaviour. Oracle could not
> >help us either.
> >
> >Any suggestions around the world? Thanks in advance.
> >
> >Carel-Jan Engel
> >Ease Automation
> >careljan_at_ease.nl
> >
Received on Tue Jan 06 1998 - 00:00:00 CST