If you change SYS password with ALTER USER SYS IDENTIFIED BY NEWPASSWORD on the primary database of a dataguard environment, primary side stops to transfer archivelogs to standby and you will see an error on primary database alertlog file like:

------------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------------

This is because "If you issue the ALTER USER statement to change the password for SYS, both the password stored in the data dictionary and the password stored in the password file are updated." So your password file is updated in primary side but not in standby side.

In this situation set your password file in standby server with:
orapwd file=$ORACLE_HOME/dbs/orapwSID password=newpassword; (don't forget to move/delete old one)

Conclusion: If you're going to change your sys password in a dataguard environment you must set the password files with new password in both primary and standby servers.

4 Responses so far.

  1. Anonymous says:

    good.

    But whats the purpose of this password file on standby ?

  2. Hi, to connect your standby database with sys user for administrative task, password file is used.

  3. For those of you who are purchasing Crystal Jewellery,we realize that this is one of the most important purchasing decisions you will make. You have made the best choice in choosing one of our Crystal Bracelets,Crystal Earrings or Crystal Necklaces, as they are constructed of the highest grade materials to ensure that your new Crystal Jewellery lasts forever. You can be confident in your purchase as each item comes with a no hassle 30 day return privilege.

  4. Anonymous says:

    Does this apply when we have different password set for sys and password file.

    What if Initially we have different password for sys and password files.

DOAG 2016

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -