Oracle: Reactivate a database user

By | November 14, 2016

I am always very annoyed when my Oracle user is automatically expired and locked. This is done automatically at 180 days in some installations.

The following are some very easy steps for a question that everybody is asking again and again on forums.

STEP 1: Connect to the DB

STEP 2: Update the password

STEP 3: Unlock user