In MGMTDB, the user CHM’s password is expired.
select username, account_status, profile from dba_users where username=‘CHM’;
USERNAME ACCOUNT_STATUS PROFILE
-------------------- ------------------- ------------
CHM EXPIRED(GRACE) DEFAULT
select * from dba_profiles where profile=‘DEFAULT’ and resource_name=‘PASSWORD_LIFE_TIME’;
PROFILE RESOURCE_NAME RESOURCE LIMIT COM
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 NO
The user CHM’s password is expired after 180 day from DB creation. This causes the user account is locked and connection can not be made through.
Please use the following procedure to reset the CHM user password to its original value.
as grid user,
$ export ORACLE_HOME=<GRID_HOME>
$ export ORACLE_SID=-MGMTDB
$ sqlplus / as sysdba
SQL> select name, password from user$ where name=‘CHM’;
SQL> alter user CHM identified by values ‘
SQL> select username, account_status from dba_users where username=‘CHM’;
The following command can also be used to reset the password for all the MGMTDB database users
Starting 19c, Please use the below command to reset the password for all the MGMTDB database users
Execute as grid OS user:
It should show account_status as OPEN now and ORA-20 error should be stopped.
