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-32585: duplicate specification of a supplemental log attribute

1 Answers  


DRG-50607: failed to obtain column info for cid string

1 Answers  


RMAN-06194: target database instance not started

1 Answers  


ORA-25441: duplicate column value for table alias: string

1 Answers  


ORA-31441: table is not a change table

1 Answers  






ORA-27015: skgfcls: failed to close the file

1 Answers  


ORA-03214: File Size specified is smaller than minimum required

1 Answers  


ORA-29276: transfer timeout

1 Answers  


LPX-00275: can't set output/data encoding AFTER parsing

1 Answers  


PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


ORA-22903: MULTISET expression not allowed

1 Answers  


IMP-00016: required character set conversion (type number to number) not supported

1 Answers  


Categories