Re: Database startup

Hy,
I have had a look at the sgadeSID.dbf file on my system (Oracle 8.0.5 on Sun Solaris 2.6)
This was the result: (contents of file)

This file is now obsolete. It will be removed in a future release. To determine whether an instance is up, you should check for the existence of the PMON process associated with the instance.

I'm shure that the PMON process will die, if you reboot the system after the system
has been crached. So what do I have to do in this case?

Peter

Stephane Faroult wrote:

> This is a message issued by the dbstart script (you can have a look at
> it, under the usual $ORACLE_HOME/bin). This message is displayed when it
> finds under $ORACLE_HOME/dbs a file named sgadef${ORACLE_SID}.dbf. The
> sgadef file is created when the instance is started and contains
> information related to the SGA (if you have some knowledge of Unix
> system calls, the shared memory identifier returned by the initial
> shmget() call is stored there, among other things, which allow the
> shadow processes to call shmat() with the correct identifier). When the
> shared memory area is deallocated (ie at shutdown) this file is also
> removed; hence Oracle's (correct) message. All you have to do is to
> remove this file (perhaps you should check shared memory too - ipcrm may
> be required), and run dbstart again. Oracle will use the (then current)
> redo log file to rebuild what needs to be rebuilt in the datafiles, and
> no transaction should be lost. It's just a warning message, nothing to
> be scared of.
>
> --
> Regards,
>
> Stéphane Faroult
> Oriole Corporation
> ------------------------------------------------------------------
> http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
> ------------------------------------------------------------------
Received on Fri Apr 23 1999 - 02:25:28 CDT