ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf
does not exist



ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist..

Answer / guest

Cause: file does not exist or is not accessible

Action: Restart the instance to create the SGA definition file.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12436: document table allocation failed

1 Answers  


ORA-02210: no options specified for ALTER TABLE

1 Answers  


ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

1 Answers  


ORA-32833: failure string trying to release administration lock

1 Answers  


ORA-07801: slbtpd: invalid exponent

1 Answers  






SQL*Loader-00266: Unable to locate character set handle for string.

1 Answers  


EXP-00040: Dump file and log file must be different

1 Answers  


PLS-00701: illegal ORACLE error number string for PRAGMA EXCEPTION_INIT

2 Answers  


ORA-06778: TLI Driver: error sending ccode

1 Answers  


PCC-00096: Array FETCH not allowed for mode=ANSI14

1 Answers  


ORA-00096: invalid value string for parameter string, must be from among string

1 Answers  


RMAN-07513: List of Files Which Where Not Cataloged

1 Answers  


Categories