My Oracle Support Banner

Where Can One Reset Their Password For A Connection? (Doc ID 955326.1)

Last updated on APRIL 04, 2019

Applies to:

Oracle SQL Developer - Version 1.5.4 to 1.5.0.52
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

***Checked for relevance on 23-Aug-2011***

-- Problem Statement:
When creating a connection or using an existing connection in SQL Developer 2.1, where the
password to access the schema is expired, SQL Developer does not automatically present the end
user with an option to change and/or update the expired password.

Error
An error was encountered performing the requested operation:

ORA-2800: the password has expired
Cause: The user's account has expired and the password needs to be changed
Action: change the password or contact the DBA
Vendor code 28001

-- Steps To Reproduce:
1) Create a user, or alter an existing user so that the password is set to expire:
      ALTER USER user1 PASSWORD EXPIRE;

2) In SQL Developer, create a connection with no username or password.
3) Attempt to connect as that user and the error message will be raised.

NOTE: This test was performed with no username or password. If a username is provided in the
connection, the connection will fail due to NULL password, and does not communicate with the
database to determine if the password is valid or not.

The same test performed with username and (expired) password defined in the connection raises the
same error as reported above. But in this case even if the end user is prompted to change the
password in the database, the connection definition will still hold the expired password.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.