当前有个库，之前是某个库的dg备库；现在是把这个库dg停掉（与主库断开）单独拿出来做debug查询用，测试反映使用pl/sql连接报错ORA-28000: the account is locked

当前数据库状态如下：

SQL> select DATABASE_ROLE,OPEN_MODE from v$database;

DATABASE_ROLE    OPEN_MODE

---------------- --------------------

PHYSICAL STANDBY READ ONLY

随后我的操作如下：

SQL> show user

USER is "SYS"

SQL> conn YIBT_PRD/yibt_prd1234

ERROR:

ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

SQL> conn / as sysdba

Connected.

SQL> select username,account_status from dba_users where username='YIBT_PRD';

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------

YIBT_PRD                       OPEN

SQL> alter user YIBT_PRD account unlock;

User altered.

SQL> conn YIBT_PRD/yibt_prd1234

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

profile设置了：

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT

DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD 30

麻烦老师看看是啥问题。谢谢