Change Sys Password

Change Sys password at primary and standby database (ADG) server:

+++++++++++++++++++++++++++++++++++++++++++++++++++++

step 1: cancel MRP process from standby database server

sql> alter database recover managed standby database cancel;

step 2: connect primary as 

sqlplus / as sysdba

sql> alter user sys identified by ISBySs#aDm1n$;

step 3: Rename the password file in standby database

cd $ORACLE_HOME/dbs

[oracle@test_db dbs]$ mv orapwSID orapwSID.back

step 4: send the password file to standby site

[oracle@test_db dbs]$ scp orapwSID oracle@192.168.4.44:$ORACLE_HOME/dbs/

step 5: apply MRP at primary database server

sql> alter database recover managed standby database disconnect from session nodelay;