Changing DB Password in Oracle SQL Developer

While working with Oracle SQL Developer, you may encounter the following message when the password is near expiration.

 

5

 

A database warning was encountered performing the requested operation:

 

ORA-28002: the password will expire within 5 days

28002. 00000 -  "the password will expire within %s days"

*Cause:    The user's account is about to expire and the password

           needs to be changed

*Action:   change the password or contact the DBA

Vendor code 28002

 

 

To change the password:

1. Open the Connections tab (View > Connections)
2. Right click the database where the password needs to be changed
3. Select “Reset Password…”

 

 

4. A pop-up form (see below) will appear prompting for the old and new passwords.

 

 

That’s it.  Seems simple but if you’re not familiar with SQL Developer, this can be a frustrating.