OleDbConnection oConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Temp;Extended Properties=dBase III");
OleDbCommand command = new OleDbCommand("SELECT * FROM Test.DBF", oConn);
oConn.Open();
DataTable dt = new DataTable();
dt.Load(command.ExecuteReader());
oConn.Close();
ORA-28001: The password has expired
The password life of the applications as well as operating systems are limited. To enabling more security we are getting some alert in daily life that we need to chage our passwords regularly on fixed inerval.
If we don’t change before the applications limitation, it will expired.
The other day when I was opening SQL Developer, I got message popup “ORA-28001: The password has expired”.
To fix this issue we need to connect Oracle with SYSDBA OR SYSTEM user and do the following things.
STEP 1: Check the users status.
SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS; USERNAME ACCOUNT_STATUS ----------------------------------------------- ANONYMOUS OPEN SYSTEM OPEN SYS OPEN LMENARIA EXPIRED & LOCKED
STEP 2: Set the password of locked user.
ALTER USER LMENARIA IDENTIFIED BY pa55word;
STEP 3: Unlock the user account.
ALTER USER LMENARIA ACCOUNT UNLOCK;
STEP 4: Check the user status again is not locked anymore.
SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS; USERNAME ACCOUNT_STATUS ----------------------------------------- ANONYMOUS OPEN SYSTEM OPEN SYS OPEN LMENARIA OPEN