password file in data guard envinormrnt
Hi
Using oracle rdbms 11.2.0.2 on RHEL 5.6.
We have 4 node primary and 4 node physical standby databases. All of the nodes have password file in place and remote_login_passwordfile set to EXCLUSIVE. In all the password files sys password is the same. We have only one user sys entry in passwordfile, since no other users has sysdba privileges.
We could observe at the standby site that only node 1 is shipping redo logs. I viewed the alert logs of node2,3,4. It says :
Error 1017 received logging on to the standby
------------------------------------------------------------
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
------------------------------------------------------------
Do the password file should be same across all the nodes or just the sys password. What i did is copied password file from node 1 to all the nodes in standby.