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
4152 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-28010: cannot expire external or global accounts

1 Answers

LPX-00276: bad HTTP/Mime header

1 Answers

NMP-00007: I/O failure

1 Answers

TNS-12664: Services required by server not available on the client

1 Answers

PCC-02368: An EXEC TOOLS host variable context name is not type char

1 Answers

NNO-00307: invalid server name "string"

1 Answers

ORA-38726: Flashback database logging is not on.

1 Answers

ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.

1 Answers

ORA-25229: error on transformation of message string string

1 Answers

ORA-16557: The database is already in use.

1 Answers

TNS-00543: internal error

1 Answers

ORA-07410: slpdtb: number too large for supplied buffer.

1 Answers

For more Oracle Errors Interview Questions Click Here