Re: unable to recover a crashed 8.1.5. database

From: Gordon Cartwright <gordon_cartwright_at_yahoo.co.uk>
Date: Wed, 07 Feb 2001 07:42:13 +0000
Message-ID: <3A80FC56.CE3E932D@yahoo.co.uk>

A SHMMAX of 8Mb looks way too small for a normal database. It's an upper limit, so why did you reduce it? I would guess that Oracle couldn't
allocate its SGA. You didn't say how much memory you were requesting in the init.ora. Presumably it was > 8Mb?

I would suggest you put the SHMMAX limit back to 2Gb and review your init.ora settings.

Henk Streunding wrote:

> hello,
>
> is there anyone who has the same expierence:
>
> Installed Oracle 8.1.5 on Dig. Unix 5.1 on a GS320 server from Compaq.
> Installation notes from Oracle says SHMMAX parameter from 2GB to 8Mb.
>
> Running the database and let it crash, system reboot.
> After reboot, starting database wil not open and mentioned an ora600 error.
> No recovery possible.
> SHMMAX parameter was set at 8Mb.
> Altered the parameter in 16Mb.
> Rebooted the system and started the database.
> At this point the database was recovered and running smoothly.
>
> Has anyone the same expirience ? It was'nt as Oracle said according to the
> installation manual.
>
> Thank you
Received on Wed Feb 07 2001 - 01:42:13 CST