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-27012: skgfrd: read from file failed

1 Answers  


ORA-01522: file 'string' to be renamed does not exist

1 Answers  


TNS-00225: Unable to bequeath connection to pump

1 Answers  


ORA-29388: plan/consumer_group string is part of more than one top-plan

1 Answers  


NID-00331: The following datafiles are disabled:

1 Answers  






ORA-38741: Formatted blocks value string is not valid.

1 Answers  


QSM-02088: mv omits at least one grouping key from the select list

1 Answers  


DRG-10753: invalid memory size string string

1 Answers  


ORA-16624: broker protocol version mismatch detected

1 Answers  


ORA-07474: snclrd: close error, unable to close sgadef.dbf file.

1 Answers  


ORA-13831: SQL profile name specified is invalid

1 Answers  


LSX-00166: both content types must be mixed or both must be element-only

1 Answers  


Categories