ORA-08207: ora_addr: cannot open address file



ORA-08207: ora_addr: cannot open address file..

Answer / guest

Cause: The address file could not be opened.

Action: Check that ORACLE is up. Check that the file
$(ORACLE_HOME)/dbs/sgadef$(ORACLE_SID).dbf exists and has
correct permissions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMG-00805: SIGNATURE data has been corrupted or is invalid

1 Answers  


ORA-16795: Database resource guard detects that database reinstantiation is required

1 Answers  


ORA-07629: smpall: $EXPREG failure

1 Answers  


ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.

1 Answers  


ORA-19751: could not create the change tracking file

1 Answers  


ORA-37116: OLAP API table function error: (string)

1 Answers  


ORA-02088: distributed database option not installed

1 Answers  


QSM-01041: materialized view, string, does not match with a measure in the query

1 Answers  


DRG-11516: user must be at least in role CTXUSER to perform this operation

1 Answers  


ORA-08003: sequence string.NEXTVAL exceeds internal limits

1 Answers  


DRG-12211: section or section id string does not exist

1 Answers  


ORA-13142: invalid PROXIMITY window definition

1 Answers  


Categories