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
4141 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

LCD-00208: unexpected keyword in value list [string]

1 Answers

ORA-36970: (XSRELTBL12) workspace object must be a self-relation.

1 Answers

DRG-13301: syntax error in token data when expecting string, at line string

1 Answers

ORA-01509: specified name 'string' does not match actual 'string'

1 Answers

ORA-16055: FAL request rejected

2 Answers

ORA-15105: missing or invalid FAILGROUP name

1 Answers

ORA-24099: operation not allowed for 8.0 compatible queues

1 Answers

DRG-13000: error while adding or removing a sub lexer

1 Answers

ORA-32321: REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE

1 Answers

ORA-13767: End snapshot ID must be greater than or equal to begin snapsho ID.

1 Answers

QSM-02081: mv log does not have all necessary columns

1 Answers

RMAN-08110: failover to next copy of backuppiece

1 Answers

For more Oracle Errors Interview Questions Click Here