OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ora-00371 (oracle 10g,linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-00371 [message #436847]

Tue, 29 December 2009 00:02

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.

Report message to a moderator

Re: ora-00371 [message #436850 is a reply to message #436847]

Tue, 29 December 2009 00:06

ramoradba
Messages: 2457
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

[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

rajasekhar857
Messages: 500
Registered: December 2008

Senior Member

hi,
i increased but still same error.frequently it is happening how to come over this.

Report message to a moderator

Re: ora-00371 [message #436852 is a reply to message #436850]

Tue, 29 December 2009 00:17

ramoradba
Messages: 2457
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

Report message to a moderator

Re: ora-00371 [message #436863 is a reply to message #436847]

Tue, 29 December 2009 02:59

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 04:19:47 CST 2025