Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-16797: database is not using a server parameter file

443968Mar 23 2010 — edited Mar 23 2010
I 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
This post has been answered by damorgan on Mar 23 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2010
Added on Mar 23 2010
4 comments
9,190 views