I've implemented Oracle Data Guard remote physical standby database. One of my colleagues changed the sys password for the Primary Database, then the connection between the Primary Database and Remote Standby Database lost.
For the process of handling this issue, I removed the Data Guard configuration:
DGMGRL> remove configuration;
Removed configuration
Re-created the configuration again:
C:\Users\Administrator>dgmgrl sys/**********@orcl
DGMGRL for 64-bit Windows: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS orcl CONNECT IDENTIFIER IS orcl;
Configuration "my_dg_config" created with primary database "orcl"
Tried to add standby database to the configuration
DGMGRL> ADD DATABASE orcl_stby AS CONNECT IDENTIFIER IS orcl_stby MAINTAINED AS PHYSICAL;
Error: ORA-01017: invalid username/password; logon denied
Created password file in the primary database with the same password for sys in (Primary Db), copied it to Standby Server and tried to add standby database to the configuration again:
DGMGRL> ADD DATABASE orcl_stby AS CONNECT IDENTIFIER IS orcl_stby MAINTAINED AS PHYSICAL;
Error: ORA-01017: invalid username/password; logon denied
Now the two databases (Primary & Standby) passwords are the same, still the error persists, any other workaround or solution to this problem?
I'm using Oracle database 11g (Version 11.2.0.4.0)
I appreciate your help guys!