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.
good.
But whats the purpose of this password file on standby ?
Hi, to connect your standby database with sys user for administrative task, password file is used.
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.
Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
Oracle Fusion Financials Online Training
A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Really very helpful article , Thank you for sharing we have learned so much information from your blog
Big Data and Hadoop Online Training
Big Data Hadoop Training
Hyderabad
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.
Spark and Scala Online Training
Spark Scala Training
Hyderabad