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

RMAN-06144: FROM or UNTIL may not be specified with LIST INCARNATION

1 Answers  


NNO-00123: node "string" has no authoritative parent, data ignored

1 Answers  


NID-00505: REVERT Revert failed change NO

1 Answers  


NCR-00003: NCR: Initialization failure

1 Answers  


ORA-39146: schema "string" does not exist

1 Answers  


ORA-29377: consumer group string is not part of top-plan string

1 Answers  


EXP-00104: datatype (string) of column string in table string.string is not supported, table will not be exported

1 Answers  


ORA-01139: RESETLOGS option only valid after an incomplete database recovery

1 Answers  


NZE-28885: No certificate with the required key usage found.

1 Answers  


RMAN-06441: cannot upgrade catalog - catalog is already newer than this RMAN

1 Answers  


ORA-20000: %s

1 Answers  


ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


Categories