Change Your Password in Oracle

Overview

This document provides instructions for how to change your Oracle database password associated with your U-M account. (The password is different from your UMICH (Level-1) password.)

Note: These instructions apply to all databases hosted by Information and Technology Services (ITS).

High-Level Steps 

1. Connect to the database using a SQL Client program. You must use a U-M Virtual Private Network (VPN), or be using a computer with an on-campus IP address. See ITS Oracle Database Connection Information (U-M login required) for directions on how to connect.
2. Run the command below from a SQL Client program:
   alter user <Username> identified by <Newpassword>;

Note: Refer to the Oracle Password Security Requirements for more details.

3. Follow the instructions below based on the software you use to connect to the database. Instructions are provided for SQLPlus Command Line or SQL Developer, but other options are also available.

Use SQLPlus Command Line or SQL Developer to Connect to the Database

SQLPlus Command Line

1. From the command line, enter "sqlplus" followed by <enter/return>. You'll be prompted for your username.
2. Enter your <Username>@<databasename> followed by <enter/return>.
3. When prompted, enter <Current Password> followed by <enter/return>.
4. Enter password at the SQL prompt, followed by <enter/return>. You will be prompted to change your password.
5. Enter your <Old Password> and press <enter/return>. Note: You will not see the password as you type it.
6. Enter a <New Password> and press <enter/return>. Note: You will not see the password as you type it.

Note: The new password must meet the password complexity requirements.

6. Enter the <New Password> again and press <enter/return>. You will receive a confirmation that your password has changed for the database to which you were logged in.
   

SQL Developer

1. Log in to the database through the command prompt as you normally would.
2. Enter your <Username> and <Current Password>.  
3. Enter password in the SQL Worksheet window. A “New password” window will appear for you to change your password.
4. Enter your <old password> in the Old Password field.
5. Enter a <New Password> in the New Password field.

Note: The new password must meet the password complexity requirements.

6. Enter the <New Password> a second time in the Retype New Password field and click Apply. You will receive a confirmation that your password has changed for the database to which you were logged in.

Note: If you click Cancel at any time, your password will remain unchanged.