ORA-16047 When Starting Active DG

This past night I have been activating an active dg. The issue is that it did not finish to start and at the beginning it gave the following error;

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

Looking more in detail at the specific trace file, the following message appears (this is an excerpt of the file);

2018-07-31 07:17:27.263: [ GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:471] Result: (7) CLSGPNP_IO. (:GPNP01002:)Failed to open wallet file. dir ‘peer’ in ‘/xxxx/xxxx/xxxx/xxxx/xxxx/xxxx/wallets/’, cannot check wallet home.
2018-07-31 07:17:27.263: [ GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:469] (:GPNP01002:)SlfFopen2
Internal Error Information:
Category: SLF_SYSTEM(-8)
Operation: lstat failed
Location: slsfopen3
Dep: 13
Dep Message: Permission denied

In this case the error is caused by the fact that the log_archive_config parameter is not configured. You can query the value of this parameter in the next way;

show parameter log_archive_config

And you can set it by use the next alter command;

alter system set LOG_ARCHIVE_CONFIG=’DG_CONFIG=(db,stbdb)’;







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