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-01584: unable to get file size of controlfile to be backed up

1 Answers  


SQL*Loader-00477: REF directive for field string requires at least two arguments

1 Answers  


NNO-00617: enabling AUTHORITY-REQUIRED on system queries

1 Answers  


DRG-10833: feedback failed

1 Answers  


ORA-07284: sksaprd: volume size specification not terminated properly.

1 Answers  


ORA-02830: Segment could not be split - no free segments available

1 Answers  


ORA-02247: no option specified for ALTER SESSION

1 Answers  


ORA-01865: not a valid era

1 Answers  


PCC-00083: Bind and define variables not allowed in CREATE statement

1 Answers  


IMG-02006: 2FF06 - average color feature cannot be determined

1 Answers  


DRG-10826: no document with the specified textkey is found

1 Answers  


ORA-26523: rpc termination error

1 Answers  


Categories