ORA-4031 error and can't login to the db
- From: "Haroon A. Qureshi" <haroon@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 23 Jun 2005 11:08:41 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
