Today we are going have look at changing the password of SYS in the Data Guard environment. Normally we have seen how to change the password of the normal user. That seems a game of kids,  Now we must learn new things in Oracle RDBMS. Let’s have look at the steps we use to change the password of SYS.

Option 1: Normal case we have to change the password once but in  “Data Guard environment” here we have some different ways with more efforts must be changed. After changing the SYS password in primary database copy the password to all standby location. Let’s have look on

1. We change the sys password in the primary database

2. Now copy a password file from the primary database to all standby database

— Primary

— Alert log file in Primary

— Standby

— Primary

— Primary database alert log file

— Standby database — Copy Password file from primary to Standby

— change the password file name to orapw of standby

— Alert log in Primary Database

Option 2: In some cases for security reason we might need to change sys password many times in primary database but considering the number of Standby database it is tedious to copy a password file from primary to the standby database.

To consider this problem Oracle introduces a feature from 11.2.0.x or above Data Guard environment. Using REDO_TRANSPORT_USER parameter we have avoided copying the password file to the standby database after changing the SYS password. Here I have shown how to do that.

Steps:

1. Create a user with and grant sysoper privilege to that user, or you can grant sysoper privilege to an existing user

2. Change REDO_TRANSPORT_USER parameter in both primary and all standby database.

3. Copy the password file to all standby database

— Primary database

— Standby

— Now I have copied the password file from primary to standby database — Standby database

— change the password file name to orapw of standby

— Lets Test Now — Primary

— Standby

— Primary

— Standby

— Primary

– Alert log file in Primary Database

So you have seen here even I have to change the SYS password log shipping from primary to standby works well without any error. Now you will be able to change SYS password as many times you want without copying the password file to all standby database but note that if you change the password of the user (e.g REDOTRANS user here) using in REDO_TRANSPORT_USER parameter then you will need to copy the password file to every standby database. Thanks for giving your valuable time to add some gems to oracle treasure.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.