Dec 19, 2017
ORA-16057: server not in Data Guard configuration
1.3K

ORA-16057: server not in Data Guard configuration

Error:  ORA-16057: server not in Data Guard configuration Solution:  Make sure your log_archive_config and log_archive_dest_2 parameters are set on both Primary and Standby Databases. In my case: alter system set log_archive_config=’dg_config=(PROD,PROD_stby)’; alter system set log_archive_dest_2=’service=PROD_stby lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=PROD_stby’;
Dec 13, 2017
ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
1.3K

ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

Issue:  Unable to change DB_UNIQUE_NAME after failover from PRIMARY TO STANDBY SQL> alter system set db_unique_name=MWMPPROD scope=spfile; alter system set db_unique_name=MWMPPROD scope=spfile * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-65500: could not modify DB_UNIQUE_NAME, resource exists Solution: We need to switch back to PRIMARY instead of making a...
Dec 13, 2017
OPW-00019: Failed to update the CRS resource with DB password file location
1.5K

OPW-00019: Failed to update the CRS resource with DB password file location

Error:  I was facing below error while creating password file on standby side as part of Oracle Data Guard (standby) Configuration [oracle@app admin]$ orapwd file=’+DATA1/orapwdb/orapwPROD’ password=PwdFile force=y dbuniquename=PROD_stby OPW-00019: Failed to update the CRS resource with DB password file location Solution: There seems to be a bug in 12.1.0.2.  As...
Dec 13, 2017
ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
1.3K

ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Error:   While registering Primary and Standby with Data Guard Broker: DGMGRL> CREATE CONFIGURATION ‘my_dg_conf’ AS PRIMARY DATABASE IS ‘SOAPROD’ CONNECT IDENTIFIER IS ‘SOAPROD’; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Failed. Solution:  Update LOG_ARCHIVE_DEST_2 with no value and try creating data guard configuration. SQL> show parameter LOG_ARCHIVE_DEST_2 NAME                                 TYPE       ...