Home » RDBMS Server » Server Administration » ora-00371 (oracle 10g,linux)
ora-00371 [message #436847] Tue, 29 December 2009 00:02 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
Hi,
i installed oracle 10g in linux and am facing the exception
ora 00371
not enough shared pool memory, should be atleast string bytes.

how to solve this even my init.ora file looks fine.where went wrong in this.
Re: ora-00371 [message #436850 is a reply to message #436847] Tue, 29 December 2009 00:06 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ORA-00371: not enough shared pool memory,
 should be atleast string bytes
Cause: Init.ora parameter shared_pool_size is too small
Action: Increase the parameter value
 


sriram Smile

[Updated on: Tue, 29 December 2009 00:07]

Report message to a moderator

Re: ora-00371 [message #436851 is a reply to message #436850] Tue, 29 December 2009 00:14 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
i increased but still same error.frequently it is happening how to come over this.
Re: ora-00371 [message #436852 is a reply to message #436850] Tue, 29 December 2009 00:17 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
For more information read this
Instalation guide

And This

And this too
Quote:
i increased but still same error.frequently it is happening how to come over this.


Quote:
ramoradba

ORA-00371: not enough shared pool memory,
should be atleast string bytes
Cause: Init.ora parameter shared_pool_size is too small
Action: Increase the parameter value



sriram

Who knows how much amount of size you increased .... Smile

sriram Smile




Re: ora-00371 [message #436863 is a reply to message #436847] Tue, 29 December 2009 02:59 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rajasekhar857 wrote on Tue, 29 December 2009 07:02
Hi,
i installed oracle 10g in linux and am facing the exception
ora 00371
not enough shared pool memory, should be atleast string bytes.

how to solve this even my init.ora file looks fine.where went wrong in this.

Are you sure you use init.ora and not spfile?
Post output of:
show parameter pfile

Regards
Michel

Previous Topic: rman instance crash and disapp
Next Topic: no of users in DB
Goto Forum:
  


Current Time: Mon Dec 05 18:57:58 CST 2016

Total time taken to generate the page: 0.12160 seconds