Error [message #296096] |
Thu, 24 January 2008 10:25 |
durgadas.menon
Messages: 365 Registered: December 2007 Location: Nowhere
|
Senior Member |
|
|
Guys,
I got this error today then the systems stopped accepting data even the /as sysdba was not able to access the database. I had to stop and start the service and then restart the database and then things started working.
Errors in file d:\oracle\product\10.2.0\admin\gidc\bdump\gidc_psp0_3140.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27302: failure occurred at: skgpspawn
Various chats say it is a bug and patch 10 (patch number 5639232)has to be applied to the database.
Any server settings can give me temporary respite for this?
- Das
|
|
|
|
Re: Error [message #296163 is a reply to message #296096] |
Thu, 24 January 2008 22:54 |
mkbhati
Messages: 93 Registered: February 2007 Location: Mumbai
|
Member |
|
|
Forum members would indeed appreciate if more details can be posted.
(a) Database Version
(b) OS Version with patch/SP number
(c) full error from trace
(d) any thing specific which you think may be of help in understanding your situation.
Regards
|
|
|
Re: Error [message #296187 is a reply to message #296163] |
Fri, 25 January 2008 00:59 |
durgadas.menon
Messages: 365 Registered: December 2007 Location: Nowhere
|
Senior Member |
|
|
Here are all the details I have on this..please let me know if I missed something
We have a database server (10g on win 2003) and an application server at our office. The application is made on forms 10g and the data entry operators enter details into it.
Suddenly the systems stopped accepting data. The operators were not able to enter data. Attached are the readings from the alert log for that period. The file says out of memory. The server has 2gb ram and operations are limited (the system is not fully operational). I tried to login /as sysdba into the system but it gave TNS adapter error.
I had to stop the service manually and restart the database to get it fixed.
Any other possible solution that you can think of.
Any system configurations that I can do at the database level that can avert such an error?
I did some research on the error and many DBA's have come across this error on 2003 server and have been asked to apply a patch (patch 10, patch number 5639232)
Database Version - 10.2
OS - Windows 2003 server
- Das
|
|
|
|
|
|
Re: Error [message #296214 is a reply to message #296195] |
Fri, 25 January 2008 02:02 |
durgadas.menon
Messages: 365 Registered: December 2007 Location: Nowhere
|
Senior Member |
|
|
i did but may be not detailed enough.
Let me do it again and get back if I still don't understand
- Das
|
|
|
Re: Error [message #296220 is a reply to message #296096] |
Fri, 25 January 2008 02:36 |
mkbhati
Messages: 93 Registered: February 2007 Location: Mumbai
|
Member |
|
|
Das, I have gone through above mentioned forum posts.
Do not try /3GB or /PAE setting/resetting in Windows 2003. These memory switches are to be set up after first boot while you install windows. These switches change windows memory paging schemes in order to allow higher per process memory. If you try setting/resetting these switches on a windows host having Oracle installation than your Oracle server will start behaving in a strange way with lot of never heard errors.
1. If you have received this error only once & restarting have solved them than it can be attributed to transient OS instability which is common on windows platform.
2. If problem repeats than matter need to be investigated further. Traces you have posted indicates that recursive PLSQL code is being used in some scheduled job. This recursive code is demanding memory resources [recursive code is often very memory hungry]which have exhausted.
3. Check the code fragment causing recursive calls. Often effect of recursive code calls do not show up until amount of data they handle rises beyond certain limit & causing strain on OS resource limits.
4. If #2 above is found to be true than try executing that job again & error symptoms should reappear.
Regards
Manjit Kumar [mkbhati]
[Updated on: Fri, 25 January 2008 02:38] Report message to a moderator
|
|
|
|