Unlock E1 E900 demo client (OEE db based)

For your information, for those who has installed the Enterprise One E9 demo client. You would probably have encountered login problem after some long while use.  That is due to the user's account status has been expired and locked.

Below are the way to unlock the a/c :

1. Stop the 2  windows services called 'OracleServiceE1Local' and 'OracleE1LocalTNSListener'
2. Change the sqlnet.ora for the SQLNET.AUTHENTICATION_SERVICES=(NTS)
3. Start the 2 services.
4. Go to command prompt.

5.  Type :

 SQLplus / as sysdba;

alter profile default limit failed_login_attempts unlimited password_life_time unlimited;

* you may use SQL developer for Oracle - SQL worksheet to apply above command if you failed in sqlplus in dos command...

5. Change the sqlnet.ora back for the SQLNET.AUTHENTICATION_SERVICES=(NONE)
6. Restart the 2 services.