ponedjeljak, 11. lipnja 2012.

Space Leak" when shutting down db 11GR2

When i try to shut down database 11.2.0.2 (immediate, as sysdba) i got the error : ORA-600 [729][][].....

Metalink posts on that topic:
  A space leak has been detected in the User Global Area (UGA).
There is NO data corruption as a result of this error.
It is an internal memory housekeeping problem.

And solution is to:

Set the following in init.ora for example to disable space
  leaks less than 4000 bytes:

event = "10262 trace name context forever, level 4000"

and stop and restart the database.

On test machine i did not wait  shutdown immediate to finish and instead executed shutdown abort.
After that database was restarted normally.




Nema komentara:

Objavi komentar