How to Unlock Oracle User Account in Linux?

Unlocking an Oracle user account in Linux is a straightforward process that involves using the sqlplus command-line utility. Here's how to do it:

Connect to the Oracle database: Open a terminal and use the sqlplus command to connect to the database as the SYS or SYSTEM user.
```
sqlplus / as sysdba
```
Unlock the user account: Once connected, use the ALTER USER command to unlock the desired account. Replace <username> with the actual username:
```
ALTER USER <username> ACCOUNT UNLOCK;
```
Exit sqlplus: After unlocking the account, exit sqlplus using the EXIT command:
```
EXIT;
```

Now, the user account is unlocked, and the user can log in to the Oracle database.

Example:

To unlock the user account "john.doe", you would use the following command:

ALTER USER john.doe ACCOUNT UNLOCK;

Important Note: Always ensure you have the necessary privileges to unlock user accounts.

A2oz