OraFAQ Forum: Server Administration » ORA 00371 NOT ENOUGH SHARED POOL MEMORY

Home » RDBMS Server » Server Administration » ORA 00371 NOT ENOUGH SHARED POOL MEMORY (Oracle 10.2.0.3 , O/s Wiindows Vista business 32 bit)

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

ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541381]

Tue, 31 January 2012 01:04

Tapan6415
Messages: 45
Registered: January 2012
Location: VADODARA

Member

hii,

i got (2)errors while start up my database ..
__________________________________________________

sql> startup nomount
ora 32004 : obsolete and/or deprecated parameters specified...
ora 00371: Not enough shared pool memory... at least 67212353 bytes
_________________________________________

i attached my pfile please tell me which is appropriate size i have to choose..?

Thanx..

Attachment: initorcldb.ora
(Size: 12.98KB, Downloaded 1669 times)

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541389 is a reply to message #541381]

Tue, 31 January 2012 01:36

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

Senior Member
Account Moderator

ORA-32004: obsolete and/or deprecated parameter(s) specified
 *Cause:  One or more obsolete and/or parameters were specified in
          the SPFILE or the PFILE on the server side.
 *Action: See alert log for a list of parameters that are obsolete.
          or deprecated. Remove them from the SPFILE or the server
          side PFILE.

ORA-00371: 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

The message gives you the least value.

Regards
Michel

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541396 is a reply to message #541381]

Tue, 31 January 2012 01:56

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

That is not the parameter file you are using, it has an illegal value for db_block_size which will prevent the instance from starting at all. I've just tested:

orcl> startup force pfile=c:\tmp\pfile.orcl
ORA-00374: parameter db_block_size = 81920000 invalid ; must be a multiple of 512 in the range [2048..16384]
orcl>

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541397 is a reply to message #541389]

Tue, 31 January 2012 01:56

Tapan6415
Messages: 45
Registered: January 2012
Location: VADODARA

Member

Michel Cadot wrote on Tue, 31 January 2012 10:36

ORA-32004: obsolete and/or deprecated parameter(s) specified
 *Cause:  One or more obsolete and/or parameters were specified in
          the SPFILE or the PFILE on the server side.
 *Action: See alert log for a list of parameters that are obsolete.
          or deprecated. Remove them from the SPFILE or the server
          side PFILE.

ORA-00371: 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

The message gives you the least value.

Regards
Michel

i already attached my .ora file , i unable to identify which parameters i can delete..

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541398 is a reply to message #541396]

Tue, 31 January 2012 02:02

Tapan6415
Messages: 45
Registered: January 2012
Location: VADODARA

Member

John Watson wrote on Tue, 31 January 2012 10:56

That is not the parameter file you are using, it has an illegal value for db_block_size which will prevent the instance from starting at all. I've just tested:
orcl> startup force pfile=c:\tmp\pfile.orcl
ORA-00374: parameter db_block_size = 81920000 invalid ; must be a multiple of 512 in the range [2048..16384]
orcl>

After getting error i tried to increase it can u tell me the suitable value..?

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541400 is a reply to message #541398]

Tue, 31 January 2012 02:07

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

You need to do some reading about parameters:

http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams041.htm#i1126018

http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams197.htm#i1133851

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541407 is a reply to message #541397]

Tue, 31 January 2012 02:24

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

Senior Member
Account Moderator

Quote:

i already attached my .ora file

I can't download files.

Regards
Michel

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541410 is a reply to message #541400]

Tue, 31 January 2012 02:27

Tapan6415
Messages: 45
Registered: January 2012
Location: VADODARA

Member

John Watson wrote on Tue, 31 January 2012 11:07

You need to do some reading about parameters:

http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams041.htm#i1126018

http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams197.htm#i1133851

ya i read it..

but still now m in confuse , m specifying my (bytes)
db_block_size = 16384
-------------------------------------
its telling me at lest 67232153
-----------------------------------
if i am specifying more than 16384 then it shows me error

in range of [2048]->[16384]
------------------------------------

i got 512*131340=6724680 then also it shows error..

so what can i do..??

Thanx for replying

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541411 is a reply to message #541407]

Tue, 31 January 2012 02:29

Tapan6415
Messages: 45
Registered: January 2012
Location: VADODARA

Member

Michel Cadot wrote on Tue, 31 January 2012 11:24

Quote:
i already attached my .ora file

I can't download files.

Regards
Michel

i again uploaded it

check it again

Thanx for replying

Attachment: initorcldb.ora
(Size: 12.98KB, Downloaded 1584 times)

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541412 is a reply to message #541411]

Tue, 31 January 2012 02:32

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

Senior Member
Account Moderator

No, you don't understand you, I can't download any file (and I'm not the only one),
this is why our guide mention the preferred way is to post inline.

Quote:

its telling me at lest 67232153

It's telling you this for shared_pool_size NOT for db_block_size.

Regards
Michel

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541415 is a reply to message #541412]

Tue, 31 January 2012 02:46

Tapan6415
Messages: 45
Registered: January 2012
Location: VADODARA

Member

Michel Cadot wrote on Tue, 31 January 2012 11:32

It's telling you this for shared_pool_size NOT for db_block_size.

but it shows me error of db_block size i also tried with the default size. wait m attaching my screen shot.. below

/forum/fa/9776/0/

Attachment: os_cmds.jpg
(Size: 53.59KB, Downloaded 11453 times)

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541418 is a reply to message #541415]

Tue, 31 January 2012 03:00

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Quote:

ya i read it..

but still now m in confuse , m specifying my (bytes)
db_block_size = 16384

No, you did NOT read it. You must learn to read. The doc I pointed you to says this:Quote:

The value for DB_BLOCK_SIZE in effect at the time you create the database determines the size of the blocks. The value must remain set to its initial value.

You must put it back to what it was orignally. And in future, never change anything without researching it first.

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541427 is a reply to message #541418]

Tue, 31 January 2012 03:41

Tapan6415
Messages: 45
Registered: January 2012
Location: VADODARA

Member

John Watson wrote on Tue, 31 January 2012 12:00

You must put it back to what it was orignally. And in future, never change anything without researching it first.

now i put it to default value "8192"
ya.. it solved ... Razz

Thanx for pointing me ... Razz

but still one error left which says .."obsolete and deprecated parameters specified"

Will this error create any problem ahead?

Thanx...

Report message to a moderator

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541430 is a reply to message #541427]

Tue, 31 January 2012 04:05

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

Senior Member
Account Moderator

Anyway it is better to check the ones they are and fix them.
Starting a new database with obsolete parameters is not wise.

Regards
Michel

[Updated on: Tue, 31 January 2012 04:06]

Report message to a moderator

Previous Topic:	ORA - 00439 : Feature not enabled: Real Application Clusters
Next Topic:	ora 12701 create database character set is not known

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 18:35:40 CST 2025