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

ORA-15046: ASM file name 'string' is not in single-file creation form

1 Answers  


ORA-38426: attribute set assigned to an expression set may not be dropped

1 Answers  


KUP-11006: file truncated error in string

1 Answers  


ORA-12021: materialized view "string"."string" is corrupt

1 Answers  


ORA-07599: spwat: $SCHDWK failure

1 Answers  






ORA-19361: ONLINE option not allowed with this type of index

1 Answers  


RMAN-08020: including standby controlfile in backupset

1 Answers  


DRG-11513: unable to open or write to file string

1 Answers  


DRG-12307: column string is NULL and cannot be indexed

1 Answers  


PCC-02104: Unable to connect to Oracle

1 Answers  


ORA-07650: sigunc: $GETJPIW failure

1 Answers  


LFI-00116: Unable to close file in operation string.

1 Answers  


Categories