ORA-28000-SYS Account Locked on standby
(Doc ID 2683849.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
SYS account status on standby is "LOCKED" and broker shows error
DGMGRL> show configuration
Configuration - dgconfig
Protection Mode: MaxPerformance
Members:
prod - Primary database
Error: ORA-16778: redo transport error for one or more members
standby - Physical standby database
Error: ORA-28000: the account is locked
Changes
sys password changed recently on primary but however passwordfile not copied to standby through redo changes and customer tried login to standby with old sys password caused SYS account locked on standby
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |