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

ORA-12483: label not in OS system accreditation range

1 Answers  


ORA-24303: call not supported in non-deferred linkage

1 Answers  


ORA-02784: Invalid shared memory ID specified

1 Answers  


ORA-32614: illegal MODEL SELECT expression

1 Answers  


NID-00143: Mismatched controlfile string

1 Answers  


ORA-13828: generated SQL profile name string already exists

1 Answers  


ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management

2 Answers  


PLS-00904: insufficient privilege to access object string

1 Answers  


NID-00123: Magic number for datafile "string" is incorrect

1 Answers  


ORA-14194: only one subpartition may be rebuilt

1 Answers  


ORA-09847: soacon: ARCH unable to open named pipe.

1 Answers  


SQL*Loader-00420: unsupported datatype conversion requested for column string in table string

1 Answers  


Categories