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';