Oracle: Change Your Password

There are multiple ways to update your Oracle database password. Follow the steps that best match your situation. 

In this article:

• Oracle Password Requirements
• Changing Your Password with SQL*PLUS or Other Command Line Utility
• Changing Your Password with SQL Developer
• Changing Your Password with TOAD

Oracle Password Requirements

Password policies in the Oracle databases require passwords for those that do not authenticate using DUO to meet the following criteria:

• Must be 16 characters or longer in length
• New password must differ from the previous password by at least 4 characters
• Contain characters from at least 3 of the following categories:
  • Uppercase letters
  • Lowercase letters
  • Numbers
  • Special characters

Additionally, passwords for those who do not authenticate with DUO will expire after 365 days.

You can check the last date/time their password was changed by running the following SQL:

Select PASSWORD_CHANGE_DATE from USER_USERS;

If you have an Oracle password you will be notified when the password will expire in 30 days, 14 days, 7 days and 1 day.

Changing Your Password with SQL*PLUS or Other Command Line Utility

1. Establish a connection to the database where you will be changing your password. 
2. Once you have a SQL prompt, enter the following command:
   password 
3. Hit Enter. 
4. Enter your current password in the Old password field.
5. Enter your new password in the New password field and confirm the new password in the Retype new password field. 
6. Hit Enter. You will receive a confirmation message that Password changed. 
   

Changing Your Password with SQL Developer

1. Establish a connection to the database where you will be changing your password.
2. Once you have a SQL Worksheet open, enter the following command, and run as a script:
   password
3. In the new window, enter your current password in the Changing password for [your database account] Old password field. 
4. Enter your new password in the New password field and confirm the new password in the Retype new password field. 
5. Select Apply to save.
   

Changing Your Password with TOAD

1. Establish a connection to the database where you will be changing your password.
2. Once you have a SQL Editor open, enter the following command, and run as a script:
   password
3. In the new Change Password window, enter your current password in the Old Password field. 
4. Enter your new password in the New Password field and confirm the new password in the Verify Password. 
5. Select OK to save.