Recursive Login Error (ORA-604) during Password Grace Period
876213Apr 20 2012 — edited May 22 2012When a password on the primary database is in its' expiration grace period, a subsequent login to the physical standby database generates a recursive read-only error (ORA-00604). The physical standby database is opened read-only and passwords cannot be changed. The login to the primary database does not encounter this login error, only a warning, during the same grace period. In contrast, the physical standby database login is unable to proceed during the grace period. Why is standby prohibiting logins during the primary grace period? What is the recommended workaround?