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
4292 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-12845: failed to receive interinstance parallel execution message

1 Answers

ORA-00127: dispatcher string does not exist

1 Answers

RMAN-08066: database reset to incarnation string

1 Answers

ORA-27485: argument string already exists at a different position

1 Answers

ORA-29263: HTTP protocol error

1 Answers

ORA-06018: NETASY: message send failure

1 Answers

PCB-00106: Unable to open INCLUDE file "string"

1 Answers

ORA-01214: MAXLOGHISTORY may not exceed string

1 Answers

NNL-00899: OK responses sent: number

1 Answers

ORA-14318: DEFAULT partition must be last partition specified

1 Answers

DRG-50608: unexpected end of data

1 Answers

ORA-27470: failed to re-enable "string.string" after making requested change

1 Answers

For more Oracle Errors Interview Questions Click Here