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.

11 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.

  5. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

  6. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  7. Santhosh says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion SCM Online Training

  8. harsha says:

    Really thanks for sharing such a wonderful blog.
    Oracle Fusion Financials Online Training

  9. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  10. Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion SCM Online Training

  11. Awesome post. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion Financials Online Training

Powered by Blogger.

Page Views

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