Home » RDBMS Server » Server Administration » Error
Error [message #296096] Thu, 24 January 2008 10:25 Go to next message
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 #296100 is a reply to message #296096] Thu, 24 January 2008 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
How can we know which bug you refer you didn't even give your version number with 4 decimals as requested?

Regards
Michel
Re: Error [message #296163 is a reply to message #296096] Thu, 24 January 2008 22:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #296188 is a reply to message #296187] Fri, 25 January 2008 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
please let me know if I missed something

I asked database version with 4 decimals (10.2 is only 2)
I asked which bug you are refering.
You said you found some information, where? Are there relevant? Post url.

ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted


Regards
Michel
Re: Error [message #296192 is a reply to message #296187] Fri, 25 January 2008 01:18 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Version - 10.2.0.1.0.


Here are the url's

http://forums.oracle.com/forums/thread.jspa?threadID=368529

http://dba.ipbhost.com/lofiversion/index.php/t4606.html

Thanks

- Das
Re: Error [message #296195 is a reply to message #296192] Fri, 25 January 2008 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you try the solutions in these forums?
Did you read the referenced Metalink note?
Did you investigate the reason of 4030 errors?

Regards
Michel
Re: Error [message #296214 is a reply to message #296195] Fri, 25 January 2008 02:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: Error [message #296232 is a reply to message #296220] Fri, 25 January 2008 03:32 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks Manjit.

That will help

- Das
Previous Topic: Doubt in configuring shared server
Next Topic: Estimate database size
Goto Forum:
  


Current Time: Sat Nov 09 16:32:14 CST 2024