Windows 2003 9i database service shuts down with no logs [message #387045] |
Tue, 17 February 2009 13:18 |
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 #387050 is a reply to message #387045] |
Tue, 17 February 2009 13:49 |
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 #387052 is a reply to message #387049] |
Tue, 17 February 2009 14:02 |
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 #387057 is a reply to message #387054] |
Tue, 17 February 2009 15:22 |
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 #387525 is a reply to message #387045] |
Thu, 19 February 2009 14:51 |
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
|
|
|