12c RAC Data Guard DGMGRL: show configuration failed with Error: ORA-01017: invalid username/password

_____________________________________________________________________________________________________________________

Error Description

In 12c RAC database Data guard broker show configuration command failed with Error: ORA-01017: invalid username/password

Solution Description

If you have configured the primary database with DBCA the password file will be stored in the ASM file system. Suppose if you have setup manually your password file in $ORACLE_HOME/dbs directory then the data guard file shipping will work as expected properly. But, when it comes to the DG broker setup it will give the ORA-01017 error message. You can check the password file location using srvctl config database -d dbname|grep Password in primary database.

To fix this issue you have to setup or create the password file in both (primary & standby) ASM locations with the same command and password. Once you create the password file in ASM locations the node instances will pick up it from the ASM location.

Syntax: orapwd file='+DATA/GNLPROD/PASSWORD/orapwgnlprod' password=sayrate1 force=y ignorecase=y entries=5 dbuniquename=GNLPROD

DGMGRL> show configuration;

Configuration - DG_Conf

  Protection Mode: MaxPerformance

  Members:

  GNLPROD     - Primary database

    Error: ORA-01017: invalid username/password; logon denied

    GNLPRODSTBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

ERROR   (status updated 0 seconds ago)

Solution:

orapwd file='+DATA/GNLPROD/PASSWORD/orapwgnlprod' password=sayrate1 force=y ignorecase=y entries=5 dbuniquename=GNLPROD

orapwd file='+DATA/GNLPRODSTBY/PASSWORD/orapwgnlprodstby' password=sayrate1 force=y ignorecase=y entries=5 dbuniquename=GNLPRODSTBY

_____________________________________________________________________________________________________________________