How do I unlock the Oracle database user account?

Purpose

Perform this procedure to unlock the locked Oracle database user account.

How do I configure the Oracle database user lockout threshold? describes how to configure the account lockout criteria.

Note: In a redundant deployment, you perform the procedure on the primary database station. After you perform the procedure, the primary database automatically copies the configuration change to the standby database.

The configuration change that you make in this procedure is not affected by a subsequent database upgrade.

Steps
 

Log in to the main database station as the Oracle management user or the NSP admin user.

Note: The Oracle management user name is specified during database installation; the default is ‘oracle’.


Open a console window.


Enter the following:

Note: If you are logged in as the NSP admin user, you must use sudo to run the command in this step as shown in the following:

sudo -u oracle path/command

bash$ /opt/nsp/nfmp/db/install/config/samdb/SAMDb_security.sh ↵

The following prompt is displayed:

Enter the password for the "sys" user (terminal echo is off):


Enter the Oracle SYS user password and press ↵.

The following prompt is displayed:

Please select one of the following options:

    1) Setting failed login attempts

    2) Unlock database user

    0) Exit

   Please enter(1,2 or 0):


Enter 2 ↵.

The following messages are displayed, and the Oracle database user account is unlocked.

About to unlock the database user username

Completed unlocking the database user username


Close the console window.

End of steps