Query the user status in Linux and unlock the Locked User

Query the user status in Linux and unlock the Locked User

1. If the current user is a root user, switch to the Oracle user first, enable sqlplus, and assign the dba role.

[Oracle @ oa2RedHat ~] $ Sqlplus/nolog

SQL * Plus: Release 11.2.0.1.0 Production on Fri Oct 10 16:41:26 2014

Copyright (c) 1982,200 9, Oracle. All rights reserved.

SQL> conn/as sysdba;
Connected.
SQL> select username, account_status from dba_users;

Obtain the following menu list, find the user you want, and view the status of the user. If locked, execute the following command to unlock

SQL> alter user test account unlock;

Of course, you can also use the plsql client tool to remotely connect to the database you want to unlock, use the dba role, and then perform the unlock operation on the graphical interface. This is relatively simple.

This article permanently updates the link address: