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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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)
advertisements
 
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

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (578) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer