ORA-16797: SPFILE is missing in the Data Guard broker
environment



ORA-16797: SPFILE is missing in the Data Guard broker environment..

Answer / guest

Cause: SPFILE (server parameter file) is not being used in
the database, or the resource guard failed to retrieve the
status of the SPFILE.

Action: Issue "CREATE SPFILE='..' FROM PFILE='...'" command
to create an SPFILE, and restart the database to use the SPFILE.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28668: cannot reference mapping table of an index-organized table

1 Answers  


HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G, WIN XP OS. PLS HELP ME TO SOLVE THIS PROBLEM. AM NEW TO DBA ACTIVITIES

1 Answers  


ORA-10663: Object has rowid based materialized views

1 Answers  


ORA-06560: pos, string, is negative or larger than the buffer size, string

1 Answers  


RMAN-06710: script string not found in catalog

1 Answers  






ORA-10662: Segment has long columns

1 Answers  


ORA-16168: LGWR network server could not switch to blocking mode

1 Answers  


RMAN-05004: target database log mode is NOARCHIVELOG

1 Answers  


DRG-11512: bad syntax for thesaurus load file at line string

1 Answers  


ORA-31417: column list contains control column string

1 Answers  


QSM-01522: a more optimal equivlanece than string was used to rewrite

1 Answers  


PLS-01702: Illegal syntax in COMMIT WORK statement

1 Answers  


Categories