How to read DBF to Datatable

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