OraFAQ Forum: Server Administration » ORA-4031.....while starting up database

Home » RDBMS Server » Server Administration » ORA-4031.....while starting up database (oracle 9.2.0.4 on solaris 5.9)

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

ORA-4031.....while starting up database [message #311271]

Thu, 03 April 2008 20:21

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

When I am trying to mount my database it is giving me following error:-

ORA-04031: unable to allocate 41032 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")

I have tried flushing the shared pool, but didnt help.

The shared pool size is pretty big around 1 Gb.

Report message to a moderator

Re: ORA-4031.....while starting up database [message #311303 is a reply to message #311271]

Fri, 04 April 2008 00:43

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

Senior Member
Account Moderator

You have to enlarge LARGE POOL not SHARED POOL, as pointed in the message.

Regards
Michel

Report message to a moderator

Re: ORA-4031.....while starting up database [message #311498 is a reply to message #311303]

Fri, 04 April 2008 11:36

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Check for pfile/spfile may be there more than one and which have not enough memory!!!As mentioned by Michel!

Report message to a moderator

Re: ORA-4031.....while starting up database [message #311775 is a reply to message #311271]

Sun, 06 April 2008 14:52

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Hi

I have checked the init.ora with the production instance, and all paramters match each other.
Large pool size = 9M & it is working fine on production.

Is there any other potential reason for this problem .

Report message to a moderator