Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database startup
Fred ROBIN wrote:
>
> I have a problem with Oracle8 on Aix
> On startup :
> Database "PAT" possibly left running when system went down (system
> crash?).
> Notify Database Administrator.
> Database "PAT" NOT started.
> Effectively a crah occured.
> Any idea for startup this database correctly?
>
> Thanks
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