Re: ORA-4031 error and can't login to the db
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: haroon@xxxxxxxxxxxx
- Date: Thu, 23 Jun 2005 12:32:45 -0400
On 6/23/05, Haroon A. Qureshi <haroon@xxxxxxxxxxxx> wrote:
> hello,
>
> i was applying the 11.5.10 maintenance patch for oracle 11i.
> the last phase of the patch is to recompile invalid objects.
> i recieved an ora-4031 trace file dump and everything is just
> hanging right now. i'm also not able to login to the
> database, either as sys or any user. it just sits there.
>
> has anyone seen this happen before or knows what's going on?
> the 4031 trace seems to have been generated when trying to
> recomile a view. from my understanding, the 4031 tends to
> happens when the SGA is too small and it can't allocate any
> more memory to it. but how can i get into the db to shut it
> down and resize everything? i don't know why i'm unable to
> log in and don't know how to get around it.
>
> help! :)
>
> thanks in advance,
> haroon
Haroon,
What was the size of the shared_pool when you were applying the patch?
As described in the readme for database software patchsets, the
shared_pool should be sized at minimum 150 MB (I prefer 160 MB as its
a multiple of 16MB) when running catpatch.sql.
I'd recommend killing the instance, starting up with a larger
shared_pool (and java_pool) size and re-running the patch.
good luck.
Paul
--
//www.freelists.org/webpage/oracle-l
Other related posts:
