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
4211 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-01501: CREATE DATABASE failed

1 Answers

ORA-01143: cannot disable media recovery - file string needs media recovery

1 Answers

ORA-24046: protocol attribute reserved for future use

1 Answers

LPX-00413: loss of precision due to excessively large numerical constant

1 Answers

SQL*Loader-00523: error number writing to file (string)

1 Answers

DRG-11838: Proxy Reauthentication Required

1 Answers

ORA-30040: Undo tablespace is offline

1 Answers

TNS-12201: TNS:encountered too small a connection buffer

1 Answers

RMAN-06482: WARNING: proxy copy 'string' cannot be found on the storage medium

1 Answers

PCC-02407: Object and REF types do not match

1 Answers

RMAN-06734: Do you really want to drop all backups and the database (enter YES or NO)?

1 Answers

TNS-01053: Connecting to string

1 Answers

For more Oracle Errors Interview Questions Click Here