Home » RDBMS Server » Server Administration » ORA 00371 NOT ENOUGH SHARED POOL MEMORY (Oracle 10.2.0.3 , O/s Wiindows Vista business 32 bit)
ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541381] Tue, 31 January 2012 01:04 Go to next message
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..
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541389 is a reply to message #541381] Tue, 31 January 2012 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541396 is a reply to message #541381] Tue, 31 January 2012 01:56 Go to previous messageGo to next message
John Watson
Messages: 8922
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>


Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541397 is a reply to message #541389] Tue, 31 January 2012 01:56 Go to previous messageGo to next message
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..
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541398 is a reply to message #541396] Tue, 31 January 2012 02:02 Go to previous messageGo to next message
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..?
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541400 is a reply to message #541398] Tue, 31 January 2012 02:07 Go to previous messageGo to next message
John Watson
Messages: 8922
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

Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541407 is a reply to message #541397] Tue, 31 January 2012 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i already attached my .ora file


I can't download files.

Regards
Michel
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541410 is a reply to message #541400] Tue, 31 January 2012 02:27 Go to previous messageGo to next message
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



Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541411 is a reply to message #541407] Tue, 31 January 2012 02:29 Go to previous messageGo to next message
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
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541412 is a reply to message #541411] Tue, 31 January 2012 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541415 is a reply to message #541412] Tue, 31 January 2012 02:46 Go to previous messageGo to next message
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 10823 times)
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541418 is a reply to message #541415] Tue, 31 January 2012 03:00 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541427 is a reply to message #541418] Tue, 31 January 2012 03:41 Go to previous messageGo to next message
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...
Re: ORA 00371 NOT ENOUGH SHARED POOL MEMORY [message #541430 is a reply to message #541427] Tue, 31 January 2012 04:05 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Fri Mar 29 09:38:16 CDT 2024