Re: Help with sgadef file problem

Verify that:

   o 'sgadef<SID>.dbf' was created
   o ORACLE_SID is set correctly
   o dbs directory is writable by the Oracle user    o number of files that can be created/opened is high enough    o database being started is not already up

1. When a database is started, it tries to create the file sgadef<SID>.dbf in the directory $ORACLE_HOME/dbs using the values of the environment variables ORACLE_HOME and ORACLE_SID.

    For example setting:

        ORACLE_HOME=/usr/product/714
        ORACLE_SID=PROD

    and running:

        SQLDBA> startup

    should create the file:

        /usr/product/714/PROD/dbs/sgadefPROD.dbf

2. If your sgadef.dbf file as not created, verify that:

% echo $ORACLE_SID

    returns the correct value.

3. If your sgadef.dbf file was not created, check the directory

    permissions on 'dbs'. Type:

% cd $ORACLE_HOME
% ls -l dbs

    It should show these permissions and ownerships:

        drwxr-xr-x 6 oracle dba 1024 Feb 22 06:04 dbs/

4. If the file already exists remove it like this:

% rm /usr/product/714/PROD/dbs/sgadefPROD.dbf

    and run 'startup' against the database again.

    When a 'shutdown' command is run it deletes the sgadef<SID>.ora     file, however if there was an abnormal termination of the oracle     database the file may not have been removed.

5. You may also have to check your general Oracle permissions.

        chgrp -R dba *

    From $ORACLE_HOME

        chmod 2755 *

    From $ORACLE_HOME/bin

        chmod 755 *

    From $ORACLE_HOME/bin

        chmod 6755 oracle

6 The number of files which can be created/opened is a UNIX kernel

    parameter. The name of this parameter and the value it should be set to     are dependent on the kind of operating system being used (examples include

    NFILE, NOFILE, MAXFILES and so on). Consult your OS documentation for     more information. Received on Thu Nov 19 1998 - 00:00:00 CST