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

[paypal_donation_button]

Advertisements

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.