Oracle_ADG_备库业务用户锁定，dba_users的account_status为OPEN问题分析

Oracle_ADG_备库业务用户账户锁定，dba_users的account_status 为”OPEN“

背景

​ 业务反馈连接ADG备库报错ORA-28000，登录主备库查看dba_users的account_status ,状态均为”OPEN“，主库登录正常，备库登录报错ORA-28000。

说明

V$RO_USER_ACCOUNT视图用于跟踪动态用户尝试登录失败次数的信息。该特性只对备库有效，如果该用户在备库由于登录失败次数超过PROFILE的限制而锁定。那么不会影响主库该用户的使用

验证

一、实现环境：

数据库：11g+ADG
系统：UNIX
补丁：PSU 31103343
注：主备时间不一致，不影响测试，请忽略

二、新建测试用户

create user hhht identified by Hhhht_2024;
grant connect,resource to hhht;

三、主备库检查用户状态

1）主库

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 1 15:45:47 2024

Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select a.DATABASE_ROLE,a.PROTECTION_MODE,a.PROTECTION_LEVEL,a.OPEN_MODE from v$database a ; 

DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL     OPEN_MODE
---------------- -------------------- -------------------- --------------------
PRIMARY          MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  READ WRITE
15:46:34 SQL> select username,account_status,profile from dba_users where username='HHHT';

USERNAME        ACCOUNT_STATUS   PROFILE
--------- 		--------------   ---------
HHHT             OPEN			  DEFAULT
15:47:38 SQL> select * from dba_profiles where profile='DEFAULT';
DEFAULT                        COMPOSITE_LIMIT                  KERNEL   UNLIMITED
DEFAULT                        SESSIONS_PER_USER                KERNEL   UNLIMITED
DEFAULT                        CPU_PER_SESSION                  KERNEL   UNLIMITED
DEFAULT                        CPU_PER_CALL                     KERNEL   UNLIMITED
DEFAULT                        LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED
DEFAULT