ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE

ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf
does not exist

Question Posted / guest

1 Answers
4287 Views
I also Faced
E-Mail Answers

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-25291: Buffer does not exist for the specified queue

1 Answers

ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.

1 Answers

ORA-00338: log string of thread string is more recent than controlfile

1 Answers

NNL-01071: Command-line parameter file name: string

1 Answers

ORA-01243: system tablespace file suffered media failure

1 Answers

ORA-01204: file number is string rather than string - wrong file

1 Answers

PLS-00250: Incorrect Usage of string in parameters clause.

1 Answers

ORA-09976: skxfqdini: Error Creating Port

1 Answers

ORA-23422: Oracle Server could not generate an unused job number

1 Answers

ORA-27191: sbtinfo2 returned error

1 Answers

ORA-22324: altered type has compilation errors

1 Answers

ORA-30381: REWRITE_TABLE is not compatible with Oracle version

1 Answers

For more Oracle Errors Interview Questions Click Here