How To Remove Account Locked Warning Messages.

If you see messages like these while starting the server:

<Apr 3, 2011 2:05:16 AM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-SpacesDS": ORA-28000: the account is locked>

<Apr 3, 2011 2:05:17 AM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-SpacesDS": ORA-28000: the account is locked>

<Apr 3, 2011 2:05:18 AM IST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-SpacesDS": ORA-28000: the account is locked>

Than what you need to do to avoid them is :

1. Open Admin Console
2. Go to JDBC Data Sources
3. Select mds-SpacesDS data source name.
4. Go to the Connection Pool tab and from the properties section, fetch user value, example as shown below:

user=DEV_MDS

oracle.net.CONNECT_TIMEOUT=10000

abandonedConnectionTimeout=600

sendStreamAsBlob=true

Here, the user DEV_MDS is locked.

Connect to database as sys user and run the following command:

ALTER USER DEV_MDS ACCOUNT UNLOCK;

That's it.