ORA-16797: database is not using a server parameter file
443968Mar 23 2010 — edited Mar 23 2010I can see logs are applying into standby database. But in the dataguard alter log generating the error ORA-16797: database is not using a server parameter file
Error message in dataguard log file
-----------------------------------
DG 2010-03-23-17:46:45 0 2 714415739 DMON: GET_DRC operation completed
DG 2010-03-23-17:46:45 1000000 3 714415740 DMON: GET_SITE: success. (len = 464)
DG 2010-03-23-17:46:45 1000000 3 714415740 DMON: GET_SITE operation completed
DG 2010-03-23-17:46:45 2000000 3 714415741 DMON: GET_SITE: success. (len = 481)
DG 2010-03-23-17:46:45 2000000 3 714415741 DMON: GET_SITE operation completed
DG 2010-03-23-17:46:45 0 2 714415742 DMON: CTL_GET_STATUS forwarded to site ANZPRD for processing
DG 2010-03-23-17:46:45 0 2 714415742 DMON: CTL_GET_STATUS operation completed
DG 2010-03-23-17:47:32 0 2 0 RSM0: HEALTH CHECK ERROR: ORA-16797: database is not using a server parameter file
DG 2010-03-23-17:47:32 0 2 704706097 Operation CTL_GET_STATUS cancelled during phase 1, error = ORA-16797
DG 2010-03-23-17:47:32 0 2 704706097 Operation CTL_GET_STATUS cancelled during phase 1, error = ORA-16797
QL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
2000 2
2060 1
steps I did
create spfile from pfie
shutdown
started with spifile
No luck. log apply started. but i can see same error in datagurd log file