Monthly Archives: January 2009

Database crash – ora-00822, MMAN process died.

Got a mail from my grid-control monitoring: database unavailable. After a very short look: database crashed. No changes made the last month. Version 10.2.0.4 on Suse Linux 10.1, 64-bit, on a VM (ESX).

Alert-log: ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+1] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [] Mon Dec 29 10:04:23 2008
Pmon-trace file: ” ORA-00822: MMAN process terminated with error “.

Solution on internet: warm start the instance. Yeah, that’s right … up again.

Cause ( Metalink): looks like a BUG !

Note 749524.1 looks very much alike, only the ” [_IO_vfprintf_internal()+1″  – part of the call stack doesn’t fit:

” The issue has been identified in unpublished Bug 7039896

Processes may wait for the “shared pool” latch for a long time when sga_target or memory_target is being used.
The stack trace for the process holding the latch has the function “kghquiesce_regular_extent” in it and appears to be spinning (using CPU). Typically the latch holder will be the MMAN process.

Solution:

Unpublished Bug 7039896 is fixed in 10.2.0.5, 11.1.0.7 and 11.2 rel.
At the moment of writing this note 10.2.0.5 patchset is not available.  ”

So, to fix the issue:

1. check if it’s available on Metalink oneoff Patch 7039896 for your current release and platform.
There is a oneoff Patch 7039896 on 10.2.0.3 and 10.2.0.4 release for some platforms;

2. or apply 11.1.0.7 patchset where is included the fix;

3. or apply one of the following workaround:
– do not use SGA_TARGET / MEMORY_TARGET
– or set the parameter _enable_shared_pool_durations=false in the init.ora or spfile

Not completely sure if this is the bug, but the particular database is for development AND installed on a VM (ESX). Since the installation 6 months ago, nothing like this happened, so I’ll take my chances and wait for 10.2.0.5 or higher….

By |January 5th, 2009|Categories: Database|Tags: |0 Comments

WordPress-blog upgraded to 2.7

Not an oracle topic this time. Sorry ;-)

This blog is powered by WordPress, and I performed an upgrade to 2.7. and configured some plugins.
Prepared my upgrade, checked this site for example: http://lorelle.wordpress.com/2008/12/11/wordpress-27-upgrade-tips . So far the theory.

Here’s what I actually did:

By |January 5th, 2009|Categories: Wordpress||Comments Off