ORA-16797: SPFILE is missing in the Data Guard broker
environment
- 1 Answers
- 13810 Views
- I also Faced
- E-Mail Answers
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 |
ORA-32301: object-relational materialized views must be primary key based
ORA-16757: Resource guard could not get property
QSM-01063: query has a dictionary table or view
TNS-00108: TNS_ADMIN not defined
ORA-16609: one or more resources have failed
ORA-40108: input data contains too few distinct target (string) values
PLS-00994: Cursor Variables cannot be declared as part of a package
ORA-12019: master table is a synonym to a remote object
PCC-02101: Unable to open input file
ORA-37013: (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
ORA-36774: (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
ORA-24055: cannot delete propagation status rows that are in prepared state
Oracle Errors 
