MDS-01376: Unable to get database connection from data source >Could not create pool connection for datasource ''. The DBMS driver exception was: ORA-28001: the password has expired

 MDS-01377: Unable to get database connection from data source configured with JNDI name "jdbc/mds/owsm" When Starting OBIEE 11g (Doc ID 1561628.1)

How To Handle ORA-28001: the password has expired When Starting OSM WebLogic Server (Doc ID 1273924.1)

select USERNAME,ACCOUNT_STATUS,LOCK_DATE,EXPIRY_DATE,PROFILE from dba_users where ACCOUNT_STATUS in ('LOCKED','EXPIRED','LOCKED and EXPIRED');

SELECT 'ALTER USER '|| name ||' IDENTIFIED BY VALUES '''|| spare4 ||';'|| password ||''';' FROM sys.user$ WHERE name='MAN';

select 'ALTER USER ' || username || ' identified by <password>;'  from dba_users where account_status like 'EXPIRED%' and username != 'MAN';

select 'ALTER USER ' || username || ' account unlock;' from dba_users where  account_status like 'LOCKED%' and username != 'MAN';