Change password in SQL Developer after ORA-28001 the password has expired

oracle oracle-sqldeveloper
Mahmoud Saleh picture Mahmoud Saleh · Jun 1, 2013 · Viewed 55.5k times · Source

When trying to connect to my database with Oracle SQL Developer, I am getting the error:

ORA-28001 the password has expired

How can I change my password in SQL Developer?

Answer

Mahmoud Saleh picture Mahmoud Saleh · Jun 1, 2013

Open SQL Developer and perform the following steps:

  1. Right click on Connections > New Connection.

    • Connection Name: sys
    • Username: sys as sysdba
    • Password: sys (or your sys password)
    • Hostname: your database server IP
    • Port: 1521
    • SID: your sid

    click connect.

  2. Expand other users, and choose the user with the expired password. Right click and "edit" the user, enter the new password and confirm it.

    If you want your password to never expire again uncheck the box for password expiry.

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

Read More