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
4291 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-00602: internal programming exception

1 Answers

NZE-29011: Finished message is incorrect.

1 Answers

DRG-50855: logoff fail

1 Answers

NNL-00954: Hash tables created: number

1 Answers

QSM-01079: DML operation occurred on a table referenced by MV, string

1 Answers

ORA-33214: (CINSERT02) The workspace object dimension is too large.

1 Answers

NNO-00603: enabling all request processing

1 Answers

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

1 Answers

ORA-39316: illegal clean_up() call: last clone operation is failed

1 Answers

ORA-12615: TNS:preempt error

1 Answers

ORA-06303: IPA: Message send error

1 Answers

ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.

1 Answers

For more Oracle Errors Interview Questions Click Here