Home » RDBMS Server » Server Administration » ORA-27102: out of memory, while increasing the size of SGA (10g, 10.2.0.1, window server 2008)
ORA-27102: out of memory, while increasing the size of SGA [message #633015] Tue, 10 February 2015 03:42 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

While increasing size of SGA of database, we are getting below error -
ORA-27102: out of memory
OSD-00029: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command.


after investigating in alert log, came to know that
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !


32-bit database is installed in 64 bit windows server. Is this would be the issue? We have 12 gb ram in server. But we can able to make upto 3 gb size for SGA. Beyond it, error throws.

Please suggest !!!

Regards,
Ashish Kumar Mahanta
Re: ORA-27102: out of memory, while increasing the size of SGA [message #633018 is a reply to message #633015] Tue, 10 February 2015 04:08 Go to previous messageGo to next message
John Watson
Messages: 7262
Registered: January 2010
Location: Global Village
Senior Member
ashishkumarmahanta80 wrote on Tue, 10 February 2015 09:42

32-bit database is installed in 64 bit windows server. Is this would be the issue?

Yes.
Re: ORA-27102: out of memory, while increasing the size of SGA [message #633024 is a reply to message #633018] Tue, 10 February 2015 04:46 Go to previous messageGo to next message
Flyby
Messages: 185
Registered: March 2011
Location: Belgium
Senior Member
use the 64-bit-version if you want to use more than 2 GB RAM
Re: ORA-27102: out of memory, while increasing the size of SGA [message #633030 is a reply to message #633024] Tue, 10 February 2015 05:56 Go to previous message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Thanks to you all...
Previous Topic: invalid username/password; logon denied
Next Topic: spfile creation from pfile (during upgrade from 11.2.0.1. to 11.2.0.3)
Goto Forum:
  


Current Time: Wed Feb 21 06:07:08 CST 2018

Total time taken to generate the page: 0.01330 seconds