ORA-1017 and ORA-16047 in Dataguard

Issue:

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

Troubleshooting:

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.

Solution:

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.

 

 

 

 

 

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s