| Cannot start Database 10g [message #454247] |
Tue, 04 May 2010 11:01  |
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
|
Member |
|
|
Hi,
I start my database and suddenly got this error:
ORA-00371: not enough shared pool memory, at least 72102521958 bytes
How to fix? I use startup command only and shutdown when shutdown the database. Any idea why?
Thank you.
|
|
|
|
| Re: Cannot start Database 10g [message #454250 is a reply to message #454247] |
Tue, 04 May 2010 11:15  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
oerr ora 00371
00371, 00000, "not enough shared pool memory, should be atleast %s bytes"
// *Cause: Init.ora parameter shared_pool_size is too small
// *Action: Increase the parameter value
Have you increased/decreased shared_pool_size?
Babu
[Updated on: Tue, 04 May 2010 11:16] Report message to a moderator |
|
|
|
| Re: Cannot start Database 10g [message #454373 is a reply to message #454247] |
Wed, 05 May 2010 05:30 |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Hi,
If you are using SGA_MAX and SGA_TARGET, then there is no need to set or update this value.
Otherwise check you init.ora file for the value of this parameter and as Gentlebabu suggested, increase this value to some higher value as suggested by oracle error.
Regards
Lalit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
