_____________________________________________________________________________________________________________________
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
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment