The following is the ORA-16797 error message, you can learn the cause and solution of the Oracle database error.


ORA-16797 SPFILE is missing in the Data Guard Broker environment

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

Solution: Issue a CREATE SPFILE='...' FROM PFILE='...' statement to create an SPFILE, and restart the database to use the SPFILE.

Case:

Please wait for the update…