Oracle SOA- Weblogic Server Start Error- ORA-28001: the password has expired

Recently I have faced the issue of Weblogic server start error of my Oracle SOA/BPM environment. The Weblogic server says- 

==================================================
Weblogic Server Start Error:
Caused by: java.sql.SQLException: ORA-28001: the password has expired
==================================================

In my this post, I'll share the details how can you make your Weblogic  overcome this issue by manipulating the database. So let's get started-

Login to your SOA machine (My environment Oracle Linux, choose yours) using oracle user.
1. Go to DB home  bin directory- 

cd $ORACLE_HOME/bin

2. Connect to sqlplus with / sysdba privileges.
./sqlplus /nolog;
SQL>connect / as sysdba;

3. Now check the accounts belonging to SOA Server
SQL> select username from  dba_users where account_status='EXPIRED' and username like '%SOA_%';

Result looks like-
USERNAME
-------------------------------------------
SOA_IAU_APPEND
SOA_STB
SOA_UMS
SOA_MDS
SOA_SOAINFRA
SOA_IAU_VIEWER
SOA_OPSS

Now this indicates that all the user's belongs to SOA server have their account_status (means password) expired.

4. Let's reset their password
SQL>alter user SOA_IAU_APPEND identified by welcome1 ;
SQL>alter user SOA_STB identified by welcome1 ;
SQL>alter user SOA_UMS identified by welcome1 ;
SQL>alter user SOA_MDS identified by welcome1 ;
SQL>alter user SOA_SOAINFRA identified by welcome1 ;
SQL>alter user SOA_IAU_VIEWER identified by welcome1 ;
SQL>alter user SOA_OPSS identified by welcome1 ;

welcome1 is the password for users, please choose your secure password.

5. Now restart your weblogic start script startWeblogic.sh/startWeblogic.cmd . It should start normally as worked for me.