Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

account locked in standby

JayeetaJan 13 2023

Trying to unlock in standby, gives the following error

alter user xxx account unlock
*
ERROR at line 1:
ORA-04088: error during execution of trigger 'SYS.GGS_DDL_TRIGGER_BEFORE'
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database or pluggable database open for read-only access
ORA-06512: at line 1308
ORA-16000: database or pluggable database open for read-only access
ORA-06512: at "GGUSER.DDLREPLICATION", line 1291
ORA-06512: at "GGUSER.DDLREPLICATION", line 3460
ORA-06512: at "GGUSER.DDLREPLICATION", line 3395
ORA-06512: at "GGUSER.DDLREPLICATION", line 1123
ORA-06512: at line 987
Please help to resolve this. Restart of standby is not an option at this point.

Thanks

Comments
Post Details
Added on Jan 13 2023
2 comments
938 views