If the E1local database password has expired, you can reset the password using SQL.
First, edit the sqlnet.ora file from the E1Local installation so that NTS authentication is used (back this file up or remember the original settings):
SQLNET.AUTHENTICATION_SERVICES=(NTS)
Then restart the E1Local DB service.
Using a command line (make sure you have administrator privileges) enter SQLPlus:
sqlplus / as sysdba
Check the expiration date of the accounts using these commands:
SQL>set linesize 200;
SQL>select username, account_status, expiry_date, lock_date from dba_users;
Check to see if there is a limit in the profile value for PASSWORD_LIFE_TIME:
SQL>select * from DBA_PROFILES where PROFILE='DEFAULT';
Change the profile value to unlimited:
SQL>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Check to see if the changes have been made with the previous command:
SQL>select username, account_status, expiry_date, lock_date from dba_users;
Change the sqlnet.ora file back to it's original state.
Restart the E1Local DB service again.
