Showing posts with label Unlock Database Account. Show all posts
Showing posts with label Unlock Database Account. Show all posts

Tuesday, November 3, 2020

Change or Unlock password for Oracle using SQLPLUS (Command Prompt)

Enter a command similar to the following, where "account" is user account to unlock and "password" is the new password:

Open Command Prompt and type below 2 commands

Command #1: sqlplus sys as sysdba

Command #2: Password is ?? system

Syntax:

ALTER USER account IDENTIFIED BY password ACCOUNT UNLOCK;

Example:

ALTER USER wms94 IDENTIFIED BY wms94 ACCOUNT UNLOCK;

Popular Posts