Database Management - Changing the Oracle Database Password (includes EPM)
Here are 2 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)
- Launch SQL*Plus. Note: be sure you're not actively connected to the database for which you're attempting to change credentials for.
- In the command line, enter sqlplus user@database, where user is your user ID, and database is the specific database you are connecting to
- Enter your current password
- Once you have connected to the database, type in your new password and re-enter once more to complete the update
Method 2: Using Oracle SQL Developer (graphical user interface)
- In SQL Developer, right-click on the database name
- Click on Reset Password
- In the pop up window, enter your Current Password, then enter your New Password and Confirm Password
Hints and Tips
- you may need to use all 4 requirements: upper case, lower case, numeral and punctuation
- if you use special characters, try using: # or @
UW System Password Guidelines
The requirements are:
- Password length must be between 16-30 characters
- Must contain 3 of the following 4 requirements:
- capital letter
- lower case letter
- number
- or special character (~ ` @ # $ % ^ & * ( ) + = | [ ] { } ? < >)
- Cannot have been used as one of your last 99 passwords
- May not contain your user ID
The UWSA password guidelines can be found on the UWSA Password Self-Service web page found here: here
UW System Administrative Procedure 1030.A Information
This webpage contains in-depth information on the authentication methods used to secure the systems covered by the UW System information security policies.