[Oracle Active DataGuard 12.1 Installation on Centos 6.7]: Copying password file from primary to standby
On Primary
Passwordfile
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SYSDG FALSE FALSE FALSE FALSE TRUE FALSE 0
SYSBACKUP FALSE FALSE FALSE TRUE FALSE FALSE 0
SYSKM FALSE FALSE FALSE FALSE FALSE TRUE 0
$ chmod 4640 $ORACLE_HOME/dbs/orapw${ORACLE_SID}
// The password file can be created with the following command. Entries - limits the maximum number of connections to the database (if I’m not mistaken). I did not create a new password file.
$ orapwd fiel=$ORACLE_HOME/dbs/orapw${ORACLE_SID} password=oracle12 entries=5
Copying the password file
$ scp $ORACLE_HOME/dbs/orapw${ORACLE_SID} oracle12@piter:$ORACLE_HOME/dbs/
Standby
$ chmod 4640 $ORACLE_HOME/dbs/orapw${ORACLE_SID}