Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Diagnosing a Win2k Server Crash

Re: Diagnosing a Win2k Server Crash

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 21 May 2002 07:50:37 +0100
Message-ID: <3ce9ee39$0$231$cc9e4d1f@news.dial.pipex.com>


"Mike Cretan" <mcretan_at_ozemail.com.au> wrote in message news:8skG8.39$wH5.31853_at_vicpull1.telstra.net...
> Hi folks,
>
> We've got a 8.1.7.3 server on win2k sp2 which, among other things, uses
the
> extproc external function interface to access an australian barcoding
system
> from Quick Address Systems using their API DLL. It works really well,
> processing about 1500 addresses a minute, and can be accessed real time
for
> database cleansing.
>
> My problem is that the server will occassionally reboot itself when its
> under been under load, and there is absolutely nothing recorded in the
event
> logs or alert files to indicate the problem. The process counters for
> extproc and the rdbms are constant across the board, but I suspect that a
> resource issue exists. If I schedule a database restart (not server) each
> night, the problem all but dissapears. The issue is that we need to go
> production, and the rebooting thing isn't so good!
>
> Can anyone give me some pointers as to how I can figure out where the
> problem is?
>
> I' not a hard core C programmer, but I managed to interface the DB to the
> QAS API DLL, and functionally everything is sweet. I rebuilt the server
> from scratch to no avail, however the new server had a higher spec than
the
> old one and the frequency between crashes definitely reduced.
>
> The crash produces the memory.dmp file, but how do I find out the
offending
> application from it?
>
> Thanks in advance for any ideas,

I know the actual blue screen will sometimes display the name of the library in which the crash occurred. You could try looking there. Also you say that a server reboot every night is unacceptable. Does this mean that you are going for a hot backup strategy in production (i.e. youwork 24*7) or do you have a backup window for cold backup?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue May 21 2002 - 01:50:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US