Home » Infrastructure » Windows » Windows 2003 9i database service shuts down with no logs
Windows 2003 9i database service shuts down with no logs [message #387045] Tue, 17 February 2009 13:18 Go to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Hello,

We are experiencing this bizarre and re-occuring issue that is having a severe impact on our users.

Specs:
Windows 2003 SP2
4 GB RAm ( with /3gb and /PAE switch )

oracle 9.2.0.8
Pga_target = 1gb
sga_max = 2.5gb

The problem is that nothing is produced prior in the alert.log o and no core dump is created when the database service just halts in the event viewer and DB crashes.

My question is why is it crashing this way without leaving any traces , is it memory related as per those specs?
Has anyone ever had this prob?
Oracle support is pointing to a Windows problem and if my allocated memory for Oracle would be too high, i would get mem errors in alert correct ?

I am not receiving any ora-4030 errors either and nothing external from the application.

any help would be much appreciated
thx
John
Re: Windows 2003 9i database service shuts down with no logs [message #387047 is a reply to message #387045] Tue, 17 February 2009 13:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
As far as I know, 32-bit Windows can only address 3GB RAM.
I suggest you reduce the memory Oracle thinks it can (ab)use
& leave some RAM for Windows, too.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

[Updated on: Tue, 17 February 2009 13:39]

Report message to a moderator

Re: Windows 2003 9i database service shuts down with no logs [message #387048 is a reply to message #387045] Tue, 17 February 2009 13:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I agree with Oracle, this is more likely a Windows problem, above all if you have any trace in Oracle files.

Regards
Michel
Re: Windows 2003 9i database service shuts down with no logs [message #387049 is a reply to message #387045] Tue, 17 February 2009 13:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I am surprised Oracle is even talking to you.

oracle 9.2.0.8 was retired & obsoleted before Windows 2003 was released.
Re: Windows 2003 9i database service shuts down with no logs [message #387050 is a reply to message #387045] Tue, 17 February 2009 13:49 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Thanks alot guys for your quick response...

I am at a lost as too what is going on with the process as it happens very random ( i.e twice a month ).

If Oracle would be choking then it would produce errors or performance would take a hit. In this case the Oracle process just dies and nothing is written in any logs ( very strange ).

So by tweaking the memory ( sga_max and pga sizes ) can I prevent this ? I do have the /3gb switch and it's supposed to reach to 3.7. Why would windows just kill the process ?

Many thanks and I apologize fr the direct question as not even Oracle support has an answer.

J

Re: Windows 2003 9i database service shuts down with no logs [message #387051 is a reply to message #387049] Tue, 17 February 2009 13:59 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
We still have support for 9.2 as it's been extended till next year.
Re: Windows 2003 9i database service shuts down with no logs [message #387052 is a reply to message #387049] Tue, 17 February 2009 14:02 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
My SGA params are:

Shared Pool 320 MB
Buffer Cache 720 MB
Large Pool 256 MB
Java Pool * 24 MB
Other (MB) 19

Total SGA (MB) 1339 MB

max_SGA 2.5 GB

Would my problem be that the max_sga is reached for whatever reason and therefore the server is left with nothing. So bringing the max down to 2gb would leave more ram for the server ? is this a possibility ?

[Updated on: Tue, 17 February 2009 14:06]

Report message to a moderator

Re: Windows 2003 9i database service shuts down with no logs [message #387053 is a reply to message #387045] Tue, 17 February 2009 14:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Under normal conditions, Oracle will leave droppings when bad things happen.
If what you report accurately reflects reality, then by definition you do not have normal conditions.
Without dump file, trace file, alert log entries or additional evidence, all anyone can do is speculate.

I have to ask why/how it was decided that 2.5GB SGA was needed.
It has been years since I dealt with V9, but I thought default maximum SGA size was around 1.7GB.

I'd suggest you reduce max SGA down to 1.5GB & see if crashes continue.
Re: Windows 2003 9i database service shuts down with no logs [message #387054 is a reply to message #387053] Tue, 17 February 2009 14:09 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
I just inherited this DB and just recently it has started to do weird things. Absolutely no "droppings" as you say are produced.

So I will reduce the SGA_MAX from 2.5gb to 2gb and the PGA is at 1GB ? Lower to 700 ?

Re: Windows 2003 9i database service shuts down with no logs [message #387057 is a reply to message #387054] Tue, 17 February 2009 15:22 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Can you post what message exactly "the database service just halts in the event viewer" is?

Also, there MIGHT be some clue in with which error the client applications are crashing, if there are any.

By the way, the *only* time I had Oracle crash for me once without *any* traces once was when the RAM was physically bad. Maybe you could run MEMTEST86 on the box to be sure that's not the case.
Re: Windows 2003 9i database service shuts down with no logs [message #387061 is a reply to message #387057] Tue, 17 February 2009 16:05 Go to previous messageGo to next message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Sorry for now being clearer... the Oracle service just stops as if it's killed by the OS Confused
The message is that "the service has stopped unexpectedly...."

The memory seems OK as per my admin.

Now is this really a memory issue ?

Re: Windows 2003 9i database service shuts down with no logs [message #387514 is a reply to message #387061] Thu, 19 February 2009 12:26 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>the Oracle service just stops as if it's killed by the OS

Please explain me; why it's killed by OS level
Re: Windows 2003 9i database service shuts down with no logs [message #387525 is a reply to message #387045] Thu, 19 February 2009 14:51 Go to previous message
jrmtl
Messages: 27
Registered: February 2006
Junior Member
Hi gentlebabu...

That's exactly what happens, the windows OracleService for the database just stops and crashes in the event viewer.
No errors are shown in alert or any core dumps created.

I am trying to prove if my SGA and PGA are too high which is causing wndows to react this way.
I'm assuming it's the OS that is killing the process as strange as it may seem as no Oracle logs are produced.

Oracle support are pointing to the OS's fault.

thx
Previous Topic: Oracle 10g Installaion
Next Topic: Oracle 9i DB Closes Randomly
Goto Forum:
  


Current Time: Sat Nov 02 13:42:56 CDT 2024