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;

No comments:

Post a Comment

Popular Posts