Database Software

Hi All ,
We have missed creating the password file before startup of instance in primary database. But we maintained same sys password for standby and primary. And we also created a password file for primary now. The database version is 10.2.0.1 and OS Solaris 10.



We are receiving the error

ORA-01017: invalid username/password; logon denied
Sun Apr 24 12:19:12 2011
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
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
------------------------------------------------------------
Sun Apr 24 12:19:12 2011
Errors in file /app/prim/oracle/admin/prim/bdump/prim_arc1_14898.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'stdby_prim'. Error is 16191.
Sun Apr 24 12:22:16 2011


1. Is it mandatory to create a passwordfile before startup of instance?
2. Is it necessary that both primary and standby both have a paaswordfile or just the password same?

Will this require a primary database restart?

Thanks

Edited by: sunsantho on Apr 23, 2011 7:36 PM