Re: Help with sgadef file problem

From: Yassir Khogaly <yassir_at_khogaly.freeserve.co.uk>
Date: 1998/11/19
Message-ID: <730kqv$dj8$1@newsreader1.core.theplanet.net>#1/1

When starting the database, the following errors occur:

        ORA-1031 "insufficient privileges"
        ORA-7318 "smsget: open error when opening sgadef.dbf file."

The results of an 'oerr ora 7318' has been provided below as additional information:

07318, 00000, "smsget: open error when opening sgadef.dbf file."

// *Cause:  Unable to open sgadef.dbf file.
// *Action: Check errno. Possible permission problem. Verify that
//          sgadef.dbf file exists.

+==+

Check $ORACLE_HOME/dbs for the presence of the sgadef<SID>.dbf file.

This file is normally deleted when the database is properly shutdown. If the database is not running, then this file should not exist, so you must delete the sgadef<SID>.dbf file from $ORACLE_HOME/dbs.

An example scenario where this can occur:

---

The Unix server crashed and so Oracle was not properly shut down. Now you cannot start the database after the Unix server was rebooted.

The environment variables for this instance are:

        ORACLE_SID prod
        ORACLE_HOME /apps/oracle

You should do the following to regain access to the database:

% cd $ORACLE_HOME/dbs
% ls sgaprod.dbf

        If the file exists, then delete it:


        % rm sgaprod.dbf

----------------------------------------------------------------------------

NOTE:
** Do not delete the sga<SID>.dbf file if the database instance is running *** Received on Thu Nov 19 1998 - 00:00:00 CST