Saturday, October 29, 2011

ORA-01017 SYS Password problem in the Data Guard environment


While performing the switchover & failover using the DG broker. DG broker reported the below error message in the log file.

Error message

Connection to database BHU_A returns ORA-01017.
NSV0: Failed to connect to remote database BHU_A. Error is ORA-01017
NSV0: Failed to send message to site BHU_A. Error code is ORA-01017.
DMON: failed to forward op EDIT_RES_PROP to site BHU_A with error ORA-01017
DMON: Database BHU_A returned ORA-01017
Connection to database BHU_A returns ORA-01017.
Please check database BHU_A is using a remote password file

When have a two node RAC setup as a primary DB and two node RAC setup as standby database. We have enable data Guard broker configuration for this environment.


When we change the sys password in the primary database using the alter system command, it updates the password file in the ORACLE_HOME of the primary database, it doesn’t update password file in the standby database.

SQL> alter user sys identified by oracle12$;

SOLUTION รจ Changing SYS Password in the Data Guard environment

While changing the sys password in the Primary database. You have manually copy the password file to the standby database. If it is RAC environment, then make sure that you place the file in both the ORACLE_HOME.

In Oracle 11g, Oracle has come up with case-sensitive option. It means passwords are case-sensitive. It is dynamic parameter and it change modified easily. this function available from oracle 11gR1 onwards.

SQL> show parameter case_sensitive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE

SQL> alter system set sec_case_sensitive_logon=FALSE scope=both sid='*';

System altered.

No comments:

Post a Comment