ORA-1017 and ORA-16047 in Dataguard


Primary not able to connect to standby database, no RFS process started on standby database.

Alert log on primary has ORA 1017 errors and trace file has ORA-16047

ORA-16047: DGID mismatch between destination setting and target database


Recreated the password file on primary and copied to standby database, but still primary LNS not able to communicate to RFS on standby

select process, status from v$managed_standby;  — RFS not started on DR database

I am able to connect to standby database using sqlplus with the recreated password file.


LOG_ARCHIVE_CONFIG parameter is missing from standby database , though password file is fine , primary not able to authenticate the DR DB unique_name as the LOG_ARCHIVE_CONFIG is missing.

alter system set log_archive_config=’DG_CONFIG=(primary,DR)’ scope=both

Above parameter setting resolved the issue.







Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s