Oracle - How do you change your Oracle database password?

Here are several methods for changing or resetting the password for an Oracle database. You will need to know the existing password.

Method 1: Using SQL*Plus (command line tool)

  1. At the command line, enter sqlplus user@database, where user is your user ID, and database is the specific database you are connecting to.
  2. Enter your current password.
  3. Once you have connected to the database, use the password command to change your database password.
SQL> password 
Changing password for <user>  
Old password: 
New password: 
Retype new password: 
Password changed 
SQL>

Method 2: Using the TOAD GUI

  1. Connect to your Oracle database from within TOAD.
  2. Select Session -> Change Password
    toad1

  3. Enter your old password and new password and click Execute
    toad2

Method 3: Using the TOAD command line

  1. Connect to your Oracle database from within TOAD.
  2. Open a SQL Editor window
  3. Type keyword password and run.  It will pop up a password change window.

Method 4: Using SQL Developer

  1. Connect to your Oracle database from within SQL Developer.
  2. Open a SQL Editor window
  3. Type keyword password and run.  It will pop up a password change window.
    sqldeveloper

See Also


Keywords:
Oracle resetting updating update db interactive reporting sqlplus requirements AITS ORA-28000 
Doc ID:
85144
Owned by:
Christopher N. in University of Illinois System
Created:
2018-08-22
Updated:
2021-05-03
Sites:
University of Illinois System